I am having a PDO mysql connection issue I cant explain.
On server server1.mydomain.com
I have a test script
$pdo = new PDO('mysql:host=126.96.36.199;dbname=test', 'user','password');
188.8.131.52 is by an A record called server2.mydoamin.com they are 2 different
This script returns an error:
ERROR: Access denied for user 'user'@'server1.mydomain.com' (using password:
I find this ODD because that is not the server i am connecting TO but FROM.
Why would the PDO connection be referring back to its own localhost instead of
the intended domain.
I have tried this by fully qualified domain name, same thing.
I have ensured the route does exist on the connecting server.
I have ensured there is no local reference to the domain name/IP back to its
I log into 184.108.40.206 and there is NO record of the failed attempt.
I validate the user has remote access rights.
I validate there is not a firewall rule blocking the host/port/you name it.
I telnet from the server to the destination via port 3306 it connects.
BTW (220.127.116.11) IS FAKE I AM USING THE IP AS AN EXAMPLE HERE.
Any clue as to WHY the host parameter is not setting or is it setting and
something else is wrong?