In mysql. user, what does % in host indicate? _ MySQL

What is the meaning of "%" in the host in mysql. user? bitsCN.com

What is the meaning of % in host in mysql. user?

Mysql % indicates any host, but it is only for hosts connected through TCP/IP.

Similar to mysql-h 172.16.0.3.

There are also two types:

1. localhost

2. 127.0.0.1

% Cannot replace the above two types, that is, you are using mysql-hlocalhost (equivalent to mysql

-H) is not specified. mysql-h 127.0.0.1 connects to the database, and the MySQL permission verification module uses

Use different methods.

BitsCN.com