How to Create and Manage Databases in cPanel Print

Databases are essential for many websites and applications, such as WordPress, Joomla, or custom-built sites. cPanel provides tools to easily create and manage MySQL databases and users. This guide will help you get started.

Creating a New Database

1. Log in to your cPanel account.
2. Scroll down to the Databases section and click on MySQL® Databases.
3. Under Create New Database, enter a name for your database.
4. Click the Create Database button.
5. You will see a confirmation message when the database is successfully created.

Creating a Database User

1. In the same MySQL® Databases page, scroll down to Add New User.
2. Enter a username for the database user.
3. Set a strong password or use the password generator.
4. Click Create User.

Assigning a User to a Database

1. Scroll down to Add User to Database.
2. Select the user you created from the dropdown menu.
3. Select the database you want to assign the user to.
4. Click Add.
5. On the next screen, select the privileges you want to grant the user (usually All Privileges).
6. Click Make Changes to save.

Managing Your Databases

• phpMyAdmin: Use phpMyAdmin (accessible from cPanel under the Databases section) to manage your databases, run SQL queries, import/export data, and more.
• Delete Databases: To remove a database, go back to the MySQL® Databases page, find the database under Current Databases, and click Delete.
• Change User Password: Update the password for your database users anytime from the MySQL® Databases page.

Best Practices

• Use strong, unique passwords for your database users to enhance security.
• Regularly back up your databases to avoid data loss.
• Only grant necessary privileges to database users based on their roles.

If you need help managing your databases or have any questions, please contact HostGrap support.