Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.


Alexander Ayala
Alexander Ayala
4,023 Points

Does every wordpress local install need a seperate database and username?

Just curious if every wordpress local install need a seperate database and username in MAMP? I'm gonna start setting up other wordpress sites now and I was just curious! Thanks!

Dave StSomeWhere
Dave StSomeWhere
19,822 Points

:tropical_drink: Yes every WordPress instance (local or hosted) needs a separate db and user, it is what makes up instance.

But, wait, there's more...

WordPress also provides a Multi-Site feature that might be worth investigating.

Check out the WordPress Codex for your documentation enjoyment.


1 Answer

Yes and no.

Tables in a database yes, you can separate them with different prefixes but user could be the same for all local.

This is advised only for local. For a dev/staging or production server you would not want to do that. You would setup different users for each one then give them access to it and it only.