How to view table permission settings in mysql

Mysql method to view table permission settings: 1. Create a new query in Navicat’s mysql database [select * from mysql.user]; 2. Open cmd and enter mysql, and execute [show grant for your user].

Mysql method to view table permission settings:

1. Create a new query in navicat’s mysql database: select * from mysql.user (or directly view the user table in mysql)

2. Open cmd and enter mysql>, execute show grant for your user (such as: show grant for root@'localhost')

Related free learning recommendations: mysql video tutorial

The above is the detailed content of How to view table permission settings in mysql. For more information, please follow other related articles on the PHP Chinese website!