windows error 1045 (28000): access denied for user 'root'@'localhost' (using password: yes)
# Stop Your Server First
sudo service mysql stop
# Make MySQL service directory.
sudo mkdir /var/run/mysqld
# Give MySQL permission to work with the created directory
sudo chown mysql: /var/run/mysqld
# Start MySQL, without permission and network checking
sudo mysqld_safe --skip-grant-tables --skip-networking &
# Log in to your server without any password.
mysql -u root mysql
# Update the password for the root user:
UPDATE mysql.user SET authentication_string=PASSWORD('YourNewPasswordBuddy'), plugin='mysql_native_password' WHERE User='root' AND Host='localhost';
#if you omit (AND Host='localhost') section, it updates the root pass regardless of its host
FLUSH PRIVILEGES;
EXIT;
#kill mysqld_safe process
sudo service mysql restart
#Now you can use your new password to login to your Server
mysql -u root -p
#take note for remote access you should create a remote user and then grant all privileges to that remote user
sudo /etc/init.d/mysql stop
Now start up MySQL in safe mode, so you’ll skip the privileges table:
sudo mysqld_safe --skip-grant-tables &
// if you face issue,[mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists] run below commands] start
mkdir -p /var/run/mysqld
chown mysql:mysql /var/run/mysqld
// end
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'; // it is working
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
