Re: Connecting to MySQL via ODBC

Hi Jeff,

Thank you for replying.

I sorted it out 5 minutes ago - Isn't that always the way :-)

The reason it wasn't working was I was missing the semi-colon at the end of
the command, which is why it was returning -> rather than mysql> and
wanting another command. Also, the "mysqladmin reload" command has to be
run from the telnet prompt, so you need to exit mysql to run it and I was
trying to run it from the -> prompt.

It's amazed me how much I've learned today. I'll probably not use what I've
picked up for another 6 months and have the same problems :-)

Bill.

At 12:59 22/06/2000 -0400, Jeff Diaz wrote:
>
>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

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