> On Wednesday, November 28, 2012 at 4:50 PM, ad...@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
>
I have tried the options listed same results.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
