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

[Artemis Voulkidis]

There is a simple and efficient way to deal with this problem if you want to login with a password:

1. Open a konsole window. For linux a common shell should be ok, windows users can use cmd or powershell.
2. Type the command

mysql -u root mysql

3. Then, the following:

mysql> UPDATE user SET password=PASSWORD("NEW_PASSWORD") WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit

Where NEW_PASSWORD is the password you want to setup.

4. You exit the shell and restart the server. You should be now able to connect to the mysql server.