add a db server
/etc/phpMyAdmin/config.inc.php: $i++; $cfg['Servers'][$i]['host'] = '63123124.example.com'; // MySQL hostname or IP address $cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port $cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket $cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket') $cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli') $cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection $cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)? $cfg['Servers'][$i]['verbose'] = 'dbaas01.lb01.example.com'; // Verbose name for this host - leave blank to show the hostname $i++;
/etc/phpmyadmin/apache.conf: <Directory /usr/share/phpmyadmin> Options FollowSymLinks DirectoryIndex index.php <IfModule mod_php5.c> AddType application/x-httpd-php .php php_flag magic_quotes_gpc Off php_flag track_vars On php_flag register_globals Off php_value include_path . </IfModule> Order deny,allow Deny from all Allow from localhost 127.0.0.0/8 ::1 49.248.0.170 94.236.7.190 AuthUserFile /etc/phpmyadmin/phpmyadmin-htpasswd AuthName "Password protected" AuthType Basic Require valid-user # Allow password-less access for allowed IPs Satisfy any </Directory>