[A trap] Mysql users, permissions, and passwords. (The created user cannot log in), mysql Login

[A trap] Mysql users, permissions, and passwords. (The created user cannot log in), mysql Login

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.

MYSQL creates an account with the specified access permission

You can see the link clearly.
Dev.mysql.com/...system
 
In mysql, you cannot create a database.

You can
Self-designed SQL design table
When the experts are full
Use dos
Method 1:

Log on to the MySQL Server using the MySQL Adminstrator GUI Tool, but the Server returns the error message Host '60-248-32-13.hinet-ip.hinet.net 'is not allowed to connect to this

MySQL server

This is because of permission issues. The solution is as follows:

Shell> mysql -- user = root-p

Enter Password

Mysql> use mysql

Mysql> grant select, INSERT, UPDATE, delete on [db_name]. * TO [username] @ [ipadd] identified by '[password]';

[Username]: User code for remote login

[Db_name]: indicates the name of the database to be opened to the user.

[Password]: User password for remote login

[Ipadd]: The DNS Name after IP address or IP address reverse lookup. In this example, enter '60-248-32-13.hinet-ip.hinet.net '. Enclose the quotation marks (')

(In fact, it is executed on the remote server. Fill in the IP address of the local host .)

If you want to open all permissions, execute:

Mysql> update user set select_priv = 'y', Insert_priv = 'y', Update_priv = 'y', delete_priv = 'y', Create_priv = 'y ', drop_priv = 'y', Reload_priv = 'y', shutdown_priv = 'y', Process_priv = 'y', File_priv = 'y', Grant_priv = 'y ', references_priv = 'y', Index_priv = 'y', Alter_priv = 'y', Show_db_priv = 'y', Super_priv = 'y', Create_tmp_table_priv = 'y ', lock_tables_priv = 'y', Execute_priv = 'y', Repl_slave_priv = 'y', Repl_client_priv = 'y' where user = '[username]';

Method 2:

How to solve the connection between the client and the server (mysql): xxx. xxx is not allowed to connect to this mysql serv

1. Go to mysql and create a new user, xuys:

Format: grant permission on database name. Table name user @ login host identified by "User Password ";

Grant select, update, insert, delete on *. * to xuys@192.168.88.234 iden ...... remaining full text>