兩種MySQL查詢用戶權限的方法

mysql>?show?grants?for?username@localhost; +---------------------------------------------------------------------+ |?Grants?for?root@localhost???????????????????????????????????????????| +---------------------------------------------------------------------+ |?GRANT?ALL?PRIVILEGES?ON?*.*?TO?'root'@'localhost'?WITH?GRANT?OPTION?| +---------------------------------------------------------------------+

mysql>?select?*?from?mysql.user?where?user='root'?and?host='localhost'?G; ***************************?1.?row?*************************** ??????????????????Host:?localhost ??????????????????User:?root ??????????????Password:?********************** ???????????Select_priv:?Y ???????????Insert_priv:?Y ???????????Update_priv:?Y ???????????Delete_priv:?Y ???????????Create_priv:?Y ?????????????Drop_priv:?Y ???????????Reload_priv:?Y ?????????Shutdown_priv:?Y ??????????Process_priv:?Y ?????????????File_priv:?Y ????????????Grant_priv:?Y ???????References_priv:?Y ????????????Index_priv:?Y ????????????Alter_priv:?Y ??????????Show_db_priv:?Y ????????????Super_priv:?Y ?Create_tmp_table_priv:?Y ??????Lock_tables_priv:?Y ??????????Execute_priv:?Y ???????Repl_slave_priv:?Y ??????Repl_client_priv:?Y ??????Create_view_priv:?Y ????????Show_view_priv:?Y ???Create_routine_priv:?Y ????Alter_routine_priv:?Y ??????Create_user_priv:?Y ????????????Event_priv:?Y ??????????Trigger_priv:?Y Create_tablespace_priv:?Y ??????????????ssl_type: ????????????ssl_cipher: ???????????x509_issuer: ??????????x509_subject: ?????????max_questions:?0 ???????????max_updates:?0 ???????max_connections:?0 ??max_user_connections:?0 ????????????????plugin:?mysql_native_password ?authentication_string: ??????password_expired:?N 1?row?in?set?(0.01?sec)