一、查看用户
1、显示当前使用的user及host:
mysql>select USER();
2、显示该数据库授权登陆的用户名(不显示重复用户名):
mysql>use mysql;
mysql>select distinct(User) from user;
3、显示该数据库授权登陆的用户名及host限制:
(1)方法一:
mysql>use mysql;
mysql>select User,host from user;
(2)方法二
mysql>select user,host from mysql.user;
4、显示该数据库授权登陆的用户的全部信息:
mysql>select * from mysql.user;
5、列出为某MySQL用户账户复制权限时必须发布的GRANT语句:
mysql>show grants for 'username'@'yourhost';
二、添加用户
1、添加一个本地管理员用户:
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'somepassword' WITH GRANT OPTION;
2、添加某数据库的管理员用户:
mysql> GRANT ALL PRIVILEGES ON databasename.* TO username@localhost IDENTIFIED BY 'somepassword';
3、添加远程用户:
mysql> GRANT ALL PRIVILEGES ON *.* TO username@192.168.8.9 IDENTIFIED BY 'somepassword';
4、添加任何机器都能登录的用户:
mysql> GRANT ALL PRIVILEGES ON *.* TO username@% IDENTIFIED BY 'somepassword';
5、添加一个用户并授权增、删、改、查:
mysql> GRANT select,delete,insert,update ON databasename.* TO username@localhost IDENTIFIED BY 'somepassword';
三、删除用户
1、取消一个用户的权限,此用户仍然保留
mysql>revoke all on *.* from username@localhost;
2、删除一个用户
mysql>DELETE FROM user WHERE User='user_name' and Host='host_name';