Manually Create config.inc.php for phpMyAdmin

This article discusses the manual creation of config.inc.php for phpMyAdmin installation.

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 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 need 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';
?>

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';
?>

 

Was this answer helpful?

 Print this Article

Also Read

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...

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. ...

Remove STRICT_TRANS_TABLES in SQL Mode for WHMCS

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