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:
witch mysqld didn't help.
All *.frm files in mysql database have the same md5 as those generated
by scripts/mysql_install_db.
--
Thanks for help,
Vladimir Trebicky mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
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,