### **查询授予用户(user_test)的权限** 方法一： ``` show grants for user_test; ``` 方法二： ``` select * from mysql.user where user='user_test'\G; 或 SELECT DISTINCT CONCAT('User: [', user, '''@''', host, '];') AS USER_HOST FROM mysql.user; ``` ### **查询用户信息** ~~~ SELECT User, Host, Password FROM mysql.user; ~~~ ### **查看端口** ``` show global variables like 'port'; ```