> ## Content Index > Fetch the complete content index at: https://soft2hosting.com/llms.txt > Use this file to discover other available public pages before exploring further. # How to Create and Manage MySQL Databases in cPanel Shared Hosting Safely - URL: https://soft2hosting.com/blog/cpanel-mysql-database-management-phpmyadmin-shared-hosting/ - Published: 2026-10-16T12:12:00.000Z - Updated: 2026-10-16T12:17:01.000Z - Description: Step-by-step instructions for creating MySQL databases, assigning secure user privileges, and running database exports in phpMyAdmin on cPanel shared hosting. - Author: Aniket Joshi - Tags: Soft2Hosting, cPanel MySQL, phpMyAdmin Guide, Shared Hosting Database, WordPress Database, cPanel Management Managing MySQL databases is a fundamental skill for maintaining web applications on cPanel shared hosting. Content management systems like WordPress, Joomla, and OpenCart store all site content, including articles, user credentials, settings, and customer orders, within relational database tables. Understanding how to create databases, assign user privileges, and safely navigate phpMyAdmin ensures your website operates reliably and remains easy to restore if technical issues occur. ## The Critical cPanel Rule: Native Tools vs phpMyAdmin A vital principle highlighted in official cPanel documentation concerns where databases and database users must be created: **Do not create databases or database user accounts directly inside phpMyAdmin.** When a database is created directly through raw SQL commands inside phpMyAdmin, cPanel's internal mapping system cannot associate the database with your hosting account. As a result, cPanel's automated backup and restoration tools will fail to capture or restore that database during disaster recovery procedures. Always create databases and users using cPanel's native interfaces, specifically the **MySQL Database Wizard** or the **MySQL Databases** screen. Use phpMyAdmin strictly for data inspection, running queries, repairing corrupted tables, and performing manual SQL exports. ## Step-by-Step: Creating a Database and Assigning Privileges Follow these steps to establish a clean, secure database configuration: 1. **Create the Database:** Navigate to cPanel -> *Databases* \-> *MySQL Databases*. Under "Create New Database", enter a descriptive suffix (e.g., `wpblog`). cPanel automatically prepends your hosting account username (e.g., `username_wpblog`). Click "Create Database". 2. **Create a Dedicated Database User:** Under "MySQL Users -> Add New User", enter a username. Generate a strong, randomized password using cPanel's Password Generator. Save these credentials securely in your password manager, as they are required when linking your CMS configuration file. 3. **Assign User to Database:** Scroll to "Add User to Database". Select the newly created user and database from the dropdown menus and click "Add". 4. **Configure Privileges:** On the privilege management screen, assign appropriate permissions. For standard WordPress or CMS installations, click "All Privileges" (which grants `SELECT`, `INSERT`, `UPDATE`, `DELETE`, `CREATE`, `DROP`, `INDEX`, and `ALTER`). Click "Make Changes" to apply the security mapping. ## Connecting Your Application (Example: WordPress wp-config.php) Once created, connect your web application by updating its configuration file. In WordPress, open `wp-config.php` via the cPanel File Manager and verify the connection constants: ``` // ** Database settings from cPanel MySQL Databases ** // define( 'DB_NAME', 'username_wpblog' ); // The full database name with prefix define( 'DB_USER', 'username_dbuser' ); // The database username with prefix define( 'DB_PASSWORD', 'YourSecurePasswordHere' ); // The generated password define( 'DB_HOST', 'localhost' ); // 'localhost' on shared hosting define( 'DB_CHARSET', 'utf8mb4' ); define( 'DB_COLLATE', '' ); ``` On shared hosting platforms, `DB_HOST` is almost universally set to `localhost` because the MySQL daemon operates locally on the web server. ## Repairing Corrupted Tables and Checking Integrity Unexpected server restarts, runaway plugins, or interrupted write queries can occasionally result in corrupted database tables. Within cPanel, website owners have two primary methods to repair tables without requiring technical database administrator assistance: - **cPanel Check and Repair Utility:** Under the *MySQL Databases* screen, locate the "Modify Databases" section. Select your affected database from the dropdown list and click "Check Database". If any indexing errors or table anomalies are reported, select "Repair Database" to trigger automated table rebuilding routines. - **Native WordPress Repair Mode:** If you cannot access the cPanel interface, you can temporarily enable WordPress's built-in repair utility by appending `define( 'WP_ALLOW_REPAIR', true );` to `wp-config.php`. Navigate to `https://yourdomain.com/wp-admin/maint/repair.php` to initiate table optimization. Always remove this directive once maintenance is complete. ## Using phpMyAdmin for Maintenance and Manual Backups phpMyAdmin provides a powerful web interface for inspecting database tables, running maintenance tasks, and executing manual SQL dumps: - **Exporting a Manual Backup:** Click phpMyAdmin from the cPanel dashboard, select your database from the left-hand navigation tree, and click the *Export* tab. Choose the "Quick" export method with SQL format, and click "Export" to download an immediate raw SQL dump to your computer before running plugin or theme updates. - **Repairing and Optimizing Tables:** If your website displays database connection errors or sluggish queries, select your database in phpMyAdmin, check all tables, and choose "Repair table" or "Optimize table" from the dropdown menu at the bottom of the structure view. - **MySQL 8.0 Caching Note:** According to official documentation, MySQL 8.0 enables statistics caching by default. If you delete large quantities of rows or truncate tables, changes to table disk size in phpMyAdmin may take up to 24 hours to reflect unless the internal schema statistics expiry cache is refreshed. ## Database Limits and Soft2Hosting Plans Different hosting tiers provide varying database capacities: - **Starter Pro (Rs 2,499/year):** Includes support for up to 5 individual MySQL databases with 10 GB of high-speed NVMe storage, ideal for single-website brochure setups. - **Business Pro Hosting (Rs 4,999/year):** Includes unlimited MySQL databases with 50 GB NVMe storage, daily automated backups, and LiteSpeed web server caching. - **Enterprise Pro Hosting (Rs 7,999/year):** Includes unlimited MySQL databases with 100 GB NVMe storage, LiteSpeed + Redis object caching, and priority support. Learn more about database hosting features on [Soft2Hosting Web Hosting](https://soft2hosting.com/web-hosting/). --- ## Sources - [cPanel Documentation: MySQL Databases Management Interface](https://docs.cpanel.net/cpanel/databases/mysql-databases/?ref=soft2hosting.com) - [cPanel Documentation: phpMyAdmin Database Administration](https://docs.cpanel.net/cpanel/databases/phpmyadmin/?ref=soft2hosting.com) - [Soft2Hosting: Shared Web Hosting Features](https://soft2hosting.com/web-hosting/)