From: Paul DuBois Date: April 8 1999 11:53am Subject: Re: User authentication and multiple databases (newbie question?) List-Archive: http://lists.mysql.com/mysql/1524 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" At 2:49 AM -0500 4/8/1999, Thomas Olsson wrote: >Hello, > >I am developing an application where I want to use multiple databases. >Different users should only have access to one of these. For this I >would like to store the user information i each database, instead of in >the 'mysql' database. How ever I have failed to get this to work. > >Now, after reading a lot of documentation and HOWTOs I have not been >able to find any instance that describes the kind of thing I mention >above. Is this not possible? I have been trying to set something up that >resembles the tables in the mysql database for authentication purpose, >but have not been succesful. Is there some way of obtaining something >like what I am describing above without to much hassle and "dirty" >solutions? > >I am perfectly aware of the tables User, Host and Db, from which one can >set up access privileges for different databases and do everything I'm >asking for. But what I don't like is the fact that all the users has to >reside in the same table. I can potentially get many users. The grant tables are indexed, can you explain why having "many users" is a problem? >Also I want the individual users to be able to change their password and >to reduce security problems I thought of separating the users into >separate databases. What are the "security problems" you hope to reduce? Users can change their passwords now using MySQL's own security. -- Paul DuBois, paul@stripped Northern League Chronicles: http://www.snake.net/nl/