Koozali.org: home of the SME Server

mysql odbc help

Henry Li

mysql odbc help
« on: January 09, 2002, 07:20:53 PM »
I get the following error when trying to make and odbc connection from my windows client to mysql in the sme 5.0.

[TCX][MyODBC]Host 'pc-00054' is not allowed to connect to this MySQL Server (#1130)

I checked the user name and password.  What can I do to allow the pc to connect?

Thanks in advance.

Henry

Craig

Re: mysql odbc help
« Reply #1 on: January 10, 2002, 01:01:56 PM »

Johan

Re: mysql odbc help
« Reply #2 on: January 15, 2002, 01:28:49 AM »
Henry,

A MySql database is protected to use only on de localhost (your server) So jou must make a differnet account to acces your database  from a extern (your own work station)

I refer to a other posting with the same problem

http://forums.contribs.org/index.php?topic=12336.msg46312#msg46312

good luck whith you database.

Johan

Henry Li

Re: mysql odbc help
« Reply #3 on: January 16, 2002, 02:20:48 AM »
Thanks Johan,

I did create another user and did a

GRANT ALL PRIVILEDGES on database.table to user@'%' IDENTIFIED BY 'password'

With Grant option is not necessary.

All is working now.

Thanks again to all who scratched their heads. ;)