Detailed Explanation of mysql. user User Table in Mysql

MySQL is a database managed by multiple users, which can assign different permissions to different users, including 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, which 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 MySQL database)

Host: Hostname, 1 of double primary keys, a value of% means all hosts are matched. User: User name, 1 of double primary keys. Password: Password name.

Host	User	Password
%	domain_check	*55B565DA3839E5955A68EA96EB735
localhost	domain_check	*55B565DA3839E5955A68EA96EB735
127.0.0.1	domain_check	*55B565DA3839E5955A68EA96EB735
126.26.98.25	domain_check	*55B565DA3839E5955A68EA96EB735
localhost
::1	root	*26C378D308851D5C717C13623EFD6
localhost	root	*26C378D308851D5C717C13623EFD6
127.0.0.1	root	*26C378D308851D5C717C13623EFD6

(root,%), which means you can log in remotely and is 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), which means you can log in locally, that is, you can log in on the server (root, sv01), which means that the host name is sv1 can log in. Which machine sv01 specifically refers to can be viewed in cat/etc/hostname (root,:: 1), indicating that this machine can log in, see the password is the same, specific:: 1 represents the meaning, to be checked

Permission column

The permissions column determines the user's permissions and describes the operations that the user is allowed to perform on the database and database tables in the global scope. The field types are enumerated Enum, and the values can only be Y or N. Y means permissions, and N means no permissions.

权限字段名称	备注说明
Select_priv	确定用户是否可以通过SELECT命令选择数据
Insert_priv	确定用户是否可以通过INSERT命令插入数据
Delete_priv	确定用户是否可以通过DELETE命令删除现有数据
Update_priv	确定用户是否可以通过UPDATE命令修改现有数据
Create_priv	确定用户是否可以创建新的数据库和表
Drop_priv	确定用户是否可以删除现有数据库和表

The above is about Mysql mysql. user user table details of all knowledge points, thank you for your support of this site.