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‘;