MySQL permission table Introduction

The MySQL permission table introduced below is used to control user access to the database. If you are interested in the MySQL permission table, you may wish to take a look and I believe you will not be concerned about it.

The MySQL server uses the MySQL permission table to control user access to the database. The MySQL permission table is stored in the mysql database and initialized by the mysql_install_db script. These MySQL permission tables are user, db, table_priv, columns_priv, and host respectively. The following describes the structure and content of these tables:

User permission table: records the information of user accounts allowed to connect to the server. The permissions in the table are global.

Database permission table: records the operation permissions of each account on each database.

Table_priv permission table: records data table-level operation permissions.

Columns_priv permission table: records the operation permissions at the data column level.

Host permission table: the database permission table provides more detailed control over database-level operation permissions on a given host. This permission table is not affected by the GRANT and REVOKE statements.
 

Instances that grant MySQL user permissions

How to optimize mysql Indexes

How to view MySQL Indexes

Use of MySQL EXPLAIN statements

Take you to understand the mysql index type