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
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
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,
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
>
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
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
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