How to create and manage MySQL Databases and Users

June 07, 2026 Web Hosting and Control Panels (cPanel)

If you are installing a web application manually (like WordPress, Joomla, or a custom PHP script), you will need a MySQL Database to store your website's data and a MySQL User to access that data.

The easiest and safest way to do this is by using the Database Wizard inside your control panel. Follow these simple steps:

Step 1: Open the Database Wizard in cPanel

Log in to your cPanel dashboard directly (using yourdomain.com/cpanel or via the CeylonServers Client Area).
In the top search bar, type "MySQL" or scroll down to the Databases section.
Click on "Database Wizard".

Step 2: Create Your Database

Under Step 1: Create A New Database, enter a name for your database in the text box (e.g.: wpdb).

Note: Your full database name will look like yourusername_wpdb.

Click the "Next Step" button.

Step 3: Create the Database User

Now, you need to create a user that has permission to access this database.

Under Step 2: Create Database Users, enter a Username (e.g.: dbuser).
Enter a strong Password. We highly recommend clicking the "Password Generator" button to create a secure password.
Important: Copy the Database Name, Username, and Password to a notepad file. You will need these details later during your website installation.
Click the "Create User" button.

Step 4: Grant Privileges to the User

To link the user and the database together so they can communicate:

Under Step 3: Add User to the Database, check the "ALL PRIVILEGES" box at the top. This gives your database user full control to read and write data.
Scroll down and click the "Next Step" button.
You will see a success message saying: "User was added to the database."

How to Manage Existing Databases (Delete or Change Passwords)

If you ever need to check, modify, or delete a database you already created:

Go back to the cPanel main home screen.
Click on the regular "Manage My Databases" icon (not the wizard).
To change a user's password: Scroll to the bottom under Current Users, find the user, and click Change Password.
To delete a database or user: Click the Delete button next to the respective database or user name in the lists.

Managing Data directly? If you need to import or export .sql backup files, look for the "phpMyAdmin" tool in the Databases section of your cPanel home screen.

Need Assistance? If your script shows a "Database Connection Error" or if you face any issues while assigning privileges, please click "Open Ticket" from the top menu, and our technical support team will assist you immediately!