From: Sasha Pachev Date: February 5 2002 3:59am Subject: Re: Jailed MySQL for hosting customers List-Archive: http://lists.mysql.com/internals/2774 Message-Id: <200202050359.g153xut25776@mysql.sashanet.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit On Monday 04 February 2002 07:29 pm, David Phillips wrote: > 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 > comment on 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. I must admit I was very curious to read your message when I saw the word "jailed" in the subject, and misread it as "Jailed for MySQL hosting" :-) Seriously speaking, the feature your are proposing will be useful as I imagine many hosting companies will be benefited by it. However, there are some practical implementation issues - MySQL is a threaded server, and it will be difficult, if not impossible, to make a thread to setuid() to the user without wreaking havoc for everyone else. You could, of course, simply create databases as symlinks to the user directory, but everything there would have to be owned by MySQL server user. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/