user3526002
user3526002

Reputation: 547

ERROR 1045 (28000) access denied cloudSQL

ERROR 1045 (28000): Access denied for user 'machines'@'1xx.1xx.1xx.1xx' (using password: YES)

I ran this code in the command line

mysql --host=1xx.1xx.1xx.1xx --user=machines --password

where the host IP address is obtained by requesting IPv4 address from cloudSQL. I've tried running the same code but changing the --host parameter to IPv6 address provided, the result is still the same.

I've added both my IPv4 and IPv6 address to the authorize network already. The tutorial provided at this link doesn't work for me: https://cloud.google.com/sql/docs/mysql-client

Upvotes: 2

Views: 3341

Answers (1)

user3526002
user3526002

Reputation: 547

I've figure out the issue. At the user tab under access control. the host should be left as '%' instead of 'localhost' or anything else. Logging should be fine after that.

Upvotes: 2

Related Questions