How to , and other stuff about linux, photo, php … A linux, photography blog. To remember some linux situation, and fix them quickly.

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

Powered by WordPress