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.
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
At 11:30 -0400 10/14/03, Nicolas Ross wrote:
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
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 :