Micro-Recipe: Ubuntu Mysql Root Password Restoring
Here are the bare bone commands to restore your mysql root password ->
-
/etc/init.d/mysql stop
-
/usr/bin/mysqld_safe –skip-grant-tables &
-
mysql -u root mysql
-
mysql> UPDATE user SET Password=PASSWORD('newpassword') WHERE User='root';
-
mysql> FLUSH PRIVILEGES;
-
mysql> exit;
Testing if it works ->
-
/etc/init.d/mysql restart
-
mysql -u root -p
-
Enter password:
-
mysql> You win !
Then add a mysql user with all privileges ->
-
mysql -u root -p
-
mysql> GRANT ALL PRIVILEGES ON *.* TO 'login'@'localhost' IDENTIFIED BY 'pass' WITH GRANT OPTION;
-
mysql> FLUSH PRIVILEGES;
