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.
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'
[client] port = 3306 ... [mysqld] bind-address = 192.168.56.8 ...
auto eth0 iface eth0 inet dhcp auto eth1 iface eth1 inet static address 192.168.56.8 netmask 255.255.255.0
netstat -l --numeric-ports | grep 3306 tcp 0 0 192.168.56.8:3306 0.0.0.0:* LISTEN