====== phpMyAdmin ======
* [[MySQL]]
==== Configuration ====
Setup a new user for PMA:
mysql -e "CREATE USER 'pma'@'localhost' IDENTIFIED BY '';"
mysql -e "GRANT ALL PRIVILEGES ON *.* TO pma@localhost WITH GRANT OPTION;"
To setup a configuration that uses the config file for authentication, and ignores the mysql and information_schema tables, here is what to add to ''config.inc.php'':
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'pma';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['hide_db'] = '^(mysql|information_schema|performance_schema)$';
# $cfg['Servers'][$i]['only_db'] = array('');
Disable version check, which runs over http and breaks the https seal:
$cfg['VersionCheck'] = false;