Mysql upgrade 3 to 4, bug :(
I upgraded mysql from 3 to 4, but now all the users can see all the databases (they can't access them, only see them)When i look at the user grants i see this:
SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES
When i try to revoke these privileges and restart the mysql server, they aren't gone! does anybody now how to fix this?
Best regards,
Dirk-Jan Alken