MySQL ERROR 1045 (28000): Workaround for the Access denied for user

Problem Description:

The following error appears when you connect the 10.240.210.188 database remotely on 10.240.210.60 today

MySQL ERROR 1045 (28000): Access denied for user

After searching the internet, it is because 10.240.210.188 did not give 10.240.210.60 this machine to give the connection permission caused.

"Solution"

2. On the 10.240.210.188 connected to MySQL
   

   [Email protected] ~]# Mysql-uroot-ppassword

3. Give 10.240.210.60 connection permissions

   1) View permission information
   

   Mysql> Show grants;
   +-------------------------------------------------------------------------------------------------------------- --------------------------+
   |                                                                                                              Grants for [email protected] |
   +-------------------------------------------------------------------------------------------------------------- --------------------------+
   | GRANT all privileges on * * to ' root ' @ ' localhost ' identified by PASSWORD ' *83947472a627808d9fc03023210c4c369f0caa5d ' with GRANT OPTION |
   | Grant PROXY on "@" to "root" @ ' localhost ' with GRANT OPTION
   2) Give appropriate permission

   Mysql> GRANT All privileges on * * to ' root ' @ ' 10.240.210.60 ' identified by PASSWORD ' *83947472a627808d9fc03023210c4c36 9f0caa5d ' with GRANT OPTION;

   Query OK, 0 rows Affected (0.00 sec)
   
   mysql> flush Privileges; Refreshing the database
   Query OK, 0 rows Affected (0.00 sec)

5. Re-connect
   

   650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/73/60/wKioL1X7s_yyqqAZAAQ9eQs_d4Y073.jpg "title=" Qq20150918143924.jpg "alt=" Wkiol1x7s_yyqqazaaq9eqs_d4y073.jpg "/>
   

MySQL ERROR 1045 (28000): Workaround for the Access denied for user