Create a Database in CPanel
Introduction
Whether you’re manually installing WordPress or building a custom application that needs to store data, the first step is always creating a MySQL database through cPanel. In this guide, we’ll cover both available methods: the “MySQL Database Wizard” and the manual “MySQL Databases” tool.
Create a Database in CPanel
Method 1: Using the MySQL Database Wizard
- Log in to your cPanel dashboard.
- Find the “MySQL Database Wizard” icon under the “Databases” section.
- Enter a name for your new database — cPanel will automatically add your account’s prefix before it.
- Create a new user and set a strong password.
- Select the required privileges (choose “ALL PRIVILEGES” if the database is for your own website).
- Click “Next Step” until the process completes successfully.
Method 2: Manual Creation via MySQL Databases
This method gives you more granular control, allowing you to:
- Create the database first under “Create New Database”
- Create the user separately under “MySQL Users”
- Manually link the user to the database under “Add User To Database”
- Assign precise privileges (SELECT, INSERT, UPDATE, DELETE, etc.)
Important Tips When Creating a Database
- Use a clear, memorable name for your database (such as your site’s name).
- Never share your database password with anyone untrusted.
- Keep a record of the connection details (database name, username, password, and host “localhost”) for use during installation.
Connecting the Database to Your Configuration File
After creation, you’ll need to enter the database details into your platform’s configuration file — for example, the wp-config.php file in WordPress — which requires the database name, username, password, and host name.
Conclusion
Now that you can create a database on your own, the next step is learning how to create users and assign their privileges precisely, which we’ll cover in the next article.
The Wizard is faster and beginner-friendly, while the manual method gives you precise control over privileges — useful when linking multiple users to a single database.
You can’t rename it directly, but you can create a new database and migrate the data to it using phpMyAdmin.
You can reset it anytime from the “MySQL Users” section in cPanel without affecting any stored data.
Content
