Creating a database in cPanel is not a time-consuming process. The main thing is to follow the step-by-step instructions. Let’s look at how to create a database in cPanel, as well as create and add a user more clearly.

How to create a database in cPanel

Create-Database-cPanel

  1. Log into cPanel.
  2. Under the “Databases”, click “MySQL databases”.
  3. In the “Create database” field, type the name of your new database.
  4. Click “Create database”.

As you can see, creating a cPanel database is easy enough! All is ready!

How to create a new user

Create-User-cPanel-2

After we figured out how to create a mysql cPanel database, let’s find out how to create a new user. The first thing to do is log into cPanel. Your next steps:

  1. Log into cPanel
  2. Under the “Databases”, click “MySQL databases”.
  3. Click “Jump to MySQL users”.
  4. Find a set of fields called “Add a New User”.
  5. Enter a username in the corresponding field and password into both “Password” and “Password (confirm)”.
  6. Click “Create User”.

How to add a user to the database

To add a user to the database, go to cPanel. In the Databases section, click on MySQL Databases and then Go to MySQL Users. Next steps:

  1. From the “Database” drop-down menu, select the database to which you wish to allow the user to access. Click “Add”.
  2. From the “MySQL Account Maintenance” screen, select the privileges you wish to grant the user, or select ALL PRIVILEGES.
  3. Click “Make changes”.

Now you can install any applications. For example, Bitrix, WordPress or any other CMS that needs access to the hosting database. If you have any questions related to cPanel settings, please contact us using one of the most convenient methods described on the site. Good luck!