PDO connection using IP address as Host

Question

I am trying to connect to the database using PDO with IP address as host, but I get this error:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000] [1044] Access denied for user 'xxx'@'%' to database 'ddd'' in /Applications/MAMP/htdocs/iravin/testconnect.php:31 Stack trace: #0 /Applications/MAMP/htdocs/iravin/testconnect.php(31): PDO->__construct('mysql:host=162....', 'xxx', 'zzz') #1 {main} thrown in /Applications/MAMP/htdocs/iravin/testconnect.php on line 31

While if I used the dns "xxx.com" as host, it will work normally.

Here's my code for connection:

$con = new PDO('mysql:host=123.123.123.12;dbname=xxx', 'zzz', 'ccc');

user4700355 user4700355 · Accepted Answer · 2015-03-22T17:20:46

try {
    $con = new PDO('mysql:host=123.123.123.12;dbname=xxx', 'zzz', 'ccc'); 
    $handler->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    echo "The Following error has occurred:".$e->getMessage()."";
}

Check that your username, database name and password are correct. The IP address is fine as it has said the user has been denied access which means it isn't the IP.

PDO connection using IP address as Host

2 Answers