Auto-login phpMyAdmin

php mysql cookies login phpmyadmin
www.data-blogger.com picture www.data-blogger.com · Apr 16, 2011 · Viewed 32.5k times · Source

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

Arun Kushwaha picture Arun Kushwaha · Jun 16, 2014

Add code in config.inc.php below of /* Authentication type */. It exists in the root folder 

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';

Related questions

phpmyadmin automatic logout time

How can I change the phpmyadmin automatic log out time? It will log out automatically after 1440 seconds which is very low for me. How can I change the option or remove log in request completely?

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Read More