How to reset mysql root password on linux

Reset MySQL database root password

This video shows how to reset password for the root user in MySQL database in case the password was forgotten

Step by step:--
Step 1:- Stop MySQL
sudo service mysql stop

Step 2:- Make MySQL service directory.
sudo mkdir /var/run/mysqld

Step 3:- Give MySQL user permission to write to the service directory.
sudo chown mysql: /var/run/mysqld

Step 4:- Start MySQL manually, without permission checks or networking.
sudo mysqld_safe --skip-grant-tables --skip-networking &

Step 5:- Log in without a password.
mysql -uroot mysql

Step 6:-For change password

Step 7:-flush privileges;

Step 8:- Start the MySQL service normally.
sudo service mysql start

Step 9:-sudo mysql -u root -pnewreset_password

Thank you for watching

[ibahas]

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (13)

[josuesauca]

Thanks man it really work for me <3 <3 <3

[davidevcpp]

Got problem in step6 when I've got to update the password. I get this error: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(`newreset_password`) WHERE User = 'root' AND Host = 'localhost' ' and I don't know how to move forward