Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial


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,870 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.