Error Code: 1045 Access denied for user 'root'@'localhost' (using password: YES) code example
Example 1: Access denied for user 'root'@'localhost' (using password: YES)
sudo /etc/init.d/mysql stop
Now start up MySQL in safe mode, so you’ll skip the privileges table:
sudo mysqld_safe
mkdir -p /var/run/mysqld
chown mysql:mysql /var/run/mysqld
Login with root:
mysql -uroot
And assign the DB that needs to be used:
use mysql;
SHOW VARIABLES LIKE 'sql_mode';
SET sql_mode = '';
SET PASSWORD FOR root = 'Dehr@dun@345';
update user set password=PASSWORD("YOURPASSWORDHERE") where User='root';
[On MySql 5.7 version you must replace query to:]
update user set authentication_string=PASSWORD("YOURPASSWORDHERE") where user="root";
flush privileges;
quit
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start
Now your root password should be working with the one you just set, check it with:
mysql -u root -p
Example 2: Error 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
sudo mysql -u root -p