Connect to Cloud SQL via PHP hosted on Compute Engine

Question

How do I connect to an instance of Cloud SQL through a php file hosted on a Compute Engine VM?

• I have a MySQL (1º generation) instance in the Cloud SQL called bd-sales and a database called sales

• I have a Linux(Debian) VM built in Compute Engine

Obs.: I would like to make the connection using PDO

I tried this, but it didn't works:

<?php
    function getConnection(){
        try {
          $connection = new PDO('mysql:host=999.999.999.99;dbname=sales', 'user', 'pass');
          $connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
          return $connection;
          } catch(PDOException $e) {
            echo 'ERROR: ' . $e->getMessage();
            return;
        }
    }

    header("Access-Control-Allow-Origin: *");
    header('Content-Type: application/json');
?>

Matheus Ribeiro Matheus Ribeiro · Accepted Answer · 2018-08-09T16:37:53

I solved the problem, changing the connection string:

<?php
    function getConnection(){
        try {                                {GCSQL IPv4}                         {instance name}                 {Database name}
          $connection = new PDO('mysql:host=999.999.999.99;unix_socket=/cloudsql/instance:bd-instance;charset=utf8;dbname=vendas', 'user', 'pass');
          $connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
          return $connection;
          } catch(PDOException $e) {
            echo 'ERROR: ' . $e->getMessage();
            return;
        }
    }

header("Access-Control-Allow-Origin: *");
header('Content-Type: application/json');

?>

Connect to Cloud SQL via PHP hosted on Compute Engine

1 Answers