Vladimir Trebicky <[EMAIL PROTECTED]> wrote: > > 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, I > corrected the tables manually and are ok now.
> > VR> In 4.0.14 --safe-show-database is enabled by default. > > I know, another reason why I'm so confused ;-) > > Is there any way to debug this? > > I attach my SHOW VARIABLES. (which are btw also accessable by normal > users) What is the output of SHOW GRANTS for the users that can show list of all databases? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]