How to Create MySQL Databases and Users in cPanel (Avoiding phpMyAdmin)

Pre-requirements

• Access to your cPanel account.
• Valid database name and user credentials.

Why You Shouldn't Use phpMyAdmin for Database Creation

cPanel recommend that you avoid using phpMyAdmin to create databases or database users. phpMyAdmin doesn't map databases correctly, which can cause issues with backups and restorations. Instead, use the MySQL Database Wizard or PostgreSQL Database Wizard in cPanel for setting up databases, users, and privileges.

Steps to Create a MySQL Database and User Using the MySQL Database Wizard

1. Log in to your cPanel account.
2. In the Databases section, click on MySQL Database Wizard.
3. In the New Database text box, enter a name for your database, then click Next Step.
4. In the Username text box, enter a name for the user who will manage the database.
5. Enter and confirm the user’s password.
6. Click Create User.
7. Select the privileges you want to assign to the user, or select ALL PRIVILEGES.
8. Click Next Step. You will see a confirmation message that the database and user account have been successfully created.

Steps to Manually Create a MySQL Database Using MySQL Databases

1. Log in to your cPanel account.
2. In the Databases section, click on MySQL Databases.
3. Under Create New Database, enter the name of the database, then click Create Database.
4. After the database is created, click Go Back.
5. Under Add User to Database, select the user and the database, then click Add.
6. Assign user privileges by selecting specific permissions or ALL PRIVILEGES, then click Make Changes.

Note:

cPanel automatically adds the user to the database during the creation process using the MySQL Database Wizard, so you don't need to manually assign the user unless you're using the manual method.

Gotchas to Avoid

• Always use the MySQL Database Wizard or MySQL Databases interface in cPanel instead of phpMyAdmin for database creation and management.

Importing a MySQL Database Using phpMyAdmin

1. Log in to your cPanel account and scroll to the Databases section.
2. Click on the phpMyAdmin icon.
3. In phpMyAdmin, select the database you want to import data into.
4. Click on the Import tab.
5. Click the Choose File button and select the compressed SQL file from your local machine.
6. Ensure that SQL is selected as the format, then click Go.

Gotchas to Avoid

• If your SQL file exceeds 2MB, compress it using a tool like zip utility before importing.

Alternative: Use Our 1-Click App Installer

Our platform offers over 450 web applications and scripts that you can install using our 1-click app installer, which automatically handles database creation and application setup for you. This is a hassle-free way to install applications like WordPress, Joomla, and more.

To learn more about our 1-click installer, visit our documentation page: WebHostingM Softaculous Docs.

To avoid issues with backups and restorations, we recommend using the MySQL Database Wizard in cPanel rather than phpMyAdmin for database creation and user management. For application installs, consider using our 1-click installer to simplify the setup process. If you need help with your database management, reach out to our support team or follow the steps provided in this guide.

If you'd like to contribute to this tutorial or found an error, email us at team+editorial@webhostingm.com.