Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to install PHPMyAdmin on my server to manage my MySQL databases. Right now I have only one I want to add, but I would like to be able to manage multiple databases from the same account on PHPMyAdmin.

How would I configure PMA so I could login with "andrew" and a password of "examplepassword" instead of the annoyingly long and unchangeable database user and password I am provided (ie. db3483478234, password of random characters)? I can't seem to find an area to specify a different password than the regular database username and password.

share|improve this question
up vote 1 down vote accepted

PHPMyAdmin is just a MySQL client. Any credentials that you use to log into phpmyadmin must exist in the database.

share|improve this answer
Bummer... I ended up using the config option to auto-login to the database and protected the PHPMyAdmin directory. Seems to work ok for now and this is only a testing web server. – Andrew M Dec 29 '10 at 19:26

Any mysql user with their password can login phpMyAdmin. Once you have installed phpMyAdmin, you can login with any existing/newly created mysql username & password.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.