How to Manage Databases in cPanel (MySQL/MariaDB) ?

November 17, 2025

Managing databases is a crucial part of running websites and web applications. cPanel provides a user-friendly interface to create, manage, and secure MySQL or MariaDB databases. Follow this step-by-step guide from TZSMM Host.

Step 1: Log in to cPanel

Access your cPanel panel at:

https://yourdomain.com:2083

Enter your cPanel username and password.

Step 2: Open MySQL Databases

Scroll to the Databases section and click MySQL® Databases.

Step 3: Create a New Database

Under Create New Database, enter a name for your database and click Create Database.

Step 4: Create a Database User

Scroll to Add New User, enter a username and password, then click Create User. Make sure to use a strong password.

Step 5: Assign User to Database

Under Add User to Database, select the user and database you created, click Add, then assign privileges (usually All Privileges).

Step 6: Manage Databases via phpMyAdmin

Click phpMyAdmin to access your database interface. Here you can:

  • Create, edit, or delete tables.
  • Import or export databases.
  • Run SQL queries for advanced management.

Step 7: Delete or Modify Databases

Under Current Databases, you can delete databases or users, change passwords, or manage privileges as needed. Always back up before deleting.

Conclusion

cPanel makes database management simple and secure. By following these steps, you can efficiently create, manage, and maintain MySQL/MariaDB databases for your websites. TZSMM Host provides full guidance and support to ensure your databases run smoothly.

Was this answer helpful?

27 Users Found This Useful (101 Votes)

Comments