How do I set a root password for a Cloud SQL instance in Google App Engine? ["Instance busy" error message]

Question

Whenever I try to set a root password I get a message saying "Instance busy".

How can I then set a password for the instance? Is there a third party tool I can use to connect to the cloud-sql instance and maybe set a password from there?

Answer 1

I have found no resolve, and the issue persists.

However, if you remove the IP address to the instance periodically, there should be no way of accessing it outside the internal app engines code.

This bug is still a big security concern though.

Answer 2

Using the new console, try waiting for a good length of time if you haven't already, as that message eventually went away for me

Once I set the password I just used MySQL Workbench to connect, and it was all copacetic.

---

Background: I just set up my Cloud SQL this week, and in the Developers Console under Access Control and I had the same problem at first, in the small yellow box "Instance Busy".

My solution was to clear my cache on Chrome (I recommend using Chrome with Google UIs as it rules out any funky incompatibility with AngularJS), I saw the error message again after I went back, waited a while (maybe 30 seconds) and it went away, I then assigned an IP address and it came back, again for a while and eventually went away and I was able to set the password then.

Hopefully this answer was helpful (and it works for you; although not guaranteed I thought I would offer it as an answer as my experience was very similar).