I think I found out how to fix this one...
Check the (user) privileges page in phpmyadmin. In our case, there is a difference between users created /before/ we upgraded to mysql4 and those after:
User Host Password Global privileges Grant user_a localhost Yes USAGE No user_b localhost Yes CREATE TEMPORARY TABLES, LOCK TABLES No
user_a is an "old" user, created on mysql 3.x, able to view all databases on the server.
user_b is a new user, created on mysql 4.1.x, able to view just his "own" database and the test db.
When you edit the user_a's privileges and remove CREATE TEMPORARY TABLES and the LOCK TABLES privilege, he won't be be able to view all databases on the system anymore.
Is this a bug in the mysql_fix_privilege_tables script or something? We ran this on our server after the upgrade...
Regards,
Luc
-- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
