MySQL创建用户
语法:
mysql> GRANT 权限 ON 数据库名.表名 TO 用户名@登录主机 Identified by "密码";
例1:
mysql> GRANT select,insert,update,delete,execute ON *.* TO root@127.0.0.1 Identified by "123456";
例2:
mysql> GRANT ALL privileges ON *.* TO root@'%' Identified by "";
MySQL删除用户
语法:
mysql> DELETE FROM user where User='用户名' AND Host=‘登录主机’;
mysql> flush privileges;
例1:
mysql> DELETE FROM user where User='root' AND Host='127.0.0.1';
mysql> flush privileges;