Mysql Help - Multiple Mysql On One Server

StormLiong

<div class="IPBDescription">can anyone tell me if this is right?</div> Hi,
I was reading through the MySQL manual and trying to lookn into how I can make do multiple databases. Basically my Student Union's <a href='http://www.uclu.org' target='_blank'>webserver</a> (A Windows2000 server) not only host our union website but also the clubs and socities websites. These clubs and socieities websites are administered independently by their own people.
My webserver address is www.uclu.org
While teh clubs&Societies are at www.societyname.uclu.org
As such they are stored outside of the folder where the union website files are.
So for example on the webserver, my main union website files are kept at D:\Websites\Union
while the clubs and societies websites files are kept at D:\Websites\Society'sName

What Ive trying to do is to give each clubs and societies website the abiltity to have a MySQL database. MySQL itself has already been installed on the server and has been setup for union server only. Now ive been reading this <a href='http://www.mysql.com/doc/en/Multiple_Windows_services.html' target='_blank'>part</a> (Starting Multiple Windows Servers as Services) of the manual and I think this is the procedure I would follow. BUt then it seems to imply it for when I need to upgrade MySQL and leave the old one running temporary.

Can anyone help clarify this for me please? Hopefully Ive explaied it well

Thx

Fam

Can you not run the one mySQl installation, and set up all societies and clubs with seperate user accounts with appropriate permissions to only access one specific database? Then they can set up all their necessary tables within that database, and they wont be able to mess with any others.

<a href='http://www.mysql.com/doc/en/Database_use.html' target='_blank'>Setting up new databases</a>

<a href='http://www.mysql.com/doc/en/User_Account_Management.html' target='_blank'>Managing mySQL user accounts</a>

StormLiong

Thanks alot!

From the guide this seems to be the procedure I am suppose to follow. I'll try it out when i get into work on Monday. Cross fingers that I dun end up screwing up the server.

Although those instructions seem to imply on a Linux server. I hope its the same steps as on a Win2k server.

Again 10q

StormLiong

Not sure if it was ok to double post since this is totally different.
Anyways i read this in a book

<!--QuoteBegin--></span><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td><b>QUOTE</b> </td></tr><tr><td id='QUOTE'><!--QuoteEBegin-->
If you are running a hosting service and would like to provide access to MySQL
for your users, a standard solution is to create a database for each user and
grant that user full rights on it:

CREATE DATABASE username;
GRANT ALL ON username.* TO 'username'@'localhost' IDENTIFIED BY 's3cretk3y';
<!--QuoteEnd--></td></tr></table><span class='postcolor'><!--QuoteEEnd-->

I think that wat i need to do for my situation. Any comments?

Fam

Yeah, that sounds about right. I would suggest trying google for a few examples, I am sure someone has done it before. Good luck with it. <!--emo&:)--><img src='http://www.unknownworlds.com/forums/html/emoticons/smile.gif' border='0' style='vertical-align:middle' alt='smile.gif'><!--endemo-->