I hope this is the right place for this...I currently am running Ubuntu Server 12.04 through VirtualBox on a Windows 7 host. I am trying to connect to the VM's MySQL engine using MyDB Studio for MySQL, and when I enter my MySQL login credentials, it gives me the following error back:
Error 1130: Host '192.168.56.1' is not allowed to connect to this MySQL server
I am running the VM with Adapter 1 enabled for NAT, and Adapter 2 enabled for Host-only Adapter.
eth0 10.0.2.15 and
I can connect to Apache at
192.168.56.21, and through PhpMyAdmin, everything works as it should. I did edit the
/etc/mysql/my.cnf file and commented out the line
bind-address = 127.0.0.1 by adding a
# in front of it - I thought that this should have allowed remote connections.
Any ideas on how I can solve this? What could be wrong?
EDIT: I am trying to connect as 'root'.