We are offering our hosting customers MySQL databases. Ideally, I would like to offer everyone unlimited databases. What I would like is an option that when connecting to a database as a user, the MySQL server would access the actual database in the directory of the username. That way users could create and delete databases normally, and no names would conflict with other users.
For example, if the user databases were stored in /db/, it would lookup the authentication info from the mysql database in /db/mysql/ as normal. Then when user joe successfully authenticated, it would give him access to all of the databases stored in /userdb/joe/, and allow him to create and delete as normal. This would be a very powerful feature, but I don't know how difficult it would be to implement it. Can anyone who has worked with the MySQL codebase commenton this? Is there a point to working on it for the 3.23 branch? I would really like to have this feature, but I don't know the direction to take with this. Thanks, -- David Phillips <[EMAIL PROTECTED]> http://david.acz.org/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
