Tips and tricks on developing web sites

Database prefix

Unlike your Web Development Server, your Hosting Service provider likely hosts hundreds of websites, and they will all have access to SQL databases. To keep track of who owns what database, and avoid duplicates, they will probably assign a database prefix for your domain. You can ask them what your prefix is, or you can go to your host provider’s cPanel->DATABASES->MySQL Database Wizard. In there it will show you the prefix name you have been assigned. Make note of that, as all of your Development Server databases and usernames will need to start with that prefix_ no matter what domain you are working on. For this tutorial, we are going to use examp_ as the prefix your Host provider has assigned.