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
