"H?kon Nilsen \(Exinet AS\)" <[EMAIL PROTECTED]> wrote: > > All my MySQL users have access to all databases and all tables, allthough > I've only given them access to one. > > How can I correct this?
Do you have entry for anonymous user in the table 'user'? > > Is it possible to have them *only* see their database when i.e. typing 'show > databases;', and also refuse them connection to any database but their own? If you use 3.23.xx you should run mysqld with --safe-show-database option: http://www.mysql.com/doc/en/Command-line_options.html From 4.0 user should have SHOW DATABASES privilege. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]