[Solved] best way to reset MYSQL root password on Ubuntu

Iron_MAN

I cannot guarantee it works for all, but it at least perfectly works for me !

1. Use tool (I used WinSCP) to open
/etc/mysql/mysql.conf.d/mysqld.cnf

2. Add skip-grant-tables under
[mysqld]
...
kip-external-locking


3. Restart MySQL service by entering sudo service mysql restart on your terminal (I used PuTTY)


4. Enter mysql on PuTTY to enter MYSQL


5. Enter use mysql (switch to mysql database)

use mysql

6. Change root password to '123456', enter
UPDATE mysql.user SET authentication_string=password('123456') WHERE User='root' AND Host ='localhost';


7. Update plugin
UPDATE user SET plugin="mysql_native_password";


8. Flush privileges
flush privilege


9. Remove or remark skip-grant-tables from /etc/mysql/mysql.conf.d/mysqld.cnf


10. Restart MYSQL service again to take effect


11. Now you will be able to access MYSQL or phpMyAdmin with root and the new password '123456'

phpMyAdmin

---------------------
Author：DesmondChow@oncity
May this helps, no copyright at all lol