Jump to Navigation

177 - ERROR 1045 (28000) MySQL

If you got the following error, you need to reset the password.

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

 

# mysql -u root mysql

# mysql> UPDATE user SET Password=PASSWORD('your_new_password') where USER='root';

# mysql> FLUSH PRIVILEGES;

You should be able to connect with your new password.

# mysql -u root -p
Enter password: your_new_password

 



Main menu 2

Story | by Dr. Radut