Setting Up Database For WordPress

MySQLWhen you have a WordPress blog or website it uses a database to store lots of info, such as the content of posts, pages, images and lots of other stuff connected with the blog or website.

That database facility is provided as part of the package you rent from the hosting service so it’s all there ready and waiting! You just need to set it up!

It’s normally a MySQL database, in case you’re interested, but that’s just techno-babble you don’t need!

So when you install the WordPress files on the server (we haven’t done that yet) you also have to create a new database and couple it to the blog or site.

It’s easy enough and it’s a two-step process.

Step 1 is creating the new database on the hosting server and making a note of the key information needed for Step 2. We’ll run through Step 1 now.

Step 2 is using the key information from Step 1 above to modify a WordPress file named wp-config.php before you upload the WordPress files to the server. I’ll cover that in the next post.

Ok, creating the database and noting the key information:

Go to the Blacknight home page, click on the ‘Account’ tab, enter your user name and password (which you’ll have made a careful note of from when you rented some server space, didn’t you?) and click on the ‘Login’ button. This will take you to your Blacknight control panel.

Go to the ‘More Services’ section at the bottom of the Home Page of the control panel.
More_ServicesClick on the ‘Databases’ link and from there click on the ‘Add New Database’ link at the top of that page.

For ‘Database Type’ select ‘MySQL5 Databases’, or whatever the newest version is, from the dropdown.

This will take you to a page where you need to create a database name, database user name and password.

Do this and make a careful note of the exact and precise details as you will need all this to configure the wp-config.php file later.

Hey Presto! You have your database! Congratulations!

There’s one more piece of info you need. Its the internal hostname.

Go back to the ‘Databases’ page and click on the database you have just created.

On that page you will find the internal hostname.
wp_db01When we get to the stage of putting the configuration info in the wp-config.php file you will need to go back to that databases page, copy the internal hostname and paste it into the correct location in the wp-config.php file.

We’ll go througn all that soon.

Any problems with the above just let me know.

So many applications work in conjunction with online databases, such as CRM’s (customer relationship management), eCommerce, ERP’s (enterprise resource planning) such as SAP, etc. One of the biggest names in databases is Oracle who, coincidentally, owns MySQL! It’s a good area to have a basic understanding of!