Feb 22, 2013 | MySQL, Ubuntu 12.04 Server Management
Oops! I’ve forgotten MySQL root password. 1)Stop MySQL instance (if it is running) sudo service mysql stop 2)Startup MySQL instance manually with option –skip-grant-tables and –skip-networking sudo mysqld_safe --skip-grant-tables --skip-networking 3)While MySQL is running from step 2, login to MySQL mysql --user=root mysql 4)Execute the following SQL commands to update root password Update user set Password=PASSWORD('new-password') where user='root'; flush privileges; exit; 5)Remember to stop MySQL instance executed from step 2 after you complete step 4. Lastly run MySQL normally. sudo service mysql...
