[A trap] Mysql Users, permissions, and passwords. (The user you created cannot log on to.) _ MySQL

MysqlVersion: the permissions of users in Mysql56Mysql are related not only to users, but also to user logon passwords. For example, the following statement creates a user createusername @ localhostidentifiedbypassword to authorize Mysql Version: Mysql 5.6.

The user permissions in Mysql are not only related to the user, but also to the user's login password (password.

For example, the following statement:

Create User

Create user 'name' @ 'localhost' identified by 'password '.

Authorization:

Grant all on database. * to username.

Such a statement is denied when you log on to Mysql using name + password.

Good habits should be developed.

Grant all on database. * to username identified by 'password '.

Summary:

In Mysql, user + password is not a unique identifier, and user + password + permission is the unique identifier. any combination of the three is a different record for the user database.