Re: MySQL user privileges

2003-09-23 Thread Egor Egorov
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

MySQL user privileges

2003-09-22 Thread Håkon Nilsen \(Exinet AS\)
Hi, 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? 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?

Re: MySQL user privileges

2003-09-22 Thread Egor Egorov
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

Re: MySQL user privileges

2003-09-22 Thread Håkon Nilsen \(Exinet AS\)
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