Creating a MySQL Database for WordPress

in Social Media

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:

[fusion_builder_container hundred_percent=”yes” overflow=”visible”][fusion_builder_row][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”]

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:

[/fusion_builder_column][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”]

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:

[/fusion_builder_column][/fusion_builder_row][/fusion_builder_container]

Tags:

Leave a Reply

Your email address will not be published.

*