Managing MySQL Databases in cPanel

Managing MySQL Databases in cPanel

MySQL databases are essential for dynamic websites and applications like WordPress, Joomla, and custom web apps. cPanel provides tools to create, manage, and interact with your databases easily.

Creating a New Database

1. Log into cPanel.
2. Navigate to Databases > MySQL Databases.
3. Under Create New Database, enter a name for your database.
4. Click Create Database.

Creating a Database User

1. On the same MySQL Databases page, scroll to MySQL Users > Add New User.
2. Enter a username and password.
3. Click Create User.

Assigning a User to a Database

1. Scroll to Add User to Database.
2. Select the user and the database from the dropdown menus.
3. Click Add.
4. On the privileges page, select ALL PRIVILEGES (or choose specific permissions as needed).
5. Click Make Changes.

Using the MySQL Database Wizard

For a streamlined process, use MySQL Database Wizard (found in the Databases section):

1. Step 1: Create a database
2. Step 2: Create a user
3. Step 3: Assign the user to the database with appropriate privileges

Managing Databases with phpMyAdmin

phpMyAdmin provides a web-based interface for advanced database management:

1. In cPanel, go to Databases > phpMyAdmin.
2. Select your database from the left sidebar.
3. Common tasks:
   • Browse — View table contents
   • Structure — Modify table columns and indexes
   • SQL — Run custom SQL queries
   • Export — Download a database backup (.sql file)
   • Import — Restore a database from a backup file
   • Operations — Rename, copy, or optimize tables

Backing Up a Database

1. Open phpMyAdmin and select the database.
2. Click the Export tab.
3. Choose Quick export method and SQL format.
4. Click Go to download the backup file.

Restoring a Database

1. Open phpMyAdmin and select the target database (create an empty one if needed).
2. Click the Import tab.
3. Click Choose File and select your .sql backup.
4. Click Go to restore.

Important Notes

• Database and user names in cPanel are prefixed with your cPanel username (e.g., cpuser_dbname).
• Keep track of your database names, usernames, and passwords — they are required in your website’s configuration files.
• Back up your databases regularly to prevent data loss.
• Use Optimize Database in phpMyAdmin periodically to improve performance.

Remote MySQL Access

If you need to connect to your database from an external application:

1. In cPanel, go to Databases > Remote MySQL.
2. Add the IP address of the remote server that needs access.
3. Click Add Host.

For database-related assistance, contact 10Corp support.