How to Create and Manage Databases in cPanel
1. Log in to Your cPanel Account
- Open your browser and go to your cPanel login page (often
yourdomain.com/cpanel). - Enter your username and password.
2. Navigate to the Databases Section
- Once inside cPanel, scroll down to the Databases section.
- Click on MySQL® Databases.
3. Create a New Database
- In the Create New Database field, type a name for your new database.
- Click Create Database.
- You’ll see a confirmation message. Click Go Back to return to the databases page.
4. Create a Database User
- Scroll down to the MySQL Users section.
- Under Add New User, enter a username and a strong password (or use the Password Generator).
- Click Create User.
5. Add the User to the Database
- In the Add User to Database section, select the user and the database you just created from the dropdown menus.
- Click Add.
- On the next screen, set the privileges for the user (usually, you’ll want to check All Privileges).
- Click Make Changes.
6. Manage Databases
- Back in the MySQL Databases section, you can:
- Check Database: Scan for and repair database errors.
- Rename Database: Change the name of the database if needed.
- Delete Database: Remove a database you no longer need (be careful—this is permanent!).
7. Access phpMyAdmin (Optional, for Advanced Management)
- Go back to the Databases section in cPanel.
- Click on phpMyAdmin to open the web-based database management tool.
- From here, you can import/export data, run SQL queries, and manage tables directly.
Tips:
- Always back up your database before making major changes.
- Use strong, unique passwords for all database users.
- Delete unused databases and users to keep your account secure.
