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:
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.
