Google App Engine - 使用mysqli通过php连接到SQL云实例

Question

I've spent hours trying to figure out how to connect my Google App Engine project to my Cloud SQL instance using php with mysqli.

I found googles tutorial to be useless as it is with PDO and I couldn't get it to work.

Any Ideas?

Answer 1

Thanks for asking Cam, here's what I (you) did...

Your mysqli creation statement should mimic below.

 new mysqli(null, "root", '<rootUserPassword>', "<dbName>", null, "/cloudsql/<instanceConnectionName>");

with root being the the default username assigned to the database

Note, this is for second generation cloud sql instances. I haven't tested this on first generation.