> > >2. Grants aren't working. > > > > > >Almost for each db we have the grant I did is something like : > > > > > >grant all on db.* to 'user'@'%.domain.com' identified by 'password'; > > > > > >So, I end up with a user with no global privilege in the user table, and > a > > >entry in the db table with all privs. > > > > > >User table : '%.domain.com', user, pass, N for the rest, exept > > >Lock_tables_priv is Y. > > >Db table : '%.domain.com', db, user, Y for the rest. > > > > > >When users connect from the web server (another machine), they can > connect > > >to the mysql server, but they can't do anything. We get : > > > > > >select command denied to user: '[EMAIL PROTECTED]' for table 'table' > > > > Have one of these users connect and issue this statement: > > > > SELECT CURRENT_USER(); > > > > If the username part of the result value is empty (nothing before the '@' > > character), you probably have a problem of these users actually being > > authenticated using an anonymous-user account. Dump those accounts > > by connecting to the server as root and issuing these statements: > > > > mysql> DELETE FROM mysql.user WHERE User = ''; > > mysql> FLUSH PRIVILEGES; > > > > Then have the user try again. > > > > I get something like : > [EMAIL PROTECTED], which fits the user in the user and db table. I suppose > it's right... Also, I want to point out that those exacts same privs where > working right on my intel box...
Any new hints on this ? Nicolas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
