Page 1 of 1
Connecting to MySQL via ODBC
Posted: 11 Feb 2010, 12:00
by 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.
Re: Connecting to MySQL via ODBC
Posted: 11 Feb 2010, 12:30
by asparak
Re: Connecting to MySQL via ODBC
Posted: 12 Feb 2010, 11:19
by redhot
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.