Creating a MySQL Database and User

As this is a cPanel web hosting platform, databases can only be created through the cPanel interface – they cannot be created through command line nor phpMyAdmin. The easiest way to create a new MySQL database and user is via the MySQL Database Wizard.

Note: if you are using Installatron/Softaculous to create a CMS, these app installers will create a database and user on your behalf.

Using the MySQL Database Wizard

The wizard will run you through creating both a database and user, linking both and setting permissions:

1. Log in to your cPanel service.
2. Click the MySQL Database Wizard icon.
   1. On Step 1 enter the desired name for your database, then click Next Step.
   2. On Step 2 enter the desired username and password to link to the database, then click Create User.
   3. On Step 3 select the desired privileges for the user on the database, this determines how the database may be managed, then click Next Step.

You can then use the MySQL database and linked user within your favourite script platform (such as WordPress or Joomla) to install it.

Creating a database from the MySQL Databases section of cPanel

Using the MySQL Databases section is a little less straightforward, but it provides more freedom by allowing you to link additional users to a database (allowing multiple).

1. Log in to your cPanel service.
2. Click the MySQL Databases icon.
3. Under Create New Database you may enter your desired database name
   1. Click Create Database.
   2. Your new database will then be created and the screen will confirm its success.
   3. Click Go Back to return to the MySQL Databases section of cPanel.
4. Under MySQL Users → Add New User, enter your new database username/password
   1. Then, click Create User.
   2. Your new database user will then be created.
   3. Click Go Back to return to the MySQL Databases section of cPanel.
5. To then link your new database and user go to Add User To Database.
   1. Select a user from the drop-down menu.
   2. Select a database from the drop-down menu.
   3. Click Add, then on the next page select the privileges to grant. If you’re not sure, select all privileges.
   4. Click Make Changes to confirm.