Manually Create for phpMyAdmin

This article discusses the manual creation of for phpMyAdmin installation.

To manually create the file, simply use your text editor to create the file (you can copy to get 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 If the default value is okay for a particular setting, there is no need to include it in You’ll need a few directives to get going, a simple configuration may look like this:

// use here a value of your choice at least 32 chars long
$cfg['blowfish_secret'] = '1{dd0`<Q),5XP_:R9UK%%8\"EEcyH#{o';

$cfg['Servers'][$i]['auth_type']     = 'cookie';

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


$cfg['Servers'][$i]['user']          = 'root';
$cfg['Servers'][$i]['password']      = 'cbb74bc'; // use here your password
$cfg['Servers'][$i]['auth_type']     = 'config';


Was this answer helpful?

 Print this Article

Also Read

Video: Using MySQL in cPanel

This video tutorial provides Step-by-Step instructions for using MySQL in cPanel Shared Hosting...

Install MySQL on CentOS Server

This tutorial provides step-by-step instructions for installing MySQL on Centos servers. ...

How to Backup MySQL Databases

This can be used to back up a database. 1. Export A MySQL Database This example shows you how to...


WHMCS requires a setting on the MySQL or MariaDB server for the SQL Mode. To verify this, log...