ERROR1045 (28000): Accessdeniedforuser 'root' @ 'localhost

ERROR1045 (28000): Accessdeniedforuser

ERROR 1045 (28000): Access denied for user

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

This problem is also a problem left over when installing the mysql database in Linux:

After installing mysql, the user useradd mysql does not need a password to log on to the mysql database. The root user needs a logon password.

When joomla is put under hotdocs this time, restore the database:

Mysql <joomla. SQL

The following error is prompted:

It means that the root user cannot access the database without a password. What should I do? Change Password:

1> enter mysql

Mysql-u root-p

Dell_456

2> change password:

Set password for 'root' @ 'localhost' = password ('') Here it is actually Set to an empty password

Flush privileges;

This statement indicates that you need to use flush privileges to refresh a user in mysql after setting the user or changing the password.

Mysql system permission table. Otherwise, access is denied. Another method is to restart the mysql server.

To make the settings take effect.

,