I manage to configure MySQL, and I can connect and do all needed operations from ASP.NET, but there are two problems that I just can't get solved. 1. How can I configure MySQL so that databases created from certain users obey to a predefined name policy? For
example: user1, from web site web1, can only create databses which name starts with web1_dbname, then user2 and so on. I have tried to add to the db table in MySQL the prefix web1_* and web1_% but the users would still be able to create databases without that
prefix. 2. How can I configure MySQL so that all my users databases are served out a different directory per user, as opposed to the common MySQL\Data directory. Looked around for this one, and some say it's very possible but they have not posted the how.
Thanks.
theSCIENTIST
Member
95 Points
19 Posts
MySQL databse name options!
Aug 25, 2003 12:06 AM|LINK