Error 1130 connecting to MySQL on Ubuntu Server 12.04

Posted by maGz on Ask Ubuntu See other posts from Ask Ubuntu or by maGz
Published on 2012-11-29T22:30:04Z Indexed on 2012/11/29 23:19 UTC
Read the original article Hit count: 448

Filed under:
|
|
|

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!!

© Ask Ubuntu or respective owner

Related posts about 12.04

Related posts about virtualbox