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:http://lists.mysql
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> 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 additio
atabase" in my.cnf and
"--skip-show-database" 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
