How to Create a MySQL Database in cPanel

When you create a database, many users are unaware that there are several other items that you need to do as well. The new database creation process actually involves:

  1. Creating a database
  2. Creating a database user
  3. Giving your database user access to work with your database

Luckily for us, cPanel includes a MySQL Database Wizard that walks you through each of these steps.

Creating a database in cPanel using the MySQL Database Wizard:

  1. Log into your cPanel.
  2. Click the MySQL Database Wizard under the Databases heading.
  3. Next to New Database enter a name for your database and click Next Step.
  4. Next to Username enter a username.Enter a password next to Password, enter it again for Password (Again) and then click Create User.
  5. On the next page, you'll assign privileges for the user to the database. Check the box next to All Privileges and then click Next Step.

Congratulations, now you know how to successfully create a database!

  • 2 utilizatori au considerat informaţia utilă
Răspunsul a fost util?

Related Articles

How To Change cPanel Default Time Zone

The .htaccess file is a hidden text file within your hosting account that can be very powerful....

How To Restore a Home Directory Backup in cPanel

In this article I'm going to show you how to restore a partial home directory backup in cPanel....

Install SSL certificates with cPanel SSL/TLS Manager

Enable SSL/TLS Manager in WHM for cPanel users Before using the SSL/TLS Manager as a cPanel...

5 Important Things to Consider When Choosing a Domain for Your Business or Website

When first setting up any website, one of the hardest — but most important — things to decide is...

How To Create an A-Record in cPanel

Let's start with a brief explanation of DNS. DNS stands for Domain Name System. It converts human...