Hui WANG's Blog

At the moment of writing this tutorial, I am working as an intern on the integration of an old database into the one of WordPress 2.8.3. In order to protect my private password which I have set for the MySQL root, I want to change it as a simple public one through PHPMyAdmin panel. Unluckily, I didn’t make it. But after a glance at the PHPMyadmin documents, I got hwo tho change PHPMyAdmin  Password.

In fact, When a user logs in to phpMyAdmin, that username and password are passed directly to MySQL. phpMyAdmin does no account management on its own (other than allowing one to manipulate the MySQL user account information); all users must be valid MySQL users.

So, to change the PHPMyAdmin login password, change it in MySQL.

1) Login to mysql server, type 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 root:

mysql> set password = password("yournewpassword");

or for user “whuisonline“:

mysql> update user set password=PASSWORD("NEWPASSWORD") where User='whuisonline';

4) Reload privileges:

mysql> flush privileges;
mysql> quit

We get it!