How to create WordPress MySQL Database via cPanel

telework 5059653 640
telework 5059653 640

This brief tutorial shows students and new users how to create WordPress MySQL databases via cPanel.

There’s an easy and challenging way for students and new users who are just starting out managing online websites and blogs. However, most new users are encouraged to go via the easy way.

The hard way is for advanced users. Those who have spent countless hours managing websites and/or blogs online. They are comfortable using the command line interface and configuring Linux servers.

Because of the challenges of managing websites and domains the hard way, folks developed tools to help with that process. Tools such as cPanel and others were developed so new users could easily manage websites and domains without learning how to configure Linux servers or complicated systems.

This brief tutorial will show you how to create WordPress databases via the cPanel hosting tool easily. Cpanel makes managing websites and domain changes easy. So easy; you don’t even need to be an IT pro.

Prerequisites

Before you can manage your website using Cpanel, you must first sign up for hosting services from web host providers. These providers include Cpanel utility for users to use to manage their websites.

Those who want to register for a free account to test out can read the post below:

Creating WordPress MySQL databases

After you have signed up for an account, continue below to learn how to create MySQL databases.

First, open cPanel and navigate to the database section as shown below, and select MySQL Databases.

wordpress mysql cpanel databases

Next, type in a new database name and click Create Database

create mysql databases via cpanel

After you click Create Database, a new database will be created with the name you provided, preceded by your host account username.

wordpress-cpanel-mysql-database

Create a WordPress database user account

Your next step after creating the database is creating a user account. This account will have rights to the database and be allowed to store and retrieve data from the database.

To do that, go to the MySQL database configuration page, and under the MySQL user section, type in a user account name and password and click Create a User.

wordpress database user account

That will create a new user account with the name you provided preceded by your host account username.

Grant the user account rights to the newly created database

The final step is to grant the user account rights to manage the database. This account will be the only account to insert data into the database and retrieve data from the database when requested.

At the bottom of the MySQL configuration page, select the user and the database to which you want to grant the account access and click Add.

Wordpress database user account

When prompted to select the rights to give the user account, it won’t hurt to give the account full access by selecting All Privileges. Next, click Make changes to apply.

cpanel wordpress user privileges

That it!

When setting up a new WordPress installation, this database and user can now be defined in the WordPress configuration page.

MySQL databases allow you to store a large amount of information in an easy to access manner. The databases themselves are not easily read by humans. MySQL databases are required by many web applications including some bulletin boards, content management systems, and others. To use a database, you’ll need to create it. Only MySQL users (different than mail or other users) that have privileges to access a database can read from or write to that database.

You may also like this post below:

Posted by
Richard W

I love computers; maybe way too much. What I learned I try to share at geekrewind.com.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: