Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Bert Tobé on October 18, 2003, 02:13:56 PM

Title: MySql error
Post by: Bert Tobé on October 18, 2003, 02:13:56 PM

Who can help me ?

When I use MySqlControlCentre from Windows XP to connect to the E-Smith server (5) the I get the following error

ERROR 1130: Host 'pc-00069' is not allowed to connect to this MySQL server

What do I wrong ?

Thanks in advance
Bert

Title: Re: MySql error
Post by: Paul Isaacs on October 19, 2003, 04:29:03 AM

It seem to me most likely that mySQL has not been set up to allow access from 'pc-00069' .

You need to grant permissions to that from mysql on the host computer.

mysql
> grant ALL on *.* to 'username'@'pc-00069' identified by 'password';

will allow 'username' with 'password' to access all databases *.* from 'pc-00069'.

or
> grant ALL on *.* to 'username'@'%' identified by 'password';

will allow 'username' with 'password' to access all databases *.* from anywhere.

You need to apply this with respect to the security model you choose to use for database access. I suggest you look up 'GRANT'  in the mySQL documentation.

Also, if you are using 5.6, you will need to apply to following RPMs to gain remote connections to the database.

glibc-2.2.5-42.i386.rpm
glibc-common-2.2.5-42.i386.rpm

You can get these from rpmfind.net,

regards

Paul

Title: Re: MySql error
Post by: Bert Tobé on October 19, 2003, 12:42:42 PM

Hi Paul,
It Works, thanks for your help.
Bert