3

Cloud SQL is locked, it tells me to contact Admin to unlock.

Cloud SQL is locked, it tells me to contact Admin to unlock

I've created Cloud SQL instance with service account "appmaker-maestro@appspot.gserviceaccount.com" on IAM & ADMIN. But App Maker doesn't see it. Added some tables by dbForge - it didn't helped.

I already created connection before in another app, some month ago and it worked. But now it doesn't see SQL.

Pavel Shkleinik
  • 6,298
  • 2
  • 24
  • 36
Arman Azhkhanov
  • 31
  • 2

1 Answers1

5

In order to configure Default Cloud SQL instance for App Maker you need to navigate to admin.google.com-> Apps -> Additional Google Services -> App Maker and setup database there. Here is a link to more detailed instructions: https://support.google.com/a/answer/7550053

Config default SQL

You can also configure different CSQL instances for different departments within your organization.

Pavel Shkleinik
  • 6,298
  • 2
  • 24
  • 36
  • Thank you it works now! One little thing. Here https://developers.google.com/appmaker/models/cloudsql#create-a-new-google-cloud-sql-database-for-your-app is wroten that at IAM&ADMIN i have to assign "SQL Client" Role for service account. But also it requeres SQL Admin Role. And than it works. – Arman Azhkhanov Apr 11 '18 at 06:31
  • As per [cloud documentation](https://cloud.google.com/sql/docs/mysql/connect-external-app), you need to enable "Cloud SQL Administration API" and assign "Cloud SQL Client" role to the service account for connecting to Cloud SQL from the external App. Does it precisely ask for "Cloud SQL Admin" role? – D Saini Apr 16 '18 at 19:55
  • Yes for Default Cloud SQL instance, because App Maker needs admin privileges to create/delete databases and users for apps. However admin permissions are not required for personal/custom instances. – Pavel Shkleinik Apr 16 '18 at 21:14