List:General Discussion« Previous MessageNext Message » - Peter Padberg Date:August 2 2003 10:45pm
Subject:Update from 3.23 to 4.0
View as plain text  

I updated my MySQL from 3.23 upto 4.0 and now began the problems!

All Users in my mysql-db are with this privileges:
INSERT INTO `user` (`Host`, `User`, `password`, `Select_priv`,
`Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`,
`Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`,
`Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`,
`Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`,
`Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`,
`Repl_client_priv`, `ssl_type`, `ssl_cipher`, `x509_issuer`,
`x509_subject`, `max_questions`, `max_updates`, `max_connections`)
('localhost', 'SOME_USER', 'SOME_ENCRYPTED_PASSWORD', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'Y', 'N', 'N', 'N', '', '', '', '', 0,
0, 0),

And Show_db_priv is definitiv to N.

But when I login as a user I see ALL other databases.

I only want that the users do not see the other databases.
Must I edit something else, I read the online-help,
but it seems that I made everything right. :(

Did I made something wrong or is it a bug?

Viele Gruesse,

Peter Padberg                           Pyrmonter Str. 42
Webagentur                      31789 Hameln
Geschaeftsfuehrung                      Germany
Telefon: +49-5151 60 99 70-0            Peter.Padberg@stripped
Telefax: +49-5151 60 99 70-1  

Update from 3.23 to - Peter Padberg3 Aug
  • Re: Update from 3.23 to 4.0Dan Nelson3 Aug