Access denied for user 'cloudsqlimport'@'localhost' during mysql import

[Brent Townshend]

Hi,

  I'm trying to import data into a mysql generation 2 instance, but keep getting the error:

 ERROR 1045 (28000) at line 4: Access denied for user 'cloudsqlimport'@'localhost' (using password: NO)

From either the GUI-based import or from a gcloud command line.    I tried adding 'cloudsqlimport'@'localhost'   and 'cloudsqlimport'@'%'   as users on the SQL database, but still no change.   It seems that I'm missing some authentication detail, but it's eluding me...

Brent

[Kenworth (Google Cloud Platform)]

The error message you have provided implies access issue. It usually happens when you do not provide a password. See this article about diagnosing connections.

[Brent Townshend]

I reviewed that information and it doesn't seem to offer a solution.   The "Import" button under the cloud SQL instances seems to have the username, "cloudsqlimport" (which is not a username I ever created or used) hardwired into it, along with the access methods.   

Brent

[Kenworth (Google Cloud Platform)]

You can verify if you successfully created the user by running the following command: 

gcloud sql users list --instance [your_instance_name]

or by going to Console > SQL > Select Instance > Users. You can also use the default root user and see if it mitigates the issue. If you need further assistance, I recommend you post on StackOverflow which we also monitor since a thread like this is off-topic for Google Groups. Please include screenshots and/or details where you see 'cloudsqlimport' username. Check out our community support page for the list of tags we monitor.