I currently have running two MySQL instances on my machine, production and development - I can connect to each one using the following:
mysql --host=127.0.0.1 --port=3306 -u root -p
mysql --host=127.0.0.1 --port=6606 -u root -p
Now I just set up an instance of PhpMyAdmin, but I am having trouble getting it to connect to my Development instance, here is relevant context in config.inc.php
$i = 1;
$cfg['Servers'][$i]['verbose'] = 'Production';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = 3306;
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$i = 2;
$cfg['Servers'][$i]['verbose'] = 'Development';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = 6606;
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;
When logging on, whether I have Production or Development selected, I am also logged into the Production server running on 3306.
Thoughts?
$i = 1;
and$i = 2;
for now; though if that fails I'd also be curious about whether you completely move the port 6606 server to the first position in the file)? I suspect some problem with yourconfig.inc.php
(no idea what, but that seems to be the likely problem); can you paste here the entire file for testing (obscuring any sensitive information)? What phpMyAdmin version is this?