1.查看当前用户
select user();
select current_user();
2..查看mysql用户表
select user,host,password from mysql.user;
3.赋予用户权限
grant all on user_name.table_name to another_user_name identified by "another_user_name's password";
all也可以换成select、insert、delete、update.
4.收回用户权限
revoke all on user_name.table_name from another_user_name;
all也可以换成select、insert、delete、update.