Description:
It is recommended to set a password for the administrative user ('root' by default) to prevent unauthorized access to the SQL database instances.
This recommendation is applicable only for MySQL Instances. PostgreSQL does not offer any setting for No Password from the cloud console.
Rationale:
At the time of MySQL Instance creation, not providing an administrative password allows anyone to connect to the SQL database instance with administrative privileges. The root password should be set to ensure only authorized users have these privileges.
Connection strings for administrative clients need to be reconfigured to use a password.
From Google Cloud Console
Go to the Cloud SQL Instances page in the Google Cloud Platform Console using 'https://console.cloud.google.com/sql/'
Select the instance to open its Overview page.
Select 'Access Control > Users'.
Click the 'More actions icon' for the user to be updated.
Select 'Change password', specify a 'New password', and click 'OK'.
From Google Cloud CLI
gcloud sql users set-password root --host= --instance= --prompt-for-password
Instance Password:
Updating Cloud SQL user...done.