Introduction
This guide explains how to create a MySQL database and database user in cPanel. This will allow you to use the database for a Magento or WordPress site.
This uses the cPanel MySQL Database Wizard. It’s also possible to complete the process directly using phpMyAdmin, but this requires 2 separate steps.
Requirements
A cPanel admin account.
For reference, these instructions were followed using cPanel version 88.0.11.
Skill Level
Basic knowledge of cPanel.
Instructions
Time needed: 5 minutes.
- Log into your cPanel.
- Start the MySQL Database Wizard.
In the Databases section, click MySQL Database Wizard.
- Create the database.
In the New Database name field, enter a name for your database and make a note of it.
Click Next Step. - Create the database user.
Enter the relevant details in the Username, Password and Password (Again) fields. Make sure the password is secure, and make a note of all the details in your favourite password manager.
Click Create User. - Set the database user privileges.
Tick All Privileges.
Click Next Step.