PDO::__construct(): php_network_getaddresses: getaddrinfo failed: Name or service not known

pdo, php

Solution

"mysql:host='localhost';dbname='data';charset=utf8"

Your DSN format is wrong, it shouldn't have those quotes in there. This is the right format

 //$con=new PDO($dsn, $user, $password);
 $con=new PDO('mysql:dbname=testdb;host=127.0.0.1','root',''); 

See Manual

Problem

There are tons of questions asked on this topic on Stack Overflow, but none of them matches my case. I am using Lampp with PHP 5.4.7 and it was running fine until I developed my first PDO program in PHP. When I use `$con=new PDO("mysql:host='localhost';dbname='data';charset=utf8",'root','');` for connection I get this error.Do I need to activate something in php.ini?

Original source

Related problems