Manually Create config.inc.php for phpMyAdmin


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

Manually Create config.inc.php

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 a value of at least 32 characters
$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'; // replace with your password
$cfg['Servers'][$i]['auth_type']     = 'config';
?>

Further reading: phpMyAdmin Configuration

Launch 100% SSD VPS from $2.49/mo!

  • phpmyadmin, configuration file
  • 172 Users Found This Useful
Was this answer helpful?

Related Articles

Install MySQL on CentOS 7 Server

This tutorial provides step-by-step instructions for installing MySQL database server on CentOS...

Install MySQL on CentOS 6 Server

This tutorial provides step-by-step instructions for installing MySQL database server on CentOS...

MySQL Server GPG Keys Expired (Workaround)

This article provides a guide for resolving an issue caused by MySQL GPG key expiration. This...

Install MySQL on CentOS 8 Server

This tutorial provides step-by-step instructions for installing MySQL database server on CentOS...

Remove STRICT_TRANS_TABLES in SQL Mode for WHMCS

WHMCS, a billing and support software for the web hosts, may experience a conflict with default...