no way to compare when less than two revisions

Differences

This shows you the differences between two versions of the page.


phpmyadmin [2015/06/01 23:17] (current) – created - external edit 127.0.0.1
Line 1: Line 1:
 +====== phpMyAdmin ======
 +
 +  * [[MySQL]]
 +
 +==== Configuration ====
 +
 +Setup a new user for PMA:
 +
 +<code>
 +mysql -e "CREATE USER 'pma'@'localhost' IDENTIFIED BY '';"
 +mysql -e "GRANT ALL PRIVILEGES ON *.* TO pma@localhost WITH GRANT OPTION;"
 +</code>
 +
 +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'':
 +
 +<code>
 +$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('');
 +</code>
 +
 +Disable version check, which runs over http and breaks the https seal:
 +
 +<code>
 +$cfg['VersionCheck'] = false;
 +</code>
 +
  

Navigation
QR Code
QR Code phpmyadmin (generated for current page)