Apache Friends Support Forum

Is it possible to work on more than one database with xampp?

I have installed WordPress and can only work on one website. I want to work on different looking websites on different databases. At the moment I have one installation of WordPress. Is only 1 allowed? I ask because of course there is only 1 wp-config.php which means I can only work with 1 database, unless I manually change the database name in the wp-config.php each time I want to work on a different looking website.

ACTUALLY - pete51

You can have as many WP installs as you want.

A. Each one will have to be in a differently-name folder i.e. wordpress, wordpress-2, ...
B. each will have to have differentiated database-name in MySQL i.e wordpress, wordpress-2 OR you can use the suggestion of just adding a prefix like 'a-' , 'b ..when you setup Wordpress. You DON'T need different database users, just separate databases. MySQL is actually MANY databases- but ONE database server.

and, therfore, becasue they are in separate folders, every wordpress installation folder will have its own wp.config.php

OTAY???

pete51 wrote:Is it possible to work on more than one database with xampp?

Sure!

pete51 wrote:I have installed WordPress and can only work on one website. I want to work on different looking websites on different databases. At the moment I have one installation of WordPress. Is only 1 allowed?

You can have several Wordpress instances on your XAMPP if you want to.
You can use single database (different prefixes) or multiple databases.

Wordpress itself can handle multiple blogs with one single installation since version 3.

For further reading: http://codex.wordpress.org/Installing_Multiple_Blogs

Thanks very much JonB and Altrea. Everything is clear now. That's a great help.