> >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... Thanks Nicolas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
