MYSQL Access denied for user error

Http://jingyan.baidu.com/article/597a0643658c6c312b524397.html

MYSQL Access denied for user error

Method/Step

1. MySQL remote connection when "Access denied for user **@**" error, make me very big, and later found out to solve the method. Record, afraid to forget again later:

2. First log in to MySQL locally, then execute both code: GRANT all privileges on * * to [email protected] '% ' identified by ' 000000′; FLUSH privileges; Format: Grant permission on the database name. Table name user @ Login host identified by "User password";

3. Parameter Description: All privileges represents the permissions assigned to Telnet users, all privileges represents all permissions, and you can assign Select,update,insert,delete permissions individually or in combination; *. *: First * Indicates the name of the database to be empowered, * of course, all the databases, the second * represents the table name under the database, the same, * for all tables, lazy people like me, of course, will use * *, anyway, they are developed with

4. 4

   Root indicates the user to be empowered;% means remote login IP, if you want to restrict login IP, here to add you allow login IP, such as 192.18.1.99, etc.,% means no limit IP (again lazy), 000000 is the user telnet password. It's so simple. This sentence runs after running flush privileges, done!

MYSQL Access denied for user error