Access mysql on guest from host

[edwardlynn]

I'm running vista as host, ubuntu as guest. Mysql is running fine on the guest, but i cannot access it from host. I have a user which has perms to access from any host. I cannot however access it, and i've read some bits on the net where people are saying they have set up some port forwarding or something. Can anyone give me any clues as to where to start on this issue please?

Thanks

Ed

[Perryg]

Section 6.4 of the VBox users guide covers this. Actually all of section 6 should be your starting place.
If you do not have a real reason to use NAT you should consider using Bridged and your problems should taken care of. This more closely resembles a network environment IMHO.

[edwardlynn]

I am actually using bridged, and can ping the guess os ip.

Thanks

[vbox4me2]

Is the mysql user allowed to access the DB ? (ea. user@%), firewall ?

[edwardlynn]

I had a firewall switched on on the host os, but switching it off didn't fix the issue. No idea about ubuntu servers default setup though, i'll have to have a dig in the docs or something for that one.

The user does have access.

[vbox4me2]

As far as I've read linux filewalls any port above 1000.

[edwardlynn]

So that would include mysql then? on 6603 by default i think is it?

[vbox4me2]

Mysql sits on port 3306.

[baf]

Most linuxes does not firewall ports.
But mysql usually only talks with localhost.
Check in /etc/my.cnf after a line
skip-networking
and comment that out then restart mysql

[edwardlynn]

Thanks for al your help. It was caused by mysql now binding to localhost by default. Removed bind-address from my.cnf and restarted and its sorted. Sweet.