Friday, May 3, 2024
 Popular · Latest · Hot · Upcoming
4
rated 0 times [  4] [ 0]  / answers: 1 / hits: 12642  / 2 Years ago, fri, june 24, 2022, 10:04:06

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


More From » 12.04

 Answers
2

Ok, this was such as silly oversight on my part, but the following 2 links pointed me in the right direction:





So in the spirit of helping someone else out who might have the same problem...



I created a new user, granted him all privileges, and set the host to % to allow connections from any IP. Logged in with the new user, and voila! all good


[#33962] Sunday, June 26, 2022, 2 Years  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.
elecerna

Total Points: 140
Total Questions: 121
Total Answers: 107

Location: Northern Ireland
Member since Sun, Nov 21, 2021
3 Years ago
;