[google-cloud-sql-discuss] Errors when setting root password or attempting to list users on second gen instance using gcloud

Hi, folks. I have a second gen. instance that has been created in our project using mysql 5.7. Nothing else has been done after using the console to create this instance. If I try to execute ...

$ gcloud sql instances set-root-password my_instance --password my_password

... I get the error "ERROR: (gcloud.sql.instances.set-root-password) The instance or operation is not in an appropriate state to handle the request."

On a perhaps related note if I try ...

$ gcloud beta sql users list --instance my_instance

... I get "ERROR: (gcloud.beta.sql.users.list) This operation isn"t valid for this instance."

Any help would be appreciated. The ability to execute these commands in script is intrinsic to our approach for managing access to database secrets in our kubernetes cluster.

Thanks very much!

--Mark

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/798e6f8f-379b-4ca9-b742-882a76ed67b9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.