Shulou(Shulou.com)06/01 Report--

MySQL is a multi-user managed database, which can assign different permissions to different users, which can be divided into root users and ordinary users. Root users are super administrators with all permissions, while ordinary users have specified permissions.

MySQL controls users' access to the database through the permission table. The permission table is stored in the mysql database. The main permission tables are as follows:

User,db,host,table_priv,columns_priv and procs_priv, the first thing to show you is the user table.

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

Host: hostname, one of the double primary keys. A value of% indicates that all hosts are matched. User: user name, one of the double primary keys. Password: password name.

HostUserPassword%domain_check*55B565DA3839E5955A68EA96EB735localhostdomain_check*55B565DA3839E5955A68EA96EB735127.0.0.1domain_check*55B565DA3839E5955A68EA96EB735126.26.98.25domain_check*55B565DA3839E5955A68EA96EB735localhost::1root*26C378D308851D5C717C13623EFD6localhostroot*26C378D308851D5C717C13623EFD6127.0.0.1root*26C378D308851D5C717C13623EFD6 (root,%), which means that you can log in remotely and any other terminal (root,localhost) except the server, that is, you can log in locally, that is, you can log in on the server (root,127.0.0.1), indicating that you can log in locally. That is, you can log in on the server (root,sv01), indicating that the host name is sv1, and which machine sv01 specifically refers to can be viewed in cat / etc/hostname (root,::1), indicating that this machine can log in, and the password is the same. Specific:: 1 represents meaning, to be checked

Permission column

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

Permission field name remarks Select_priv determines whether the user can select data Insert_priv through the SELECT command to determine whether the user can insert data Delete_priv through the INSERT command to determine whether the user can delete existing data through the DELETE command Update_priv to determine whether the user can modify existing data through the UPDATE command Create_priv to determine whether the user can create a new database and table Drop_priv Can users delete existing databases and tables

These are all the knowledge points about the detailed explanation of the mysql.user user table in Mysql. Thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.