Connecting to MySQL via ODBC

[redhot]

Hi, I'd like to use my Bubba Two as a database server and use my Windows machine at the front-end via Microsoft Access. To do this I guess I'd need to set up the ODBC data source first but I've tried a few combinations of usernames/passwords etc but with no success. Does anyone know how I can achieve this? Many thanks in advance.

[asparak]

At a guess, I'd say

http://dev.mysql.com/downloads/connector/odbc/5.1.html

[redhot]

At a guess, I'd say

http://dev.mysql.com/downloads/connector/odbc/5.1.html

Thanks for the suggestion but I'm afraid it didn't help.

I think I've now sorted the problem. What I did was to edit the configuration file /etc/mysql/my.cnf by commenting out the line "bind-address = 127.0.0.1" and restarting the mysql server. I also had to go into mysql and add a user with "GRANT ALL PRIVILEGES..." etc and it worked.