Hi ! Our normal server is on RedHat 7.3 / mysql-max 4.0.14. The server just crached, I had to recover on another hardware, a Mac OS X 10.2, wih mysql-max 4.0.15.
The restore went well, but I have some problems : 1. All tables/database are now lower case. This not a major issue, as the dbs are still running ok. I'll handle it later when the intel server is back up again. 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' If we connect as root, the select is working properly. It's not the host either, I tried with % as hosts, and it didn't work. Any hints ? Nicolas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
