Configure phpMyAdmin to login automagicly without prompted for username and password

Submitted by n8coder on Thu, 04/29/2010 - 11:30

Do you need to configure phpMyAdmin to login automagicly without prompted for username and password? I needed two hours to get it works, do not spend so much time and just follow steps below:

1. Download PhpMyAdmin

2. unzip phpmyadmin

3. create a file named "config.inc.php" with following content and replace login information with yours

<?php
/*
 * Generated configuration file
 * Generated by: phpMyAdmin 3.3.2 setup script by Piotr Przybylski <piotrprz@gmail.com>
 * Date: Thu, 29 Apr 2010 11:20:23 +0200
 */

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'YOUR_DB_USERNAME';
$cfg['Servers'][$i]['password'] = 'YOUR_DB_PASSWORD';
$cfg['Servers'][$i]['verbose_check'] = false;
$cfg['Servers'][$i]['only_db'] = array (
 
0 => 'PUBLIC_DB_FOR_THIS_PMA',
);
$cfg['Servers'][$i]['hide_db'] = '#MY_SECOND_HIDDEN_COMPANIES_DB#i';

/* End of servers configuration */

$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['blowfish_secret'] = '"4bd94c36753d6ee2.2987282742';
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>

Add new comment