Re: PDO mysql Connection issue

On Wednesday, November 28, 2012 at 4:50 PM, admin@buskirkgraphics.com wrote: > I am having a PDO mysql connection issue I cant explain. > > On server server1.mydomain.com (http://server1.mydomain.com) > I have a test script > <?php > $pdo = new PDO('mysql:host=171.16.23.44;dbname=test', > 'user','password'); > ?> > 171.16.23.44 is by an A record called server2.mydoamin.com (http://server2.mydoamin.com) they > are 2 different > servers. > This script returns an error: > ERROR: Access denied for user 'user'@'server1.mydomain.com > (http://server1.mydomain.com)' (using password: > YES) > > 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 > self. > > I log into 171.16.23.44 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 (171.16.23.44) 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? > > Have you tried running FLUSH HOSTS on the MySQL server? Also, i would try to disable DNS within MYSQL by starting with --skip-name-resolve (http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_skip-name-resolve); -- Mike Mackintosh PHP 5.3 ZCE