Prepare/Install the Database
Due to the varied and diverse control panels and host setups that are out there, you are required to manually create the database that will hold all of the tables needed for this application. In summary, you must:
- Create a new database using whatever method your host has provided for you to do this.
- Create a database username and password with the permissions required to create tables and access your database (e.g., select, insert, update, delete).
- Associate the username you just created with the database that you just created.
The above steps are usually accomplished through a combination of a control panel, such as cPanel, and/or a tool such as phpMyAdmin.
Make sure that you take note of the complete database name as well as the username and password; this information will be necessary in the next step for allowing RavenNuke™ to connect to your database, complete the installation process, and to run your site.
Example of a cPanel Setup (Detailed Steps):
If your host provides cPanel, here is an example that walks you through the setup of a new database. Your screens may not look exactly like this, but the functionality should be the same.
For this example, we will assume that your site name is ravensite.com and your host username is raven. That means that your database name and database username will automatically be prefaced by raven_. This is an important point to remember. Let us get started.
First, log into your cPanel account. Depending on individual hosts, here again, there could be several ways. One very common way is to use your site url like this: http://www.ravensite.com/cpanel. You will be prompted for your host userid/pass to login to cPanel. After getting logged in, you should see somewhere on your screen an image like this. Notice, I have highlighted the MySQL image, as that is what you need to select.
After you select the MySQL image, you will be presented a screen with database and user information for your MySQL setup. We are interested in the following area of this screen which is highlighted. Here you type in the name of your database and click Add Db.
Now you need to create a username and password that will have access permissions to the database. Down towards the bottom of the screen you will see an image like this. Add a username and a password. Note that most hosts limit the username to 7 characters, so be warned. Then click Add User.
You are almost done :). Only one step left. You have created a database, a username, and a password. But, because you could have many databases and users, you need to tell MySQL which database to associate with which user. In the previous step, where you added/created the database, is where you also will do this association. Scroll back up towards the top and find this area again. Note that a different area is now highlighted. You must select the username and the database name from their respective drop down boxes and then click Add User to Db.
For this example, let us assume that you created the following from the steps above.
- Database Name = nukedb (Your database name will probably be raven_nukedb as I mentioned above)
- Database Username = nukeusr (Your database username will probably be raven_nukeusr as I mentioned above)
- Database User Name Password = nukepass
This information must be remembered for use in the next step as you will add it to a file called config.php.