Syed Jahanzaib Personal Blog to Share Knowledge !

November 14, 2009

MYSQL: Howto Change root password!

Filed under: Linux Related — Syed Jahanzaib / Pinochio~:) @ 6:45 AM

Mysql Password Recovery

Short References for Mysql Passwords related issues:


Mysqladmin command to change root password

If you have never set a root password for MySQL, the server does not require a password at all for connecting as root. To setup root password for first time, use mysqladmin command at shell prompt as follows:

mysqladmin -u root password NEWPASSWORD

However, if you want to change (or update) a root password, then you need to use following command

mysqladmin -u root -p'oldpassword' password newpass

For example, If old password is abc, and set new password to 123456, enter:

mysqladmin -u root -p'abc' password '123456' 


If you dont know the old mysql ROOT password and want to reset it, follow these steps !

First of all you will need to ensure that your database is stopped:

/etc/init.d/mysql stop

ps -A | grep mysql

Now you should start up the database in the background, via mysqld_safe syntax

sudo mysqld_safe --skip-grant-tables &

Now that the server is running with the --skip-grant-tables flag you can connect to it without a password and complete the job:


Use the following commands to change the password of mysql root user

UPDATE mysql.user SET Password=PASSWORD(‘new_password’) WHERE User=’root’;

sudo pkill mysql*

Now start the MYSQL

service mysql start

Now everything should be done and you should have regained access to your MySQL database(s); you should verify this by connecting with your new password:

mysql -u root -p

If you’d like to automate this process you could start by looking at this simple shell script which will allow you to reset a password with one command.



  1. i did it, but not working, i think some commands are missing :S


    Comment by Mikheil — July 15, 2011 @ 10:32 PM

    • What exactly you wanna do ? do you want to change the first time default mysql password? or want to change the old mysql passwd?


      Comment by aacable — July 17, 2011 @ 5:52 AM

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: