Re: MySQL show databases - all db shown

2005-11-03 Thread Michael Stassen
Paul DuBois wrote: At 12:59 -0500 11/2/05, Michael Stassen wrote: BÁRTHÁZI András wrote: GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'user'@'localhost' IDENTIFIED BY PASSWORD 'xx' GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, EXEC

Re: MySQL show databases - all db shown

2005-11-03 Thread Gleb Paharenko
Hello. If all your users has 'SHOW DATABASES' privilege, it is normal behavior. However, probably, it is not you want. You may want to update the grant tables manually and revoke this privilege from your users. BÁRTHÁZI András wrote: > Hi, > > When I migrated from 3.23 to 4.0 version (

Re: MySQL show databases - all db shown

2005-11-02 Thread Paul DuBois
At 12:59 -0500 11/2/05, Michael Stassen wrote: BÁRTHÁZI András wrote: Hi Michael, Thanks for your help. When I migrated from 3.23 to 4.0 version (if I'm remember well), I think I missed to upgrade something, so all my MySQL users are able to see the list of the databases on my server. Curr

Re: MySQL show databases - all db shown

2005-11-02 Thread Michael Stassen
BÁRTHÁZI András wrote: Hi Michael, Thanks for your help. When I migrated from 3.23 to 4.0 version (if I'm remember well), I think I missed to upgrade something, so all my MySQL users are able to see the list of the databases on my server. Currently, the MySQL version is 5.0.15, i ran the mys

Re: MySQL show databases - all db shown

2005-11-02 Thread BÁRTHÁZI András
Hi Michael, Thanks for your help. When I migrated from 3.23 to 4.0 version (if I'm remember well), I think I missed to upgrade something, so all my MySQL users are able to see the list of the databases on my server. Currently, the MySQL version is 5.0.15, i ran the mysql database upgrade scri

Re: MySQL show databases - all db shown

2005-11-02 Thread Michael Stassen
BÁRTHÁZI András wrote: Hi, When I migrated from 3.23 to 4.0 version (if I'm remember well), I think I missed to upgrade something, so all my MySQL users are able to see the list of the databases on my server. Currently, the MySQL version is 5.0.15, i ran the mysql database upgrade script, but

MySQL show databases - all db shown

2005-11-01 Thread BÁRTHÁZI András
Hi, When I migrated from 3.23 to 4.0 version (if I'm remember well), I think I missed to upgrade something, so all my MySQL users are able to see the list of the databases on my server. Currently, the MySQL version is 5.0.15, i ran the mysql database upgrade script, but it still is a problem.