Home >Database >Mysql Tutorial >How to check user permissions in mysql
Mysql method to check user permissions: You can check user permissions by executing the [show grants for username] statement, such as [show grants for root;].
View the permissions of a MySQL user:
(Recommended tutorial: mysql video tutorial)
show grants for 用户名 MariaDB [neutron]> show grants for root;
As shown:
Related recommendations: mysql tutorial
The above is the detailed content of How to check user permissions in mysql. For more information, please follow other related articles on the PHP Chinese website!