5 replies to this topic

[itay]

hello,

I would like to know if it's posibble to install and use multiple mysql databases(mysql server) on one machine running windows.

tnx in advance,

Itay

[WingedPanther]

One server can provide access to multiple databases on any OS. You would only install one instance of mysql, and then configure multiple databases within it.

[itay]

hi WingedPanther, thank you very much for the quick answer, but,
I don't want defernet schemas. I want to servers sitting on two diferent ports on same machine.
because I want to do a total seperation between two database, that's why I want them to be on totaly seperate servers, but I do have only one server machine for that porpse.

[WingedPanther]

If you have different users with different access to the databases, you'll get the same effect. What, exactly, are you trying to accomplish? It sounds like you're looking for the wrong solution to a common problem.

[itay]

you were right :) I realy was looking for the worng solution.
what you suggested is exactly what I need.
I've tried it and it worked perfect for me. tnx a lot, cheers!

[WingedPanther]

Glad I could help :)