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:
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:
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:
And you’ll need to set the user privileges so they are:
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: