For the mysql command-line client option: a mysql command-line client installed on your local machine.
For the SSH client option: an SSH client such as the ssh utility for UNIX-like platforms or the PuTTY program for Windows.For the SSH client option with either UNIX-like platforms or Windows, or for the MySQL Workbench with SSH option: the private key that goes with the public/private key pair that you used when you created the MySQL Cloud Service instance.
# localhost which is more compatible and is not less secure.įor firewall, sudo ufw status verbose results in Status: inactiveįor the username, the user and host parameters in the mysql.This tutorial shows you how to connect to your MySQL Cloud Service in several ways: # Instead of skip-networking the default is now to listen only on
# If MySQL is running as a replication slave, this should be Tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 1422415/mysqldįor bind address, The relevent portion of the /etc/mysql//mysqld.cnf file is # * Basic Settings Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name The result of sudo netstat -tunlp is Active Internet connections (only servers) edit- In response to mustaccio's comment, here is how I'm checking thigns: I feel like I'm probably missing something basic, but I just can't figure it out.
I've looked over a bunch of various questions on this topic and none of them have addressed my issue. The error message says "Unable to connect to localhost", even though the connection profile is using TCP/IP method and has the server IP address and port number specified. I am attempting to login with a user that is allowed to connect from any address (user was created with am attempting to connect using MySQL Workbench running on a Windows machine. I have checked that there is no firewall. I have ensured that it is listening on port 3306. I have a MySQL server instance installed on an Ubuntu machine.