Query Cloud SQL Database from Python

Question

I want to insert data into a CloudSQL MySQL database from a local Python application, is this possible, if so how?

I have tried running the examples at the bottom of https://cloud.google.com/appengine/docs/python/cloud-sql/#Python_complete_python_example

db = MySQLdb.connect(unix_socket='/cloudsql/PROJECT-ID:INSTANCE-NAME', user='phil')

cursor = db.cursor()
cursor.execute('SHOW VARIABLES')
for r in cursor.fetchall():
  webapp2.RequestHandler.response.write('%s\n' % str(r))

db.close()

However I get the error:

`Can't connect to local MySQL server through socket`

Daniel Roseman · Accepted Answer · 2016-04-06 14:10:31Z

1

Of course it's possible, but that's the documentation for using it specifically from App Engine. Rather, you should use the docs for connecting from an external application - you'll need to configure access, then set mysqldb to connect via IP rather than a local socket.

answered Apr 6, 2016 at 14:10

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Query Cloud SQL Database from Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related