how do I connect to MySql on Rpi from Windows?

[tftdrd60]

Sorry to bug people in here again.
I am having problems understanding and finding out how to access the data on a database in MySQL on the RPi.
I know I have data on there and on the whole my project is coming on exceptionally well thanks to the responses in this group. Thank you everyone.

However I am stuck at the final hurdle getting windows xp/7/8 to view the data on the raspberry pi.
I do have VB.NET2010 on one of the pc's so maybe I just need to know how to connect instead of using another piece of software.... (actually this would be preferable)

I'm sort of demo-ing this tomorrow to my brother so it'd be nice to have it all ready for him.

Thanks in advance.

Terry

[riklaunim]

Host would be the IP address of Raspberry Pi. If you still can't connect check mysql server settings and change it so that not only localhost can connect to it.

[DougieLawson]

1. You need to update the bind-address in /etc/mysql/my.cnf.
2. You need to add an ID that can connect remotely - the default is local user only.
3. You need to be able to find your RPi on the network (using a fixed IP is best, using avahi-daemon makes it easy).