Re: SHOW DATABASES works in 4.0.14

2003-08-21 Thread Victoria Reznichenko
Vladimir Trebicky <[EMAIL PROTECTED]> wrote: > 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 '5b58234a5

Re: SHOW DATABASES works in 4.0.14

2003-08-20 Thread Victoria Reznichenko
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 >

Re: SHOW DATABASES works in 4.0.14

2003-08-19 Thread Victoria Reznichenko
Vladimir Trebicky <[EMAIL PROTECTED]> wrote: > > I've been trying to solve this problem for a long time. Only thing > I did when upgrading from 3.25 to 4.0.14 I took the default my.cnf. I > did not convert the privilege tables with mysql_fix_privilege_tables. > > Suddenly, the mysql started to