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
1shell> /etc/init.d/mysqld stop
- Now start your server in safe mode with –skip-grant-tables option as shown below
12345shell> mysqld_safe --skip-grant-tables/pre>The reason why we used <strong>--skip-grant-tables </strong>is because your passwords are stored in Grant tables so no need to load them<</li><li> Now with another Terminal window open login to your mySQL database using the command below<pre>shell> mysql -uroot mysql
We are connecting to the mysql database here where your mysql users and their credential lives.
- Now that you are in Run these commands
12mysql> update user set Password=PASSWORD('YOUR_NEW_PASSWORD') where user='root';mysql> FLUSH PRIVILEGES;
- Now exit from your mysql shell
- Now stop your mysql server again (step 2).
- Start your mysql server
1shell> /etc/init.d/mysqld start
- Your password is reset now. Test it by logging into your mysql server using mysql client as below
12shell> mysql -uroot -pEnter Password: ENTER YOUR NEW PASSWORD HERE
- You should be able to login with your new password.
I hope this helps.