Connection Timing Out When Accessing Gcloud MySQL from Python

Question

I have a python application where I'm trying to access a MySQL database on Google's cloud service.

I've been following this set up guide for connecting via an external application (Python) and I am using the pymysql package. I'm attempting to connect via the proxy and have already authenticated my connection via gcloud auth log in from the console.

As of now, I CAN access the database via the console, but I need to be able to make queries from my python script to build it out. When I try running it as is, I get the following error: OperationalError: (2003, "Can't connect to MySQL server on '34.86.47.192' (timed out)")

Here's the function I'm using, with security sensitive info starred out:

def uploadData():
    # cd to the directory with the MySQL exe
    os.chdir('C:\\Program Files\\MySQL\\MySQL Server 8.0\\bin')  
    # Invoke the proxy 
    subprocess.call('start cloud_sql_proxy_x64.exe -instances=trans-cosine-289719:us-east4:compuweather', shell=True)
    # Create connection    
    # I have also tried host = '127.0.0.1' for localhost here
    conn = pymysql.connect(host='34.86.47.192',
                                 user='root',
                                 password='*******',
                                 db='gribdata')
    try:
        c = conn.cursor()
        # Use the right databse
        db_query = 'use gribdata'
        c.execute(db_query)
        query = 'SELECT * FROM clients'
        c.execute(query)
        result = c.fetchall()
        print(result)
    except Error as e:
        print(e)
    finally:
        conn.close()

Answer 1

Yeah, this one's pretty limited in documentation, but what you want to do is run it from it's hosted IP and configure access to your external IP address on your server. So you want use that IP (34.xxx.xxx.xxx) rather than the loopback 127 local host IP.

To get it to work, you want to go to your connections tab and add a new connection within Gcloud. Make sure the public address box is checked, the IP is correct, and you save once done.

There's some excellent details here from some Gcloud engineers. Looks like some of the source documentation is outdated and this is the way to connect now.