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: 442
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