Solve the problem related to ERROR 1045 (28000) reported during database connection.

Solve the problem related to ERROR 1045 (28000) reported during database connection.

Install the mysql database on the Centos server today and run the connection command after installation.

mysql -uroot -p

And then throw the following command:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I have installed a mysql database before, and the default password is empty. After installation, I cannot use a blank password. After reading the information, we have the following solutions:1. Stop the mysql process first.

/etc/rc.d/init.d/mysqld stop

2. Enter the following command:

mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

3. Press enter to enter the next command line and connect to the database.

mysql -u root mysql

4. Go to the mysql database and run the following command to change the database password:

Update user set password = password ('Password') where user = 'user' flush privileges

5. Restart the mysql database.

systemctl start mysql

6. log on to the database with a new password to solve the problem.