Manually creating the file ΒΆ

To manually create the file, simply use your text editor to create the file config.inc.php (you can copy config.sample.inc.php to get a minimal configuration file) in the main (top-level) phpMyAdmin directory (the one that contains index.php). phpMyAdmin first loads libraries/config.default.php and then overrides those values with anything found in config.inc.php. If the default value is okay for a particular setting, there is no need to include it in config.inc.php. You'll probably need only a few directives to get going; a simple configuration may look like this:

<?php // use here a value of your choice at least 32 chars long $cfg['blowfish_secret'] = '1{dd0`<Q),5XP_:R9UK%%8\"EEcyH#{o';  $i=0; $i++; $cfg['Servers'][$i]['auth_type']     = 'cookie'; // if you insist on "root" having no password: // $cfg['Servers'][$i]['AllowNoPassword'] = true; 

Or, if you prefer to not be prompted every time you log in:

<?php  $i=0; $i++; $cfg['Servers'][$i]['user']          = 'root'; $cfg['Servers'][$i]['password']      = 'cbb74bc'; // use here your password $cfg['Servers'][$i]['auth_type']     = 'config'; 

Warning

Storing passwords in the configuration is insecure as anybody can then manipulate your database.

For a full explanation of possible configuration values, see the Configuration of this document.