In general, this condition indicates that the ' xxx ' user does not have permission, then it needs to give the user permission.
How to open a MySQL remote account-1) first log in to MySQL with the root account
In the Windows Host, click Start menu, Run, enter "cmd", enter the console, then CD into the MySQL bin directory, and then enter the following command.
> mysql-uroot-p123456 (123456 is the root user's password.) )
How to turn on MySQL remote account-2) Create a remote login user and authorize
> Grant all privileges the on database. * to [email protected]' IP ' identified by ' 123456 ';
The above statement indicates that all permissions to the TEST_DB database are granted to root, allowing the root user to remotely log on to the IP and set the root user's password to 123456.
All parameters are analyzed below:
All privileges means giving all permissions to the specified user, which can also be replaced by assigning a specific permission, such as Select,insert,update,delete,create,drop, to be separated by a "," half-width comma between specific permissions.
Database. * Indicates which table the above permissions are for, test_db refers to the database, followed by * for all tables, it can be inferred that: for all of the database is authorized as "*. *" For all tables, for a database of all tables authorized as "database name. *", A table for a database is authorized as the database name. Table name.
Root indicates which user you want to authorize, and the user can be either an existing user or a non-existent user.
Represents the IP address that allows remote connections, or "%" if you want to limit the IP of the link.
123456 is the user's password.
How to open the MySQL remote account-3) After executing the above statement, then execute the following statement before it takes effect immediately.
> Flush Privileges;
Host ' XXX ' is not allowed to connect to this MySQL server solution