PHP PDO not Connecting to Cloud SQL

[Aminu Lawal Nasir]

Hello,

I'm having problems connecting to Cloud SQL using PDO.

Can someone please help me out.

$db_server=null;

$db_username="root";

$db_password="password";

$db_database="database";

$connection=new PDO('mysql:unix_socket=/cloudsql/corvater:europe-west6:dbinstance;dbname='.$db_database,$db_username,$db_password);

[EZEKIAS BOKOVE]

Hello
You have to check if pdo is activated.
https://askubuntu.com/questions/824485/how-to-activate-php7-0-pdo-in-16-04-lts

[George (Cloud Platform Support)]

Hello Aminu, 

You may consider something similar to: 

$dsn = "/cloudsql/PROJECT:REGION:INSTANCE;dbname=DATABASE";

 $user = "USER";

 $password = "PASSWORD";

 $db = new PDO($dsn, $user, $password);

Alternatively, you could set relevant environment variables in the app.yaml configuration file, and using these variables: 

env_variables:

MYSQL_USER: root

MYSQL_PASSWORD: "*****"

MYSQL_DSN: mysql:dbname=DBNAME;unix_socket=/cloudsql/INSTANCE_NAME

This discussion group is oriented more towards general opinions, trends, and issues of general nature touching App Engine and Cloud SQL. For coding and programming architecture, as well as setting up PDO connectivity, you may be better served in dedicated forums such as stackoverflow, where experienced programmers are within reach and ready to help.