db connection 1142

[mike_ferrer_scane]

Hi there,

I am trying to connect to mysql database on a remote Linux host from my Windows PC.

-I enter the “MySQL Host Address”, for example 111.223.44.56

-I enter the “username”, for example “mike”

-I enter the “password”, for example “losangeles”

-I enter the “database”, for example “cibal”

-and the port number “3306”.

And then click on “connect”… and the main application screen appears (“Cibal – 111.223.44.56.mike”) but no tables are displayed.

If I type “show tables”, no results appear. I have a table called “registry”, if I try to enter the following query “select * from registry”, I get the following error:

Error Code : 1142

select command denied to user: '[email protected]' for table 'registry'

(190 ms taken)

I I telnet the host and connect to my sql and do a grant all privileges on cibal to 'mike' identified by 'losangeles' I still get the same error.

It seems as if the client APPENDS the fully-qualified IP Address to the user. The connection to mysql is OK (since I can see all the databases created with show databases) but if I issue any select statements I get the 1142 error.

I thought of issuing the following command “grant all privileges on cibal to '[email protected]'” to get rid of the error, but I get the following error from mysql:

ERROR 1145: The host or user argument to GRANT is too long

Please, can anyone help me solve this problem as I am unable to use SQLyog.

Thanks for your help

Mike Ferrer

[CalEvans]

Quote:

I telnet the host and connect to my sql and do a grant all privileges on cibal to 'mike' identified by 'losangeles' I still get the same error.

Very close but you need to specify a host.

Either grant all for [email protected] or if you are on dialup and 180-126-117-22.uc.nombres.ttd.es is not your dedicated hostname, try grant on 'mike'@'%'

HTH,

=C=

[mike_ferrer_scane]

CalEvans wrote on May 22 2003, 07:02 PM:

Quote:

I telnet the host and connect to my sql and do a grant all privileges on cibal to 'mike' identified by 'losangeles' I still get the same error.

Very close but you need to specify a host.

Either grant all for [email protected] or if you are on dialup and 180-126-117-22.uc.nombres.ttd.es is not your dedicated hostname, try grant on 'mike'@'%'

HTH,

=C=

Thanks for your reply! After some fiddling with the user table I managed to grant all access from any host.

mike

[Author]

Posts