hands modeling clay

You found the perfect home-based business, but it requires a website using a MySQL database. Do you hire someone? Do you build it yourself? How hard could it be?

To create a MySQL database in cPanel to unlock mobile phones isn’t as difficult as it sounds. We’ll help you see that, rather than you doing everything, all of the really hard work has already been done for you behind the scenes.

You’ve made the decision to unlock phones by building your own mobile phone unlocking website. However, instead of purchasing the Website Hosting Assistance service that StockUnlocks offers, you want to do it yourself.

Therefore, you just need to know the steps to follow in order to customize the process for your own website.

First of all, here’s a Quick Summary of what you will do to get your cell phone unlocking business started:

  • Create a new MySQL database in cPanel and a user account.
  • Upload the latest version of WordPress to your hosting environment.
  • Install and activate WordPress using the new MySQL database and username values.

Note: The following tutorial can be used for creating a MySQL database in cPanel for any kind of website running WordPress. So, follow along if all you want to do is simply Create a MySQL Database in cPanel.

With that in mind, here’s what you will need for this tutorial:

Create a MySQL database in cPanel

Step 1: Login to cPanel

cpanel databases section containing link to mysql databases Under the section DATABASES, click MySQL® Databases. Rather than opening a new tab, this results in opening a new window.

Step 2: Create the Database

the create new database text field in cpanel Under the section “Create New Database” you will see “New Database”.

Enter the new database name in the space provided.

Note: You are simply adding to the first part of the database name that is already chosen for you. Since we will need it later on when setting up the WordPress installation, make a note of the entire database name.

Click Create Database

message appearing in cpanel after adding a mysql databaseAs a result, you will see the message: “Added the database …”

Click Go Back at the bottom of the message screen.

Step 3: Add New User with Password

Scroll down to the section labeled MySQL Users … Add New User.

the add new mysql user text field appearing in cpanelEnter the new username in the space provided.

Note: Because WordPress enters the first part of the username, you are simply adding to the second part of the username. Due to possible naming conflicts, the first part is done for you. Again, make a note of the entire username.

Enter the password in the spaces provided. The password needs to be entered twice for verification.

Make a note of the complete username and password.This is especially important since we will need these later on when setting up the WordPress installation.

Click “Create User”.

the successfully created a mysql user message in cpanelAs a result, you will see the message: “You have successfully created a MySQL user named …”

Click “Go Back” at the bottom of the message screen.

Step 4: Add a User to the Database

Scroll down to the section labeled “Add User To Database”.

the add user to database drop-down selections in cpanelSelect the created username in the “User” drop-down list, then select the created database in the “Database” drop-down list.

Click “Add” to add the username to the database.

the manage user privileges selections for myql databases in cpanelAs a result, the MySQL® Databases page will appear displaying the “Manage User Privileges” list.

Rather than assuming that everything went well, confirm that the correct entries appear next to “User” and “Database”.

Check the “ALL PRIVILEGES” box. A check mark will appear in all displayed options.

Click the “Make Changes” button at the bottom.

Click “Go Back” to return to the previous screen.

Step 5: Confirm the Database Settings

the mysql current databases section showing associated usersScroll to the “Current Databases” section to confirm that your database exists under “Database” and the desired username appears under “Privileged Users”.

You have successfully created a MySQL database in cPanel. In addition, everything is now in place to install WordPress in your web hosting environment.

The MySQL database will be used to securely store website configuration settings, usernames, passwords, and everything else related to your online business for unlocking mobile phones.

After creating the MySQL database, the next step will be to install WordPress. The WordPress installation process relies on a pre-existing MySQL database.

MySQL Database in cPanel: Summary

This tutorial outlined everything you need to know in order to:
  • Create a MySQL database in cPanel and add an authorized user in order to access the database.

Check out the tutorial : How to Install  WordPress in cPanel to get you closer to your goal of unlocking cell phones using WordPress and the StockUnlocks plugin.

The next tutorial will help you to:

  • Upload the latest version of WordPress to your hosting environment.
  • Install and activate WordPress using the new MySQL database and username values.

If you think that we missed something or that you need further explanation about any of the steps above, please let us know.

In addition to this tutorial for Creating a MySQL database in cPanel, we will be posting more tutorials to help you make your own website using WordPress. Because setting up a website can be confusing if you’re first starting out, we’ll do our best to simplify every step for you.

We hope that this tutorial sets you off on the path to creating the best mobile unlocking website that you can build on your own.

Much success to you and your new online business!

LEAVE A REPLY

Please enter your comment!
Please enter your name here

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