MySQL Login hint error 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no

Install Zabbix today, after the installation is complete, the top tips are as follows

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5D/19/wKiom1Uh8DfBemroAABJXRKhz7c091.jpg "title=" 1.png " alt= "Wkiom1uh8dfbemroaabjxrkhz7c091.jpg"/>

The check log is displayed as follows

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5D/14/wKioL1Uh8fmwaxMpAAJw0PRpHBk693.jpg "title=" 2.png " alt= "Wkiol1uh8fmwaxmpaajw0prphbk693.jpg"/>

Failed to show connection to database, login MySQL to Zabbix authorization to find Zabbix completely up and down

Database is not logged in, prompting ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no)

The database refused root login, so the authorization table was skipped and the command was as follows: Mysqld_safe--user=mysql--skip-grant-tables--skip-networking & (Of course, before that, Stop running the MySQL service first).

Then log in to Mysql:mysql-uroot-p

After logging in:

mysql> use MySQL;
mysql> UPDATE user SET Password = Password (' yourpassword ') WHERE user = ' root ';
mysql> FLUSH privileges;

Then restart the MySQL services: Service mysqld Restart after the normal login to MySQL, Zabbix also return to normal.

This article is from the "Lemon" blog, be sure to keep this source http://xianglinhu.blog.51cto.com/5787032/1629197

MySQL Login hint error 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no