We just changed the password for one of our databases via command line. Plesk is installed on the server and so is phpMyAdmin. The problem is that we can't figure out where the password/config file is stored so that we can access the database using phpMyAdmin. It seems like Plesk has hidden it somewhere.

We need to update the password/config file so that we can access phpMyAdmin. Right now we are getting the following error when trying to use phpMyAdmin:

Error

MySQL said:


Access denied for user: 'myusername@localhost' (Using password: YES)

Any help would be appreciated!

Changing a password for a MySql database on a Plesk server is not a good idea as it will put Plesk out of sync with the MySql server - this task needs to be done through the Plesk control panel.

Plesk does not store database passwords for user databases in a file - it stores them in the db_users table in the psa database - if you have phpMyAdmin installed seperate from the one that Plesk provides so that you can access the psa database, you can see the original user's password in that table, but you'll have to reset it back tp the original one set in Plesk, and then use Plesk to change it.

You could also change it in the user table in the mysql database in phpMyAdmin but don't forget to tell phpMyAdmin that the filed is a password, as passwords in mysql are encrypted - in the psa database they are not.

OK, if I understand you correctly then there is not a config file to be found? But rather a table field that holds the phpmyadmin login info? We have a local version of our database using phpmyadmin here in the office without Plesk running maybe this would explain the confusion?

I think the last time we changed the password for phpmyadmin on the server we did not use Plesk, but can't remember what we did.

Hi, I am not sure if this is what you meant but, I went in via command line and updated the psa database directly. I changed the password in the db_user table to the correct password and am now able to use phpMyAdmin. Thanks for the help.

One final question. When looking at the password in the db_user table in the psa database the password is not encrypted. How then is the password safe when using phpMyAdmin? It looks like all the databases created by Plesk did this way.