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.