Sometime I have this problem: Access denied for user ‚root’@’localhost’ (using password: NO) I have described solution below:
- Start the mysql client process using this command (sudo /etc/init.d/mysql start):
mysql -u root
- Execute this command to be able to change any password:
FLUSH PRIVILEGES;
Then reset/update your password:
SET PASSWORD FOR root@'localhost' = PASSWORD('password');
If we have a mysql root account that can connect from everywhere, you should also do:
UPDATE mysql.user SET Password=PASSWORD('newpassword') WHERE User='root';
Alternate Method:
USE mysql UPDATE user SET Password = PASSWORD('newpassword') WHERE Host = 'localhost' AND User = 'root';
And if you have a root account that can access from everywhere:
USE mysql UPDATE user SET Password = PASSWORD('newpassword') WHERE Host = '%' AND User = 'root';
- Or faster:
USE mysql;
FLUSH PRIVILEGES;
UPDATE user SET Password = PASSWORD(‚dupa’) WHERE Host = ‚%’ AND User = ‚root’;
Then stop/restart the mysqld process:
sudo /etc/init.d/mysql stop sudo /etc/init.d/mysql start
or
sudo /etc/init.d/mysql restart