[NTLUG:Discuss] ODBC to MySQL

[Bug Hunter]

 You have to put in an ODBC driver on windows.  MySQL folks have that on
their web site.

  You then connect to it just like you would with M$ SQL server, etc.
I've done it before, and use VB to connect to a MySQL database.

  Note that MySQL GRANT command has to be issued to allow the
user at winmachine to connect to the database and issue selects, updates,
inserts, etc.  You do this with /usr/local/mysql/bin/mysql on the mysql
database host machine.

 If you haven't done so already, download the MySQL pdf file with the
documentation.  The linux xpdf program will read the pdf file under linux,
Acrobat 4.0 under Windows will read the same file.

  It goes through several examples of setting up permissions for the mysql
database, and explains the grant command.

bug




On Wed, 31 Jul 2002, Bobby Wrenn wrote:

> I know this is blasphemy. But, the only way I'll be allowed to use MySQL on 
> the backend is if I can let EUs use Access on the front end.
> 
> I know it can be done. But everything I found describes using MySQL on the 
> the M$ box along with Access.
> 
> I need to connect Access users to MySQL on a Linux box.
> 
> What do I need to do on both ends?
> 
> Thanks
> Bobby
> 
> _______________________________________________
> http://www.ntlug.org/mailman/listinfo/discuss
>