MySQL user logon

Creating a user testuser @ % in the database cannot log on locally. The reason is that the user table of the MySQL database has the following data:

 

When you log on, the system compares the host with the user and then verifies the password.

If you log on with the username testuser, you will first find the localhost, and then you will not be able to find the user, so you cannot log on.

To allow testuser to log on locally, add testuser @ localhost.

In addition, you can log on to MySQL locally without using a username. The above @ localhost is used.