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