GCP Cloud Run Service scenarios to Connect to Cloud SQL with Connection Pooling in Node.js
I'm writing unit tests and I keep running into I'm relatively new to this, so bear with me. I'm experiencing issues with my Node.js application running on GCP Cloud Run that connects to a Cloud SQL database... I configured the connection using the official `mysql` library, and I'm trying to utilize connection pooling for better performance. However, I'm running into an behavior: `ER_ACCESS_DENIED_ERROR: Access denied for user 'myuser'@'%' (using password: YES)`. Here's a snippet of the code I'm using to set up the connection pool: ```javascript const mysql = require('mysql2/promise'); const pool = mysql.createPool({ host: '/cloudsql/my-project:us-central1:my-instance', user: 'myuser', password: 'mypassword', database: 'mydatabase', connectionLimit: 10, }); ``` I verified that the Cloud SQL instance is running and that the user has the necessary permissions. I also ensured that the Cloud Run service account has access to the Cloud SQL instance by enabling the Cloud SQL Admin API and assigning the correct IAM roles. Still, I need to seem to connect properly. I've tried using the `cloud_sql_proxy` setup as well, but the scenario continues. Can anyone suggest what might be going wrong or how I can debug this further? Thanks in advance! What would be the recommended way to handle this? Has anyone dealt with something similar?