If you're setting up a content management system (like **WordPress** or **Joomla**), an e-commerce platform, or any custom web application, you need a **MySQL database**. This process requires creating the database itself, a dedicated user, and assigning that user the necessary privileges.
This guide demonstrates how to use the quick and easy **MySQL Database Wizard** in cPanel to complete this entire process.
Database Creation Steps
-
Log into your cPanel dashboard.
-
In the **Databases** section, click the **MySQL Database Wizard** icon.
-
Step 1: Create a Database
Enter a name for your new database (e.g.,
sales). cPanel will automatically prefix this name with your account username (e.g.,username_sales). Click **Next Step**. -
Step 2: Create Database Users
Enter a **Username** (e.g.,
myuser) and a **strong Password** for this user. Click **Create User**. -
Step 3: Add User to the Database
Check the **ALL PRIVILEGES** box (or select specific privileges if you know exactly what is required for your application). Click **Next Step**.
Your new **MySQL database** and **user** are now fully set up and ready to be connected to your website's configuration files!
