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.
Next, type in a new database name and click Create Database
After you click Create Database, a new database will be created with the name you provided, preceded by your host account username.
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.
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.
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.
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:
