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

Question

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?

Answer 1

"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

Answer 2

Try using localhost ip instead: 127.0.0.1 and remove the quotes around dbname and host:

$con=new PDO("mysql:host=127.0.0.1;dbname=data;charset=utf8",'root','');

Answer 3

For the case when you have a .env file.

DO NOT USE ' (single quote) for values on DB settings.
For example the following must be written:

DB_CONNECTION=mysql
DB_HOST=mariadb
DB_PORT=3306

NOT!!! DB_CONNECTION='mysql' etc.