How to check MySQL database system privileges?

How to check the system privileges of MYSQL database? Many friends have incorrect permissions and cannot access when using mysql. In fact, it may be that your mysql does not have remote access permissions and only has localhost access permissions. Now I will demonstrate how to check the MYSQL database system privileges.

How to check the MYSQL database system privileges

1. After opening the Windows operating system, click the start menu in the lower left corner, and in the pop-up menu Find the installed mysql, and then click to start mysql, as shown in the figure below.

2. Click to open the DOS login box of mysql, enter your mysql password, and then press Enter, as shown in the figure below.

3. After entering the correct password and successfully logging in, use the command: use mysql, as shown in the figure below.

This is because mysql permissions are recorded here.

4. Enter and press Enter. If database changed appears in the window, the switch has been successful. Now, use the command: show tables to view the tables under mysql, as shown in the figure below.

5. After using the show tables command, all tables will be queried. At this time, you can see a user in the last name. This user The table records mysql permissions. As shown below.

6. Use the command: select * from user; enter and press Enter, as shown in the figure below.

##7.OK, mysql will display the permissions of all users mysql, as shown in the figure below .

8. The display as above is messy and it is not easy to check the permissions. At this time we can use the command: desc user, to view the fields of the user table, and then select the ones you need, as shown in the figure below.

9. Here we need to check the permissions of mysql, so use the command directly: select user, host form user. You can query the corresponding permissions of the mysql user. As shown below.

The above is the detailed content of How to check MySQL database system privileges?. For more information, please follow other related articles on the PHP Chinese website!