"ad...@buskirkgraphics.com" wrote:

> I am having a PDO mysql connection issue I cant explain.
> On server server1.mydomain.com
> I have a test script
> <?php
> $pdo = new PDO('mysql:host=;dbname=test', 'user','password');
> ?>
> is by an A record called server2.mydoamin.com  they are 2
> different servers.
> This script returns an error:
> ERROR: Access denied for user 'user'@'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 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.
> Any clue as to WHY the host parameter is not setting or is it setting and
> something else is wrong?

You are attempting a connection by u...@server1.mydomain.com

This request is made to the mysql server on host server2.mydomain.com which 
responds with the error that access is denied for the user named 'user' on 
host server1.mydomain.com

The most likely problem is that on server2.mydomain.com you do not have 
mysql privileges for u...@server1.mydomain.com

David Robley

People in the passing lane that don't pass will be shot.

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to