This may seem like a noob question, but I'm completely stumped. I'm
getting error #2002 when I try to connect to my database server through
phpmyadmin.
Note that my Webserver (running Apache httpd) is on one server while my
database server is on another.
I've tried everything I can think of, firewalls, permissions, router
config is out of the question since the two are on the same LAN. I even
ran a test script and php was able to create a connection from my
webserver to my database server with out a problem, so as far as I can
see it comes down to phpmyadmin. I've been over the config numerous
times, the IP of the host is correct, most everything is default, I
don't have special circumstances that require me to change the port or
any defaults. I double checked that I'm using the right password and
username, but still I got nothing.
Heres my config:
/*
* Generated configuration file
* Generated by: phpMyAdmin 3.5.6 setup script
* Date: Fri, 08 Feb 2013 04:14:44 +0000
*/
/* Servers configuration */
$i = 0;
/* Server: example.com [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'example.com';
$cfg['Servers'][$i]['host'] = '100.100.0.109';
$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';
/* End of servers configuration */
$cfg['blowfish_secret'] = '5114538c9c6744.77802267';
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
$cfg['AllowArbitraryServer'] = true;
$cfg['DefaultLang'] = 'en';
$cfg['ServerDefault'] = 1;
The URL and the LAN IP are changed for security, but aside from that
everything is the same.
|
