Loading...
Changes Saved.
Error Occurred!

KnowledgeBase

mySQL Databases for Scripts

Most PHP scripts (such as message boards, forums, carts, blogs, and galleries) will require a mySQL database to run. Each hosting plan from us comes with the ability to create certain amount of mySQL databases (which can be deleted when no longer in use to make room for other scripts).

Creating a mySQL database for your script should be done BEFORE you install the script (in most cases) and is not very difficult. However, you should read this first and know what you're doing!

IMPORTANT! - If you are going to install a script that requires a mySQL database (AND MOST DO), make sure that you do NOT use your master hosting account username and password as the database user. A new database for the script should be created with it's own unique username and password from within the mySQL section of your hosting control panel. When in doubt, ask us first and we will point you in the right direction.

Here are the standard instructions and rules of thumb:

1. Before you upload and install your script, you must create a database for it and a db user / db pass for that script. This information will typically be used in the settings file / setup file during your script installation.

2. To create a new mySQL database for a new script install, log in to your cPanel (hosting control panel) and click the mySQL Database Wizard icon. This will walk you through the process step by step.

We strongly recommend watching our video tutorial first - click here for the video.

Now you have a new mySQL database, db user, and db pass, to supply in the settings / config file of your script, and you may now upload your script files to the server (after editing the settings / config file of the script appropriately according to the install instructions from the script devleoper) and proceed to install the script.

It is extremely imprtant to follow the documentation from the developer for proper installation of the script. This usually involves setting certain file/folder permissions via FTP first.

If all of this is baffling to you, then it is probably a good idea for you to NOT proceed until you contact us for some guideance.




Related Articles