PDO ignoring the given hostname

Asked Oct 18 '19 at 12:39

Active Oct 18 '19 at 12:39

Viewed 43 times

I wrote a super simple PDO connection:

const DB_HOST = '185.113.196.xxx';
const DB_USER = 'wesley';
const DB_PASS = 'th1s1s4p4ssw0rd';
const DB_NAME = 'flash';


try {
    $connection = new PDO(sprintf('mysql:host=%s;dbname=%s', DB_HOST, DB_NAME), DB_USER, DB_PASS);
    $connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    die($e->getMessage());
}

This all seems well and good, but when I actually execute a query, the following error pops up:

SQLSTATE[HY000] [1045] Access denied for user 'wesley'@'12-123-12-123.ip.xs4all.nl' (using password: YES)

12.123.12.123 is our Office IP address (in this example), and 12-123-12-123.ip.xs4all.nl is our hostname. How in the world is it possible that that's the address it tries to connect to, instead of the given host?

asked Oct 18 '19 at 12:39

sushibrain

2,712
5
33
62

does that user have access to that db on that host? – treyBake Oct 18 '19 at 12:39
@treyBake Yeah, and I can connect to the host with the same credentials through workbench – sushibrain Oct 18 '19 at 12:41
1

I would say you are looking at one PHP file and running another – Your Common Sense Oct 18 '19 at 12:41
@YourCommonSense Confirmed that I'm not – sushibrain Oct 18 '19 at 12:48
wait. everything is correct. 12-123-12-123.ip.xs4all.nl is not the address it tries to connect to. let me find a relevant dupe – Your Common Sense Oct 18 '19 at 12:50
@aynber `Connection is: mysql:host=185.113.196.xxx;dbname=flash` – sushibrain Oct 18 '19 at 12:50
*facepalm* The connection string is correct. The issue is your mysql account. It's seeing **your** IP as `12-123-12-123.ip.xs4all.nl`. So check what hosts `wesley` can connect from in `mysql.user`. `SELECT user, host from mysql.user WHERE user = 'wesley'` – aynber Oct 18 '19 at 12:52

PDO ignoring the given hostname

0 Answers0