Mysql——命令

flush privileges;

删除用户及权限

drop user 用户名@‘%‘;
drop user gjh@‘120.244.144.169‘;

赋予权限

GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘访问IP‘ IDENTIFIED BY ‘数据库密码‘;

创建用户

创建userone,只能本地访问
create user userone@‘localhost‘ identified by ‘password‘;
建usertwo,可以远程访问
create user usertwo@‘%‘ identified by ‘password‘;

 

Mysql——命令

标签：drop   权限   password   删除   local   user   localhost   grant   数据