I can't seem to get remote access to Mysql running on a Google Cloud/Compute instance. I'm trying to do a plain vanilla install.
I created the instance, using Debian, the default.
I did the apt-get install for mysql, and bizarrely, it installed MariaDB instead. Fine.
I ran sudo mysql mysql_secure_installation and followed the prompts. Bizarrely, it left the mysql.users row for "root" with a plugin column value of "unix_socket", which allows only local access using sudo. Fine. I'll add a new user.
I logged in locally and ran:
create user 'myname'@'%' identified by 'mypass';
grant all privileges on * . * to 'mypass'@'%';
flush privileges;
I can connect using 'myname' from localhost.
I opened up a hole in the Google Cloud firewall for port 3306 on 0.0.0.0/0. I know I did it correctly, because I created an identical rule for port 8088, and I can communicate remotely to that port just fine.
When I try to connect to mysql from a remote box, I get "Unable to connect to remote host: Connection refused."
This could be a networking problem or a mysql problem, and I can't figure out which. Any ideas?