I am trying to connect cloud sql with google cloud app engine flexible.
My code is as bellow:
$dsn = getenv('MYSQL_DSN');
$user = getenv('MYSQL_USER');
$password = getenv('MYSQL_PASSWORD');
try {
$db = new PDO($dsn, $user, $password);
$statement = $db->prepare("SELECT * from user");
$statement->execute();
$users = $statement->fetchAll();
} catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n";
}
app.yaml
runtime: php
env: flex
runtime_config:
document_root: .
env_variables:
MYSQL_DSN: mysql:dbname=DATABASE;unix_socket=/cloudsql/CONNECTION_NAME
MYSQL_USER: username
MYSQL_PASSWORD: password
Getting bellow error
SQLSTATE[HY000] [2002] No such file or directory