how to set up multiple programs/mysql databases on one machine

matua105 · 04-16-2009, 11:46 AM

I downloaded wamp onto my windows xp pro machine and downloaded drupal and zendframework too.

However, when I fired up wamp i could not connect to the mysql db because i had an older mysql db on the machine.

is there a way to set up multiple mysql dbs on one machine?

the manual says you can but i cannot find details on google how to do this:

http://dev.mysql.com/doc/refman/5.1/...s-servers.html

maybe i haven't looked long enough.

Thanks in advance for your help!

regards,
matua105

mcorton · 04-17-2009, 07:34 AM

Yes, you use the same database name as your first database and ad a trailer to it such as 2. Example. I have wordpress and want to add Joomla. Your database would look something like username_wordpress_2. When you go to install your database you justy add the new name. It should use the same password.

Good luck.

matua105 · 04-21-2009, 08:52 PM

Thanks!

I have set up wamp, and within it, drupal and zend framework, with their own subdirectories. It seems to work ok.

Regards,

matua105

04-16-2009, 11:46 AM	#1 (permalink)
matua105 Registered User Join Date: Mar 2007 Posts: 12 OS: Windows XP	how to set up multiple programs/mysql databases on one machine I downloaded wamp onto my windows xp pro machine and downloaded drupal and zendframework too. However, when I fired up wamp i could not connect to the mysql db because i had an older mysql db on the machine. is there a way to set up multiple mysql dbs on one machine? the manual says you can but i cannot find details on google how to do this: http://dev.mysql.com/doc/refman/5.1/...s-servers.html maybe i haven't looked long enough. Thanks in advance for your help! regards, matua105

04-17-2009, 07:34 AM	#2 (permalink)
mcorton Registered User Join Date: Apr 2009 Posts: 60 OS: Windows xp SP2	Re: how to set up multiple programs/mysql databases on one machine Yes, you use the same database name as your first database and ad a trailer to it such as 2. Example. I have wordpress and want to add Joomla. Your database would look something like username_wordpress_2. When you go to install your database you justy add the new name. It should use the same password. Good luck.

04-21-2009, 08:52 PM	#3 (permalink)
matua105 Registered User Join Date: Mar 2007 Posts: 12 OS: Windows XP	Re: how to set up multiple programs/mysql databases on one machine Thanks! I have set up wamp, and within it, drupal and zend framework, with their own subdirectories. It seems to work ok. Regards, matua105