"H?kon Nilsen \(Exinet AS\)" <[EMAIL PROTECTED]> wrote: > > 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.
If user has any privileges on the database, he can see that database in the output of SHOW DATABASES. > > So, now the users don't have any privileges as a user, but privileges on > spesific databases for the user. -- 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]