Well there are a couple of ways you can do this but I am going to highlight what I use.
This sort of stuff is rarely used so this post will end up being my reference as well.
Alright lets reset your mySQL Root user password.
- Login to your *IX server as super administrator, normally called “root”
- Now stop your mySQL server.
I am using RedHat Linux so command will be
- shell> /etc/init.d/mysqld stop
- No start your server in safe mode with –skip-grant-tables option as shown below
- shell> mysqld_safe --skip-grant-tables
The reason why we used –skip-grant-tables is because your passwords are stored in Grant tables so no need to load them
- Now with another Terminal window open login to your mySQL database using the command below
We are connecting to the mysql database here where your mysql users and their credential lives.
- Now that you are in Run these commands
- mysql> update user set Password=PASSWORD('YOUR_NEW_PASSWORD') where user='root';
- mysql> FLUSH PRIVILEGES;
- Now exit from your mysql shell
- mysql> exit;
- Now stop your mysql server again (step 2).
- Start your mysql server
- shell> /etc/init.d/mysqld start
- Your password is reset now. Test it by logging into your mysql server using mysql client as below
- shell> mysql -uroot -p
- Enter Password: ENTER YOUR NEW PASSWORD HERE
- You should be able to login with your new password.
I hope this helps.