"A little Pit" Mysql users, permissions, and passwords. (The created user cannot log in)

Mysql version:mysql 5.6.

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

such as the following statement:

Create user

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

Authorized:

Grant all on database.* to username.

Such a statement, you log in with name + password MySQL will be rejected.

A good habit should be formed.

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

Summary below:

In MySQL, the user + password is not a unique identity, the user + password + permissions is the only identity, the three of any combination, for the user database is a different record.

"A little Pit" Mysql users, permissions, and passwords. (The created user cannot log in)