Sometimes there are more than one WordPress set up is necessary, but your host might have restricted MySQL Database allocation. Well the remedy for that issue is having several WordPress set up in one database.
You must set up WordPress manually to perform this. Most one click applications like Softculus or Fantastico would not let you select the prefix.
During the set up in your config.php file, you have to modify the prefix “wp_” to allow several set up. So it can be wp17k_ and the next one can be wp452_ you can use different prefix and use them to make as many installation as you need.
That’s all you really need to do. This is also a security measure that you can take even if you don’t want to set up several installation. By having a different prefix, you are making this difficult for a hacker to discover out the actual SQL address.