I have a MySQL 8.0 database on Google Cloud SQL. I have two applications accessing two different databases on the same MySQL instance. I’m trying to set up access control so that each application has its own user and that user has access only to one of the databases. However, when I create a new user using the Cloud SQL interface, that user has access to all of the databases on the MySQL instance.
Google documentation gives the following information:
In MySQL 8.0 for Cloud SQL, when you create a new user, the user is automatically granted the
cloudsqlsuperuserrole is a Cloud SQL role that contains a number of MySQL privileges. This role gives the user all of the MySQL static privileges, except for SUPER and FILE.
Is it possible to remove this
cloudsqlsuperuser role from the user and give the user access to the databases individually? And how is this done?