How to change the PhpMyAdmin password
Olick
-
fouad -
fouad -
Hi,
For my MySQL database, I would like to change my password, but I don't know how to do it. I am supposed to have the same password as on the hosting site's password, but I have the old one and I no longer want it...
How to change the password of my MySQL database via PHPMYADMIN
Thank you
For my MySQL database, I would like to change my password, but I don't know how to do it. I am supposed to have the same password as on the hosting site's password, but I have the old one and I no longer want it...
How to change the password of my MySQL database via PHPMYADMIN
Thank you
Configuration: Windows XP Firefox 2.0.0.14
6 réponses
Normally, in your phpmyadmin folder (the folder where it was installed), you have a file 'config.inc.php', the password for your phpmyadmin and the one in this file must be the same.
So first, make sure you can find this file.
If you have "wamp", for example, the file is located in:
wamp\apps\phpmyadmin3.3.9\config.inc.php
Password modification:
Go to phpmyadmin -> privileges, modify the root (in "change password"), then go to the config.inc.php file and open it.
Near the beginning, you should find two lines:
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'password';
// MySQL password (only needed with 'config' auth_type)
You modify "password" by entering the one you set in phpmyadmin earlier.
There you go, I hope I have been clear enough, normally you should be able to access your databases without any problem.
So first, make sure you can find this file.
If you have "wamp", for example, the file is located in:
wamp\apps\phpmyadmin3.3.9\config.inc.php
Password modification:
Go to phpmyadmin -> privileges, modify the root (in "change password"), then go to the config.inc.php file and open it.
Near the beginning, you should find two lines:
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'password';
// MySQL password (only needed with 'config' auth_type)
You modify "password" by entering the one you set in phpmyadmin earlier.
There you go, I hope I have been clear enough, normally you should be able to access your databases without any problem.
