Due to the varied and diverse control panels and hosts setups that are out there, you are required to manually create the database that will hold all of the tables needed for this application. You will need to use whatever method your hosts has provided for you to create the database.
Next, you must create a username and password for the user who will have authorization to create tables and access your database. This is the MySQL information that you must transfer to the config.php file.
After you have created the user and password, you must then associate that username with the database. This is a very simple procedure that is usually accomplished through phpMyAdmin and/or your Control Panel.
Here would be the general instructions for creating a database using cPanel. Your screens may not look exactly like this, but the functionality should be the same. For this tutorial, 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's get started. First of all, 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://ravensite.com/cpanel. You would 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're 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 by me, for you. You must select the user and the database name from their respective drop down boxes and then click Add User to Db.
For example, let's assume that you created the following from the steps above.
This information must be remembered for use in a later step as you will add it to a file called config.php.
<<< Upgrading | Prepare/Install The Files >>> |