Hmm. Will the users need to connect to the MySQL server itself or is the user administration going to just be using MySQL as a backend database?
If you're just using MySQL as a backend repository for users and the users won't be connecting directly to the MySQL database then you probably shouldn't store their information in the mysql privilege table. Steve On Fri, Nov 19, 2004 at 03:02:36PM +0100, Antonin Karasek wrote: > Hi, > I plan to create a user administration based on MySQL. And I want to > make it really secure :o)) > > As I know, MySQL privilege system is based on "mysql" database, which is > copied into memory at startup. > > > My question is: Should I expect any preformance loss, if some tables > (columns_priv, user) in the database would have thousants of rows? > > Many thanks for tips :o) > > Regards > > Tony > > > -- > To UNSUBSCRIBE, email to [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact > [EMAIL PROTECTED] -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]