How to Reset the MySQL Root Password on Ubuntu

In this video, you i will show you how to reset MySQL Root Password in Ubuntu in a few simple steps.

[sitandchillout]

Thanks man you just saved my life, I am studying the subject by myself and AI wasnt helping. You are the best!!

[poojaganvir]

Thank you so much😊
Its really helpful, i was facing this problem for a long time

[angelrodriguez]

thanks for showing how to reset root password. You
solved my problem.

[thebackendguru]

Great video @ZacsTech
The commands he used:

mysql -V (ENSURE IT IS 8.0.32-0ubuntu0.22.04.2 WITHIN THIS RANGE OF 8. SOMETHING )
sudo /etc/init.d/mysql stop
sudo mkdir /var/run/mysqld
sudo chown mysql /var/run/mysqld
sudo mysqld_safe --skip-grant-tables& (PRESS ENTER ONCE It has shown [1])
sudo mysql --user=root mysql

[Mr.StrangeVision]

@ZacsTech Thanks, you saved me from lot of trouble.

[ashutoshsingh]

ALTER user command is not working for me it gives error as "ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'".

[raushantiwari]

0 rows matched for 'root'@'localhost'
What is the problem????

[LifeAlive]

Once I log out of mysql, I am unable to log back in. With newly set pasword.

[ShajeerMohammed-mwic]

After following this Im unable to connect through ssh to MySQL. Im getting Lost connection handshake error.

[dhruvkumar-brlp]

sudo mysql --user=root mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)