I have a LAMP stack box (CentOS 6) and another CentOS 6 box running mysql server.
I've installed phpmyadmin on the LAMP box but I can not get it to talk to my SQL box at all.
I have configured the following in config.inc.php
/* Servers configuration */
$i = 0;
/* Server: usp-ggdb2 [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'usp-ggdb2';
$cfg['Servers'][$i]['host'] = '10.1.2.3';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
When I browse to the phpmyadmin site I get the following error:
#2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) The server is not responding (or the local server's socket is not correctly configured).
I don't know why it is talking about trying to connect to a local server as I've configured just the one server (and it's remote).
If i tcpdump I can see that it makes no attempt to establish a connection to the IP i specified.
It's as if my config file is being ignored.
Is there a way to turn on some more debug information? Any and all suggestions welcome!