Error 1130 connecting to MySQL on Ubuntu Server 12.04
- by maGz
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 eth1 192.168.56.21.
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'.
EDIT: SOLVED!!