I am currently using ubuntu server on a virtual box machine to have a secondary environment for testing. The server also has mysql-server installed but I would like to manage it through mysql workbench on my host machine except when trying to connect the the remote host I am refused a connection.
HOST:
telnet 192.168.56.8 3306
Trying 192.168.56.8...
Connected to 192.168.56.8.
Escape character is '^]'.
EHost '192.168.56.1' is not allowed to connect to this MySQL serverConnection closed by foreign host.
Trying to connect
mysql -h 192.168.56.8:3306 -u root
ERROR 2005 (HY000): Unknown MySQL server host '192.168.56.8:3306'
VBOX:
mysql.cnf
[client]
port = 3306
...
[mysqld]
bind-address = 192.168.56.8
...
/etc/network/interfaces
auto eth0
iface eth0 inet dhcp
auto eth1
iface eth1 inet static
address 192.168.56.8
netmask 255.255.255.0
checking port
netstat -l --numeric-ports | grep 3306
tcp 0 0 192.168.56.8:3306 0.0.0.0:* LISTEN