Create a MySQL database in cPanel Print

To create a MySQL database in cPanel, follow these steps:

1. Login to cPanel by going to yourdomain.com/cpanel (the username and password is the same as your FTP details)
2. Go to MySQL Databases
3. Under Create New Database, type the desired database name and click Create Database. The database name that you will use in your script is displayed, including a prefix based on your account username.
4. Under MySQL Users - Add New User, type the desired username and password for the database user and click Create User. The username that you will use in your scripts is displayed, including a prefix based on your account username.
5. Under Add User To Database, choose the user and database you just created, then click Add.

Your database is now created and you can use the authentication details per the above in your scripts.

You can manage your database using phpMyAdmin by going to cPanel > phpMyAdmin.

If you receive an error while creating a database, it is possible that your hosting account does not have databases enabled or you have used more than your allocation of databases. Please contact support for this problem to be rectified.