Thank you, Egor, I *had* the anonymous user, but I deleted it since I couldn't find the use for it. But I figured out what the problem was. I was using --safe-show-database, but it didn't seem to work.
My error was that I gave users privileges. I also gave the privileges to the user on the database. So I removed the privileges on the user (select, insert, delete, insert), and then it worked. So, now the users don't have any privileges as a user, but privileges on spesific databases for the user. Thanks! Best regards, Haakon Nilsen ----- Original Message ----- From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 22, 2003 2:32 PM Subject: Re: MySQL user privileges > "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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
