[google-cloud-sql-discuss] Re: User with cloudsqlsuperuser denied access to database

In MySQL 8.0 for Cloud SQL, when you create a new user, the user is automatically granted the cloudsqlsuperuser role. This role gives the user all of the MySQL static privileges, except for SUPER and FILE and the following dynamic privileges:

- APPLICATION_PASSWORD_ADMIN

- CONNECTION_ADMIN

- ROLE_ADMIN

- SET_USER_ID

- XA_RECOVER_ADMIN

This link [1] provide you all the details permissions and privileges offers by cloudsqlsuperuser role.

[1]https://cloud.google.com/sql/docs/mysql/users#cloudsqlsuperuser

On Friday, March 26, 2021 at 6:49:07 PM UTC-4 Mark S wrote:

Cloudsql Mysql 8.0

My user has the cloudsuperuserrole, and running a 'use database' command results in access denied. The database I'm attempting to use is not a system database (is not sys, information_schema, or mysql).

Perhaps I'm misunderstanding how the cloudsqlsuperuser role is intended to work, but I expected the user should have full permissions on any non-system database with this role?

--
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/61245ac3-e291-439d-9e79-9b4c6f8d202dn%40googlegroups.com.