On 11/28/2012 4:18 PM, admin@xxxxxxxxxxxxxxxxxxx wrote:
On November 28, 2012 at 4:11 PM Jim Giner <jim.giner@xxxxxxxxxxxxxxxxxx> wrote:
On 11/28/2012 3:58 PM, admin@xxxxxxxxxxxxxxxxxxx wrote:
Guys,
I am not quiet sure what is happening but every time i try to connect to a
remote host it refers back to localhost.
$pdo = new PDO('mysql:host=171.16.23.44;dbname=test', 'user','password');
ERROR: Access denied for user 'user'@'localhost' (using password: YES) in
/var/www/html/text.php
Any clue as to WHY it keeps referring back to localhost when i clearly set
the
host parameter to another server.
I checked the /etc/hosts records to see if there was a referral for that
domain
back to it's self there is NOT.
Just a WAG from a guy who's never tried to do this.
Could the localhost in question actually be the server you are failing
to connect to, and not your client machine? You are sure about your
uid/pswd? dbname?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I actually do not allow the user in the connection string to connect locally
which makes me think it is not accepting the host parameter and defaulting to
the localhost.
I would expect this if connecting localhost but the IP is not the local host IP.
My question is WHY is it changing the host parameter?
Like I said just a WAG, but are you sure about my other questions? My
point is perhaps the error message itself is a little confusing and the
response from the sql server is using the term localhost to refer to
itself, but that message is getting passed back to your server and then
to you, causing perhaps(?) some confusion.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
