Detailed explanation of mysql.user user table in Mysql

MySQL is a multi-user managed database that can assign different permissions to different users, which are divided into root users and ordinary users. The root user is the super administrator and has all permissions, while ordinary users have specified permissions.

MySQL controls user access to the database through permission tables, which are stored in the MySQL database. The main permission tables are as follows:

user,db,host,table_priv,columns_priv and procs_priv. Let's first learn about the user table.

User column (information that users need to enter to connect to the MySQL database)

Host: Host name, one of the dual primary keys. When the value is %, it means matching all hosts. User: User name, one of the dual primary keys. Password: Password name.

• (root,%), indicating that remote login is possible and any terminal other than the server
• (root,localhost), which means you can log in locally, that is, you can log in on the server
• (root,127.0.0.1 ) means you can log in locally, that is, you can log in on the server
• (root,sv01) means that the host name is sv1 and can be logged in. The specific machine sv01 refers to can be checked by cat /etc/hostname
• (root,::1) means the local machine can log in. The passwords are the same. The specific meaning of ::1 is to be checked.

Permission column

The permission column determines the user's permissions and describes the operations that the user is allowed to perform on the database and database tables globally. The field type is Enum and the value can only be Y or N. Y means permission and N means no permission.

The above is all the knowledge points about the detailed explanation of the mysql.user user table in Mysql. Thank you for your support to 123WORDPRESS.COM.