Topic: mysql odbc help

[Henry Li]

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]

See this post for some info.

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

Craig

[Johan]

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]

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.