How to Create a MySQL Database in cPanel

Creating a MySQL Database

Databases store the content for dynamic websites and applications like WordPress, Joomla and Magento. Here is how to create a MySQL database in cPanel.

Step-by-Step Guide

1. Log in to cPanel
2. In the Databases section, click MySQL Databases
3. Under Create New Database, enter a name for your database (e.g. mysite_db) and click Create Database
4. Scroll down to Add New User and create a database user with a strong password. Click Create User
5. Under Add User To Database, select your new user and your new database, then click Add
6. On the next page, select All Privileges and click Make Changes

Note Your Database Details

You will need these details when installing a CMS like WordPress:

• Database name: cpanelusername_dbname
• Database user: cpanelusername_dbuser
• Password: the password you set
• Host: localhost

Managing Your Database with phpMyAdmin

Once created, you can manage your database in cPanel ? phpMyAdmin. See our guide: How to Use phpMyAdmin.