Check this Out!Visit our social network pages for recent updates!

Student Lesson 26: Create WordPress MySQL Databases via Cpanel

Student lesson 26 assignment: How do you create WordPress MySQL databases via Cpanel?

For students and new users who are just starting out managing online websites and blogs, there’s the easy way and the hard way. 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 come with managing websites and domain the hard way, folks developed tools to help with that process. Tools such as Cpanel and others were developed so that new users can manage websites and domains easily without learning how to configure Linux servers or complicated systems.

The hard way is not for students or new webmasters.

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

Step 1: 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.

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

Lesson 24: Building Your First WordPress Blog via Cpanal

Step 2: 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

Step 2: Create WordPress database user account

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

To do that, go to 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.

Step 3: 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 MySQL configuration page, select the user and the database to which you want to grant the account access to 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!

This database and user can now be defined in WordPress configuration page when setting up a new WordPress installation.

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:

Today’s Lesson: How To Install MySQL Server on Ubuntu