How to , and other stuff about linux, photo, php … Another blog just like others on internet

June 11, 2012

How to change MySql root password

Filed under: Linux — Tags: , , — admin @ 2:28 pm

1) Login to mysql server, type the following command at shell prompt:
$ mysql -u root -p
2) Use mysql database (type command at mysql> prompt):
mysql> use mysql;
3) Change password for user root, enter:
mysql> update user set password=PASSWORD("NEWPASSWORD") where User='root';
4) Finally, reload the privileges:
mysql> flush privileges;
mysql> quit

How to change MySql root password
Rate this post

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress