phpMyAdmin

I have XAMPP installed and wanted to document part of my config in case I have to setup again on a new computer.

Notable changes (that I remember) are:

• No auto login to the MySQL server.
• Added a second host which is the same computer but by IP, which I use to connect to MySQL running in docker images.

File found at: /opt/lampp/phpmyadmin/config.inc.php

<?php
/**
 * phpMyAdmin sample configuration, you can use it as base for
 * manual configuration. For easier setup you can use setup/
 *
 * All directives are explained in documentation in the doc/ folder
 * or at <https://docs.phpmyadmin.net/>.
 */

/** 
 * This part has been truncated
 */

/**
 * Servers configuration
 */
$i = 0;

/**
 * First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
//$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/** 
 * This part has been truncated
 */

$i++;
$cfg['Servers'][$i]['host'] = '127.0.0.1'; //provide hostname and port if other than default
$cfg['Servers'][$i]['user'] = 'root';  
$cfg['Servers'][$i]['password'] = '';  
$cfg['Servers'][$i]['auth_type'] = 'cookie';


/**
 * End of servers configuration
 */

/** 
 * This part has been truncated
 */