Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Henry Li on January 09, 2002, 07:20:53 PM

Title: mysql odbc help
Post by: Henry Li 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

Title: Re: mysql odbc help
Post by: Craig on January 10, 2002, 01:01:56 PM

See this post for some info.

http://www.e-smith.org/bboard//read.php?f=3&i=10512&t=10512

Craig

Title: Re: mysql odbc help
Post by: Johan 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

Title: Re: mysql odbc help
Post by: Henry Li 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. ;)