VR What is the output of SHOW GRANTS for the users that can show list of all
databases?
Here it is:
Grants for [EMAIL PROTECTED]
GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO
'guru'@'localhost' IDENTIFIED BY PASSWORD '5b58234a58cd6a22'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP,
VR User has some privileges on the global level (CREATE
VR TEMPORARY TABLES, LOCK TABLES). That is why user can see list of
VR all databases.
All right! :) It works, thanks! :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
VR What do you mean didn't work properly'? What exactly was
VR wrong with mysql_fix_privilege_tables?
Sorry, cannot reproduce the error. The result was that some of the
tables were corrected, some not. Anyway, even old privilege tables
shouldn't IMHO cause the SHOW DATABASES to work. In addition,