Change root password of MySQL

To Change root Password of mysql you can change it by using

mysqladmin command.

if you want to change or update root password then execute this command

mysqladmin -u root -p’oldpassword’ password newpassword

For example, If old password is tejas, and set new password to tejasbarot, enter:

mysqladmin -u root -p’tejas’ password tejasbarot

if you want to change password of other user of MySQL then execute this command

mysqladmin -u <your-username> -p oldpassword newpass

Enjoy :)

Share This Post
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • LinkedIn
  • StumbleUpon
  • Twitter
  • email
  • Reddit
  • RSS
  • Technorati
  • Yahoo! Buzz

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

1 Comment »

 
 

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>