Installing multiple Wordpress to one database

If, like me, you have a restriction on the amount of SQL databases you can have on your hosting then this is a little tip that I had trouble finding out when I wanted to create more Wordpress sites.

I have a restriction of 15 databases with my 1&1 hosting account, I started to look around for a new host but didn’t really fancy moving all my domains as it would be a bit of a nightmare, so this is the solution.

In your wp-config.php file you can change the prefix of the tables that are created, the default is ‘wp_’ so you can change this to anything else, for example ‘ps_’ or ’sq_’, this will enable multiple installs of wordpress on one database.