It is easy to forget the root password as it is advised to use the user account for security reason. Today, I needed to access my MySQL database as root, but I could not remember the password. After searching for a solution, I found this method to be awesome:
1. Run the server with –skip-grant-tables option so that you can log in without a password.
# /etc/init.d/mysqld stop # mysqld_safe --skip-grant-tables & $ mysql -u root
2. Reset the root password.
mysql> use mysql; mysql> update user set password=PASSWORD("YOUR-NEW-ROOT-PASSWORD") where user='root'; mysql> flush privileges; mysql> quit
3. Restart MySQL and log in using your new root password.
# /etc/init.d/mysqld stop # /etc/init.d/mysqld start
#mysql -u root -p