Multiple Mysql DB's

Hellzone · Apprentice Joined: 23 May 2003 Posts: 167

Is there anyway i can set up multiple Mysql DB's without re running the whole server time and time again to allow my users to be able to set their own permissions, have their own DB users etc..?

vericgar · Posted: Sun Jun 08, 2003 9:07 pm Post subject:

It doesn't look there is a way to do that... I've just gone through a lot of the manual and did some googling. Though I did come up with this, from the mysql mailing list, dated November 2002:

http://www.geocrawler.com/archives/3/8/2002/11/0/10266599/

In summary, each mysqld doesn't take up that much memory when it's idle, and when it's not, the difference between having 40 connections to 40 different mysqld isn't much from having 40 connections to the same mysqld. Either your box can handle it or not. The easiest way is to setup the seperate mysqld's instead of having to figure out how to restrict each user so that they only have access to thier data.

Be sure to let us know if you find a way to do virtual mysql hosting though, I'd be interested to see how it's done.
_________________
+~+ Sometimes a good ole loving kick is all it needs +~+

metalac · Posted: Mon Jun 09, 2003 2:32 am Post subject:

why not run one mysqld and have multipble DB's in that one and have each DB have different permission. With tools like PHPMyAdmin you could have that running in no time. I run two different MySQL servers like that and everything appears to work just fine.
_________________
>>>>> Ignorance is bliss <<<<<

Hellzone · Apprentice Joined: 23 May 2003 Posts: 167

Well i have tried that except the only problem being my users can't add users etc which will effect their own databases without being able to change privallages for other users.

This is kind of an annoyance even when they have a db dedicated just to them with full privallages to that db.

-James