List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 26 2001 10:32pm
Subject:Re: grant on user@'my.ip.here.%' problem
View as plain text  
At 9:56 PM +0200 9/26/01, Ole Gjerde wrote:
>Hey,
>Had a problem today, and I can't figure it out.  Tried searching in the
>archives and on groups.google.com, but no luck.
>
>OS: RedHat Linux 7.1 on i386
>Mysql: 3.23.41
>
>This is what I did:
>
>GRANT SELECT, INSERT, UPDATE, DELETE on mydb.* TO myuser@'10.1.1.%'
>IDENTIFIED BY 'mypass';
>Can't connect locally using tcp/ip(box is in the 10.1.1 class C, say
>10.1.1.30) (Access denied for user: 'myuser'@'host.mydomain.com')
>
>GRANT SELECT, INSERT, UPDATE, DELETE on mydb.* TO myuser@'host.mydomain.com'
>IDENTIFIED BY 'mypass';
>Can connect locally using tcp/ip just fine(host.mydomain.com maps to
>10.1.1.30)
>
>SHOW GRANTS FOR 'myuser'@'10.1.1.%'  (and 'myuser'@'host.mydomain.com')
>shows them normally.
>
>Any ideas?

See if you have any entries in the user table that have blank User
columns.  If so, delete them, FLUSH PRIVILEGES, and try connecting again.

>
>Thanks,
>Ole Gjerde


-- 
Paul DuBois, paul@stripped
Thread
grant on user@'my.ip.here.%' problemOle Gjerde26 Sep
  • Re: grant on user@'my.ip.here.%' problemPaul DuBois27 Sep