Re: Connecting to MySQL via ODBC

I've had the same problem before.  It took a lot of research, but I figured 
something out.  I hope this works for you as well.

check the db table in the mysql database, you need to make sure that the 
host/db/user combination in this table match your needs.  I can't remember 
exactly what I did, but I had to remove an entry specifying the localhost 
for a particular username before I was allowed to connect, if I remember 
correctly.

I have one record in the db table for my database, it is:

("%", "dbname", "username", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "N", 
"Y", "Y", "Y")

This all seems rather cryptic, but if you need additional info, just let me 
know and I'll be glad to try and help.

  - Jeff


At 10:49 AM 6/22/00, Billy O'Connor wrote:
>Hi All,
>
>I've been trying to upload an Access table to a MySQL database via the
>MyODBC driver which I got from TCX and I keep getting a "Host
>123.123.12.123 cannot connect to the database" type error. I know this is a
>permissions problem so have tried the following at the telnet command line:
>
>mysql mysql -u root -h domain.co.uk -p password
>
>mysql>insert into user values
>(%,user,passwd(passwd),Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,)
>         ->mysqladmin reload
>         ->

HWG: hwg-servers mailing list archives, maintained by Webmasters @ IWA