Connecting to MySQL via ODBC

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
        ->

I then try to reconnect to the server, with appropriate username and
password and get exactly the same error - Host cannot connect to server.
I've tried the above SQL statement with and without single quotes ( ' ),
but either way nothing !

As I'm using the wildcard (%) for IP/hostname, it should allow me
permission to connect from any IP, but it doesn't even seem to be entering
any values into the user table.

I've been trying this for over 6 hours now, trying different things and
it's driving me nuts ! It must be something so simple that I'm not doing,
but I cannot see what and this is my first attempt at MySQL.

Hope someone can help.

Regards,

Bill.

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