Home/Social Media/Creating a MySQL Database for WordPress

Creating a MySQL Database for WordPress

Creating a MySQL database to use with your WordPress blog is actually much easier than it sounds. If you’ve gone the route of using your own hosting company, which I strongly recommend, you simply login to your CPanel (usually found at www.example.com/cpanel). Almost all web hosting companies offer MySQL database creation via CPanel and they are usually very easy to set up. CPanel looks something like this:

CPanel

CPanel

To create a MySQL database, look around in your web hosting control panel for links labeled MySQL, or even better MySQL wizard. It often looks something like this:

MySQL

MySQL

When you find MySQL all you need to do is:

  • 1. Create a new database (write down the name of the database)
  • 2. Create a new user (write down the username)
  • 3. Create a password for your user (write down the password)
  • 4. Finally, make sure that the user you created in step 2 is assigned to the database you created in step 1, and given ALL PRIVILEGES.

Your CPanel set up for doing this should look like this:

Create a database

Create a database

And you’ll need to set the user privileges so they are:

User privileges

If you can’t figure it out, call your web hosting technical support and ask them to walk you through the process of setting up a new MySQL database, and make sure you get the three vital pieces of information: database name, username (user must be given all priveledges), and password.

After you create the database, you’ll connect your WordPress files to the new database by modifying the config-sample.php file.

Here’s a video explaining the creation of a MySQL database for WordPress:

By | 2016-10-21T21:43:49+00:00 September 16th, 2012|Categories: Social Media|Tags: , |Comments Off on Creating a MySQL Database for WordPress
%d bloggers like this: