Mysql Question posted in
The official MySQL documentation can be found here.

Not able to connect mysql with SSL enforced to app engine without connecting first in cloud shell

I have created mysql instance v-8.4 in gcp with ssl. But it is not able to connect to app engine. When I connect to mysql using command line in google cloud shell, after that it connects with app engine as well. But as soon as I restart instance, it fails to connect again. I even tried disabling ssl, but it doesnt help and same issue occurs.

Tags:

2

Answers


  1. 0

    Most likely it points to a configuration issue in your SSL setup or connection handling. The use of Cloud SQL Auth Proxy is the recommended way to securely connect App Engine to Cloud SQL.

    • Add Cloud SQL Auth Proxy to your App Engine Deployment, in your app.yaml add this code:

      beta_settings:
  cloud_sql_instances: "[PROJECT_ID]:[REGION]:[INSTANCE_NAME]"

    • Replace the host with the proxy’s Unix socket:

      connection = pymysql.connect(
    unix_socket='/cloudsql/[PROJECT_ID]:[REGION]:[INSTANCE_NAME]',
    user='[USERNAME]',
    password='[PASSWORD]',
    database='[DB_NAME]'
)

    Hope this works!

    Login or Signup to reply.
  2. 0

    There is currently an issue that causes logins to fail when you use the Cloud SQL Auth Proxy to connect to MySQL 8.4 with the caching_sha2_plugin authentication plugin enabled.

    We are working on a fix. You can track our progress on the issue here: https://github.com/GoogleCloudPlatform/cloud-sql-proxy/issues/2317

    In the mean time, you may work around the issue by configuring the MySQL instance to use the mysql_native_password authentication.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search