mysql ERROR 1045 (28000): Access denied for user的解決方案

標籤：mysql

問題描述：

今日在10.240.210.60上面遠端連線10.240.210.188的資料庫時，彈出以下報錯

mysql ERROR 1045 (28000): Access denied for user

上網搜尋後瞭解到，是由於10.240.210.188沒有給10.240.210.60這台機器賦予串連許可權引起的。

【解決辦法】

1. 在10.240.210.188連上mysql
   

   [[email protected] ~]# mysql -uroot -ppassword

2. 賦予10.240.210.60串連許可權

   1）查看許可權資訊
   

   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）賦予相應許可權

   mysql> GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘10.240.210.60‘ IDENTIFIED BY PASSWORD ‘*83947472A627808D9FC03023210C4C369F0CAA5D‘ WITH GRANT OPTION;

   Query OK, 0 rows affected (0.00 sec)
   
   mysql> flush privileges;     重新整理資料庫
   Query OK, 0 rows affected (0.00 sec)

3. 重新串連即可
   

   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): Access denied for user的解決方案