Kevin Kevin - 6 months ago 32
MySQL Question

Auto-login phpMyAdmin

We want to auto login users in phpMyAdmin. Now we have a web-interface, written in PHP. Users can login. After logging in, they can click on the

SQL
link in the menu that opens phpMyAdmin. Is there a way to log them in automatically? Is it possible to set cookies for phpMyAdmin or something to let them use it?
We don't want to turn off phpMyAdmin's login; each user has his own MySQL user/pass combination. So we need to pass the username/password settings to phpMyAdmin.

Answer

You can simply post the username in a field named pma_username and the password in pma_password. Or, if you're using http auth mode you can create a link with username and password like http://user:pass@www.host.com/phpmyadmin/...

There is also a phpmyadmin native single sign-on solution!