Topic: MySql error

[Bert Tobé]

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

[Paul Isaacs]

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

[Bert Tobé]

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