Re[2]: SHOW DATABASES works in 4.0.14

2003-08-21 Thread Vladimir Trebicky
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

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[2]: SHOW DATABASES works in 4.0.14

2003-08-21 Thread Vladimir Trebicky
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,

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[2]: SHOW DATABASES works in 4.0.14

2003-08-19 Thread Vladimir Trebicky
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

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

SHOW DATABASES works in 4.0.14

2003-08-19 Thread Vladimir Trebicky
Hi, 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 show all databases to all users (even though the use