{"id":4181,"date":"2025-12-31T13:44:25","date_gmt":"2025-12-31T18:44:25","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2017\/10\/06\/manage-mysql-database-in-phpmyadmin\/"},"modified":"2026-08-03T19:56:01","modified_gmt":"2026-08-03T23:56:01","slug":"manage-databases-cpanel-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/","title":{"rendered":"How To Manage Databases in cPanel with phpMyAdmin"},"content":{"rendered":"<p class=\"wp-block-paragraph\">phpMyAdmin is where you work with the data inside your MySQL databases, whichever PHP application sits on top of them. This guide covers the interface, what each tab does, and how to handle the tasks that bring most people here: backups before an update, imports after a migration, oversized tables, and corrupted records.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Before You Start<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Database changes are permanent. There\u2019s no undo button, no revision history, and no confirmation prompt for most destructive actions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Before making any changes in phpMyAdmin:<\/p>\n\n\n\n<ol class=\"wp-block-list article_list\">\n<li>Export a copy of the database using the Export tab.<\/li>\n\n\n\n<li>Create a full account backup through cPanel\u2019s Backup Wizard if the application stores files that reference database records, such as media libraries or product images.<\/li>\n\n\n\n<li>Test the change on a staging copy when one is available.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">A single mistyped SQL query can delete months of content or break every page on your site. Five minutes on a backup saves hours of recovery work, and that pattern holds regardless of platform.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">How To Confirm Which Database Your Site Uses<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Accounts with several installs often show a dozen similarly named databases, and the naming convention on cPanel servers (<code>cpuser_something<\/code>) does not tell you which site owns which. Open the application\u2019s configuration file over FTP or File Manager and read the value directly.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><th>Application<\/th><th>Configuration file<\/th><th>Where the database name appears<\/th><\/tr><\/thead><tbody><tr><td>WordPress<\/td><td><code>wp-config.php<\/code><\/td><td><code>DB_NAME<\/code><\/td><\/tr><tr><td>Drupal 9, 10, and 11<\/td><td><code>sites\/default\/settings.php<\/code><\/td><td><code>$databases['default']['default']['database']<\/code><\/td><\/tr><tr><td>Joomla 4 and 5<\/td><td><code>configuration.php<\/code><\/td><td><code>public $db<\/code><\/td><\/tr><tr><td>Magento 2 and Adobe Commerce<\/td><td><code>app\/etc\/env.php<\/code><\/td><td><code>db<\/code> &gt; <code>connection<\/code> &gt; <code>default<\/code> &gt; <code>dbname<\/code><\/td><\/tr><tr><td>Laravel<\/td><td><code>.env<\/code><\/td><td><code>DB_DATABASE<\/code><\/td><\/tr><tr><td>PrestaShop 8<\/td><td><code>app\/config\/parameters.php<\/code><\/td><td><code>database_name<\/code><\/td><\/tr><tr><td>OpenCart 4<\/td><td><code>config.php<\/code><\/td><td><code>DB_DATABASE<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The same files list the table prefix. Magento defaults to no prefix, Drupal usually has none, and WordPress ships with <code>wp_<\/code> but installers frequently randomize it. Check before you write a query against a table name you assumed.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">What Does phpMyAdmin Do That cPanel\u2019s Database Tools Do Not?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">cPanel\u2019s <strong>MySQL Databases<\/strong> tool handles the container and the keys. It creates databases, creates users, assigns privileges, and repairs tables. It never shows you a single row of data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">phpMyAdmin handles the contents. Browsing tables, running queries, exporting backups, importing dumps, and editing individual records all happen there. Both tools are available on Shared, VPS, and Dedicated accounts running cPanel, and phpMyAdmin ships with Control Web Panel as well.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The practical split looks like this:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Creating a database and user for a new install: cPanel\u2019s MySQL Databases.<\/li>\n\n\n\n<li>Backing up before you update a plugin, module, or extension: phpMyAdmin\u2019s Export tab.<\/li>\n\n\n\n<li>Restoring a site on a new server: phpMyAdmin\u2019s Import tab.<\/li>\n\n\n\n<li>Tracking down which table is consuming 4GB of disk: phpMyAdmin\u2019s Structure tab.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">How to Access phpMyAdmin in cPanel<\/h2>\n\n\n\n<ol class=\"wp-block-list article_list\">\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/how-to-log-into-cpanel\/\">Log into your cPanel<\/a> account.<\/li>\n\n\n\n<li>Scroll to the <strong>Databases<\/strong> section.<\/li>\n\n\n\n<li>Click the <strong>phpMyAdmin<\/strong> icon.<br><br><img decoding=\"async\" width=\"1024\" height=\"279\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2025\/12\/cpanel-tools-databases-1024x279.png\" class=\"optimized-lcp-image\" alt=\"\" loading=\"eager\" fetchpriority=\"high\" sizes=\"(max-width: 768px) 100vw, 768px\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2025\/12\/cpanel-tools-databases-1024x279.png 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2025\/12\/cpanel-tools-databases-300x82.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2025\/12\/cpanel-tools-databases-768x209.png 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2025\/12\/cpanel-tools-databases-1536x418.png 1536w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2025\/12\/cpanel-tools-databases.png 1998w\"><\/li>\n\n\n\n<li>phpMyAdmin opens in a new browser tab. You\u2019re automatically logged in with your cPanel credentials, so you\u2019ll only see databases that belong to your account.<br><br><img decoding=\"async\" class=\"\" style=\"max-width:700px;\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2025\/12\/cpanel-tools-phpmyadmin-scaled.png\" alt=\"cPanel Tools - phpMyAdmin\"><\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Understanding the phpMyAdmin Interface<\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/10\/phpmyadmin_basics_phpmyadmin-view.png\" alt=\"The phpMyAdmin interface showing the navigation panel on the left and the main panel on the right\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The <strong>navigation panel<\/strong> on the left lists every database your account can reach. Click a database to expand its tables, then click a table to view its rows.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The <strong>main panel<\/strong> on the right shows details for whatever you selected, with action tabs across the top. Before you select anything, it displays server information: MySQL or MariaDB version, default character set, and the <a href=\"https:\/\/docs.phpmyadmin.net\/en\/latest\/\">phpMyAdmin version<\/a> you are running. Support teams ask for those values often, so it is worth knowing where they live.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/10\/phpmyadmin_basics_database-in-phpmyadmin.png\" alt=\"Table listing inside a selected database, showing row counts and sizes\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Selecting a database loads a table list with row counts, on-disk size, and storage engine for each table. Nearly everything you see will use InnoDB, which has been the MySQL default since version 5.5. Tables still running MyISAM are usually leftovers from an old migration and behave differently during repairs.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Click a table name to view its contents. phpMyAdmin shows the first 25 rows and pages through the rest with the controls at the bottom.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The Database Menu Tabs<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When you select a database, a row of tabs appears across the top of the main panel. Each tab serves a specific purpose.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Structure<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Shows all tables in your database along with their row counts, sizes, and storage engines. You can:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create new tables<\/li>\n\n\n\n<li>View or modify individual table structures<\/li>\n\n\n\n<li>Drop (delete) tables<\/li>\n\n\n\n<li>Check, analyze, or repair tables in bulk<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Select multiple tables using the checkboxes, then use the \u201cWith selected\u201d dropdown to perform batch operations.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQL<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Opens a text area where you can type and execute raw SQL queries. The syntax highlighting helps catch errors before you run them.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Common uses:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Search-and-replace operations across multiple tables<\/li>\n\n\n\n<li>Bulk updates that would take too long through the interface<\/li>\n\n\n\n<li>Running queries provided by plugin support teams<\/li>\n\n\n\n<li>Deleting spam comments or revisions in bulk<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">phpMyAdmin displays the results below the query box. For <code>SELECT<\/code> queries, you\u2019ll see a table of matching rows. For <code>UPDATE<\/code> or <code>DELETE<\/code> queries, you\u2019ll see how many rows were affected.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Search<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Finds values across one or several tables without writing SQL. Enter a term, choose the tables and columns to check, and phpMyAdmin returns every match. Useful when you need to find where a stray configuration value or a hardcoded URL is stored.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Query<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A visual query builder. Pick tables, choose columns, set conditions from dropdowns, and phpMyAdmin writes the SQL. Building a query here and then reading the generated code is a reasonable way to learn <code>JOIN<\/code> syntax.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Export<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Creates a downloadable backup file of your database. You\u2019ll use this before making major changes, when migrating to a new host, or as part of a regular backup routine.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Quick export<\/strong>\u00a0downloads the entire database in SQL format with default settings. This works for most backup and migration scenarios.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Custom export<\/strong>\u00a0lets you choose specific tables, change the output format (SQL, CSV, JSON, XML), and adjust options like adding <code>DROP TABLE<\/code> statements or compressing the output.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Import<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Uploads a database file to restore from a backup or complete a migration. Supported formats include SQL, CSV, and compressed archives (.gz, .zip).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The Import tab shows your server\u2019s maximum upload size. If your database file exceeds this limit, you\u2019ll need to use an alternative method. More on this in the\u00a0<a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/#import-file-size-limits\">Import File Size Limits<\/a>\u00a0section.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Operations<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Contains maintenance and administrative tasks:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Rename database<\/strong>: Change the database name (creates a copy with the new name, then drops the original)<\/li>\n\n\n\n<li><strong>Copy database<\/strong>: Duplicate the entire database<\/li>\n\n\n\n<li><strong>Collation<\/strong>: Change the character encoding<\/li>\n\n\n\n<li><strong>Table maintenance<\/strong>: Optimize, repair, check, or analyze tables<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The Operations tab is also where you\u2019ll find options to truncate (empty) the database or drop (delete) it entirely.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Common phpMyAdmin Tasks<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Exporting Before an Update<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Core updates, extension updates, and theme changes all write to the database, and a failed migration script is the most common way a working site breaks during routine maintenance.<\/p>\n\n\n\n<ol class=\"wp-block-list article_list\">\n<li>Select the database in the left panel.<\/li>\n\n\n\n<li>Click the <strong>Export<\/strong> tab.<\/li>\n\n\n\n<li>Leave the format as SQL and click <strong>Export<\/strong>.<\/li>\n\n\n\n<li>Save the <code>.sql<\/code> file somewhere outside the account, not in <code>public_html<\/code>.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">That last point matters. A backup sitting in a web-accessible directory is a backup anyone can download.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Importing After a Migration<\/h3>\n\n\n\n<ol class=\"wp-block-list article_list\">\n<li>Create an empty database and a database user in cPanel\u2019s MySQL Databases tool, then grant that user <strong>All Privileges<\/strong>.<\/li>\n\n\n\n<li>Open phpMyAdmin and select the new, empty database.<\/li>\n\n\n\n<li>Click the <strong>Import<\/strong> tab.<\/li>\n\n\n\n<li>Choose your <code>.sql<\/code> file and click <strong>Import<\/strong>.<\/li>\n\n\n\n<li>Update the application\u2019s configuration file with the new database name, username, and password.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Large imports run for several minutes. Leaving the browser tab open until it finishes avoids a half-loaded database.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Finding Large Tables<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Rather than guessing, ask the server. Run this on the SQL tab and substitute your own database name:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono-NL.ttf\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono-NL,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:clamp(26px, 1.625rem, 39px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">SELECT<\/span><span style=\"color: #E1E4E8\"> table_name <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">\"Table\"<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">       <\/span><span style=\"color: #79B8FF\">ROUND<\/span><span style=\"color: #E1E4E8\">((data_length <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> index_length) <\/span><span style=\"color: #F97583\">\/<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">1024<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">\/<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">1024<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">2<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">\"Size (MB)\"<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">FROM<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">information_schema<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">TABLES<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">WHERE<\/span><span style=\"color: #E1E4E8\"> table_schema <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">'your_database_name'<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">ORDER BY<\/span><span style=\"color: #E1E4E8\"> (data_length <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> index_length) <\/span><span style=\"color: #F97583\">DESC<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">The usual offenders vary by platform, though the underlying cause is nearly always logging, caching, or queued jobs that nobody prunes.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><th>Application<\/th><th>Tables that grow fastest<\/th><th>What fills them<\/th><\/tr><\/thead><tbody><tr><td>WordPress and WooCommerce<\/td><td><code>wp_posts<\/code>, <code>wp_postmeta<\/code>, <code>wp_options<\/code>, <code>wp_actionscheduler_actions<\/code><\/td><td>Post revisions, plugin metadata, autoloaded transients, scheduled jobs<\/td><\/tr><tr><td>Magento 2<\/td><td><code>report_event<\/code>, <code>quote<\/code>, <code>sales_order_grid<\/code>, index tables<\/td><td>Visitor tracking, abandoned carts, reindexing<\/td><\/tr><tr><td>Drupal<\/td><td><code>watchdog<\/code>, <code>sessions<\/code>, <code>cache_*<\/code><\/td><td>Log entries, session records, cached render output<\/td><\/tr><tr><td>Joomla<\/td><td><code>#__session<\/code>, <code>#__action_logs<\/code><\/td><td>Session rows, administrator activity logs<\/td><\/tr><tr><td>Laravel<\/td><td><code>sessions<\/code>, <code>jobs<\/code>, <code>failed_jobs<\/code>, <code>cache<\/code><\/td><td>Database session and queue drivers<\/td><\/tr><tr><td>PrestaShop<\/td><td><code>ps_connections<\/code>, <code>ps_guest<\/code>, <code>ps_connections_source<\/code><\/td><td>Built-in visitor statistics<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">A database that has doubled in size without a matching increase in content is almost always one of these tables, not your actual data.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Optimizing Tables<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><code>OPTIMIZE TABLE<\/code> reclaims space and rebuilds indexes after heavy delete activity. It genuinely helps after you purge a few hundred thousand log rows. It does very little on a database that has only ever grown.<\/p>\n\n\n\n<ol class=\"wp-block-list article_list\">\n<li>Select your database.<\/li>\n\n\n\n<li>Click the\u00a0<strong>Structure<\/strong>\u00a0tab.<\/li>\n\n\n\n<li>Check the boxes next to the tables you want to optimize (or click \u201cCheck all\u201d).<\/li>\n\n\n\n<li>From the \u201cWith selected\u201d dropdown, choose\u00a0<strong>Optimize table<\/strong>.<\/li>\n\n\n\n<li>Click\u00a0<strong>Go<\/strong>.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">InnoDB tables report that they do not support optimize, then get rebuilt anyway. That message is <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/optimize-table.html\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">expected behavior, not an error<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Repairing Tables<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If you\u2019re seeing errors about corrupted tables, try the repair function.<\/p>\n\n\n\n<ol class=\"wp-block-list article_list\">\n<li>Select your database.<\/li>\n\n\n\n<li>Click the\u00a0<strong>Structure<\/strong>\u00a0tab.<\/li>\n\n\n\n<li>Check the boxes next to the affected tables.<\/li>\n\n\n\n<li>From the \u201cWith selected\u201d dropdown, choose\u00a0<strong>Repair table<\/strong>.<\/li>\n\n\n\n<li>Click\u00a0<strong>Go<\/strong>.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">phpMyAdmin attempts to fix any corruption. This works well for minor issues, particularly with MyISAM tables. Severe corruption may require restoring from a backup.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can also use cPanel\u2019s built-in repair function: go to\u00a0<strong>MySQL Databases<\/strong>, scroll to\u00a0<strong>Modify Databases<\/strong>, select your database from the Repair dropdown, and click\u00a0<strong>Repair Database<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Running SQL Queries<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The SQL tab accepts any valid MySQL query. That being said, cleanup queries against log and revision tables are low risk once you have a backup. Anything touching orders, customers, or payments is not.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Remove WordPress post revisions:<\/strong><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono-NL.ttf\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono-NL,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:clamp(26px, 1.625rem, 39px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">DELETE<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">FROM<\/span><span style=\"color: #E1E4E8\"> wp_posts <\/span><span style=\"color: #F97583\">WHERE<\/span><span style=\"color: #E1E4E8\"> post_type <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">'revision'<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Clear Drupal\u2019s log table:<\/strong><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono-NL.ttf\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono-NL,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:clamp(26px, 1.625rem, 39px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">TRUNCATE<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TABLE<\/span><span style=\"color: #E1E4E8\"> watchdog;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Delete Laravel failed jobs older than 30 days:<\/strong><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono-NL.ttf\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono-NL,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:clamp(26px, 1.625rem, 39px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">DELETE<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">FROM<\/span><span style=\"color: #E1E4E8\"> failed_jobs <\/span><span style=\"color: #F97583\">WHERE<\/span><span style=\"color: #E1E4E8\"> failed_at <\/span><span style=\"color: #F97583\">&lt;<\/span><span style=\"color: #E1E4E8\"> DATE_SUB(<\/span><span style=\"color: #F97583\">NOW<\/span><span style=\"color: #E1E4E8\">(), INTERVAL <\/span><span style=\"color: #79B8FF\">30<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">DAY<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Two cautions. <code>TRUNCATE<\/code> fails on any table referenced by a foreign key constraint, which rules it out for most Magento and PrestaShop tables. And truncating a session table logs out every active user, including customers with items in a cart.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Resetting an Admin Password Directly in the Database<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Only on WordPress, and only because it accepts an MD5 fallback. Edit the row in <code>wp_users<\/code>, select <strong>MD5<\/strong> from the function dropdown on the <code>user_pass<\/code> field, enter the plaintext password, and save. WordPress rehashes it on the next successful login. <a href=\"\/support\/edu\/wordpress\/reset-wordpress-password\/\">Full steps are here<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Every other major PHP application rejects this approach:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Drupal 8 and newer<\/strong> stores a salted hash in <code>users_field_data<\/code>. Use <a href=\"https:\/\/www.drush.org\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Drush<\/a>: <code>drush user:password admin 'NewPassword'<\/code>.<\/li>\n\n\n\n<li><strong>Magento 2<\/strong> stores <code>hash:salt:version<\/code> in <code>admin_user<\/code> using the encryption key from <code>app\/etc\/env.php<\/code>. Adobe\u2019s guidance is to <a href=\"https:\/\/experienceleague.adobe.com\/en\/docs\/commerce-knowledge-base\/kb\/how-to\/change-magento-admin-password-on-cloud\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">create a new admin account from the CLI<\/a> with <code>bin\/magento admin:user:create<\/code>.<\/li>\n\n\n\n<li><strong>Laravel<\/strong> applications hash with bcrypt or Argon2. Generate a hash through <code>php artisan tinker<\/code> before writing anything.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Pasting a plaintext password into these tables locks the account rather than opening it.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Why Do Find and Replace Queries Break Serialized Data?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A common migration query looks harmless:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono-NL.ttf\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono-NL,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:clamp(26px, 1.625rem, 39px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">UPDATE<\/span><span style=\"color: #E1E4E8\"> wp_posts <\/span><span style=\"color: #F97583\">SET<\/span><span style=\"color: #E1E4E8\"> post_content <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">REPLACE<\/span><span style=\"color: #E1E4E8\">(post_content, <\/span><span style=\"color: #9ECBFF\">'http:\/\/oldsite.com'<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">'https:\/\/newsite.com'<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">On plain text columns it works. On columns holding <a href=\"https:\/\/www.php.net\/manual\/en\/function.serialize.php\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">PHP serialized arrays<\/a> it corrupts them, because serialized strings carry a byte-length prefix. Change <code>oldsite.com<\/code> to <code>mynewlongerdomain.com<\/code> and the stored length no longer matches, so the application silently discards the value. Widget settings vanish, theme options reset, and shipping configurations empty out.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Serialized data appears in <code>wp_options<\/code> and <code>wp_postmeta<\/code>, in Drupal configuration blobs, and in Magento and PrestaShop configuration tables.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Use a tool that unserializes, replaces, and reserializes:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/developer.wordpress.org\/cli\/commands\/search-replace\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">WP-CLI <code>search-replace<\/code><\/a> or the <a href=\"https:\/\/wordpress.org\/plugins\/better-search-replace\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Better Search Replace plugin<\/a> for WordPress.<\/li>\n\n\n\n<li><code>bin\/magento setup:store-config:set --base-url<\/code> plus a <code>core_config_data<\/code> update for Magento.<\/li>\n\n\n\n<li>Drush <code>config:set<\/code> for Drupal configuration values.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">How To Handle Size Limits on Import File<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">phpMyAdmin uploads are capped by <a href=\"https:\/\/www.php.net\/manual\/en\/ini.core.php\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">PHP\u2019s <code>upload_max_filesize<\/code> and <code>post_max_size<\/code> directives<\/a>. Shared accounts typically land between 50MB and 256MB. The Import tab prints your actual limit under the file selector.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Options when the dump exceeds it:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Compress it.<\/strong> phpMyAdmin accepts <code>.sql.gz<\/code> and <code>.sql.zip<\/code>, and SQL dumps compress by roughly 80 to 90%.<\/li>\n\n\n\n<li><strong>Use cPanel\u2019s Backup Restore.<\/strong> It handles files phpMyAdmin\u2019s uploader cannot.<\/li>\n\n\n\n<li><strong>Import over SSH.<\/strong> Faster and immune to browser timeouts: <code>mysql -u username -p database_name &lt; backup.sql<\/code>. See <a href=\"\/support\/website\/ssh\/import-database-ssh\/\">Importing a Database via SSH<\/a>.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Databases above 1GB belong on the command line. If you are hitting that ceiling regularly, the workload has usually outgrown Shared hosting, and <a href=\"https:\/\/www.inmotionhosting.com\/vps-hosting\">VPS Hosting<\/a> with root access and higher PHP limits removes the constraint entirely.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How To Give a Developer Access Without Sharing cPanel<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Handing over cPanel credentials gives a contractor your email, DNS, files, and billing-adjacent settings. Scope the access to the database instead.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Create a dedicated database user in cPanel\u2019s MySQL Databases tool.<\/li>\n\n\n\n<li>Grant only the privileges the work requires. Reporting and analysis often need <code>SELECT<\/code> alone.<\/li>\n\n\n\n<li>Install a separate phpMyAdmin instance in a subdirectory and configure it with those credentials. <a href=\"\/support\/website\/phpmyadmin-install\/\">Instructions are here<\/a>.<\/li>\n\n\n\n<li>Alternatively, enable Remote MySQL for their IP address so they can connect with a desktop client.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Revoke the user when the engagement ends. Database users are easy to create and easier to forget.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Troubleshooting Common phpMyAdmin Errors<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>#1044 or #1045 Access denied.<\/strong> The database user lacks privileges on that database, or you are importing into a database the user was never assigned to. Re-check the assignment in cPanel\u2019s MySQL Databases.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Table doesn\u2019t exist.<\/strong> Nearly always a prefix mismatch. Confirm the prefix in the application\u2019s configuration file before assuming the table is gone.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Script timeout or maximum execution time exceeded.<\/strong> The query or import outran PHP\u2019s limit. Split the file, compress it, or move to SSH.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>MySQL server has gone away.<\/strong> Usually a single row larger than <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/packet-too-large.html\" target=\"_blank\" rel=\"noreferrer noopener nofollow\"><code>max_allowed_packet<\/code><\/a>, which happens with tables storing base64 images or large cached blobs. Importing over SSH avoids it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Garbled accented characters after import.<\/strong> A collation mismatch, typically a <code>utf8mb4<\/code> dump landing in a <code>latin1<\/code> database. Set the target database collation to match the dump before importing, not after.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Changes do not appear on the site.<\/strong> Application caching is holding the old values. Clear the platform cache first (<code>wp cache flush<\/code>, <code>bin\/magento cache:flush<\/code>, <code>drush cr<\/code>, <code>php artisan cache:clear<\/code>), then object caching such as Redis or Memcached, then any CDN.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Next Steps<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Database work rewards routine over heroics. Export before every update, check table sizes quarterly, prune log and session tables before they reach a few million rows, and act on corruption warnings the day they appear.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Related guides:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"\/support\/website\/phpmyadmin-export-database\/\">Export a database backup<\/a><\/li>\n\n\n\n<li><a href=\"\/support\/website\/phpmyadmin-import-database\/\">Import a database from another server<\/a><\/li>\n\n\n\n<li><a href=\"\/support\/website\/manage-mysql-databases-cpanel\/\">Create databases and users in cPanel<\/a><\/li>\n\n\n\n<li><a href=\"\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/\">Set up remote database access<\/a><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">If a database problem is affecting a live site, <a href=\"https:\/\/www.inmotionhosting.com\/contact\">contact our 24\/7 support team<\/a>. A real person answers, and database recovery is not something worth attempting twice.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>phpMyAdmin is where you work with the data inside your MySQL databases, whichever PHP application sits on top of them. This guide covers the interface, what each tab does, and how to handle the tasks that bring most people here: backups before an update, imports after a migration, oversized tables, and corrupted records. Before You<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/\"> Read More ><\/a><\/p>\n","protected":false},"author":56983,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_ayudawp_aiss_exclude":false,"_ayudawp_aiss_exclude_summary":false,"_ayudawp_aiss_summary":"What Does phpMyAdmin Do That cPanel's Database Tools Do Not?. cPanel's MySQL Databases tool handles the container and the keys. Create an empty database and a database user in cPanel's MySQL Databases tool, then grant that user All Privileges. You can also use cPanel\u2019s built-in repair function: go to&nbsp;MySQL Databases, scroll to&nbsp;Modify Databases, select your database from the Repair dropdown, and click&nbsp;Repair Database.","_ayudawp_aiss_summary_provider":"extractive","_ayudawp_aiss_summary_hash":"13c462aa0629bba22663cb265be95e444f34d78e","_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[4305],"tags":[],"class_list":["post-4181","post","type-post","status-publish","format-standard","hentry","category-databases"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How To Manage Databases in cPanel with phpMyAdmin<\/title>\n<meta name=\"description\" content=\"Use phpMyAdmin in cPanel to back up, import, optimize, and repair MySQL databases for WordPress, Magento, Drupal, Laravel, and custom PHP apps.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Manage Databases in cPanel with phpMyAdmin\" \/>\n<meta property=\"og:description\" content=\"Use phpMyAdmin in cPanel to back up, import, optimize, and repair MySQL databases for WordPress, Magento, Drupal, Laravel, and custom PHP apps.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-12-31T18:44:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-08-03T23:56:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2025\/12\/cpanel-tools-databases.png\" \/>\n<meta name=\"author\" content=\"Carrie Smaha\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@carriesmaha\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Carrie Smaha\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/server\\\/databases\\\/manage-databases-cpanel-phpmyadmin\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/server\\\/databases\\\/manage-databases-cpanel-phpmyadmin\\\/\"},\"author\":{\"name\":\"Carrie Smaha\",\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/#\\\/schema\\\/person\\\/595948dab2995d347a87076abdae19d8\"},\"headline\":\"How To Manage Databases in cPanel with phpMyAdmin\",\"datePublished\":\"2025-12-31T18:44:25+00:00\",\"dateModified\":\"2026-08-03T23:56:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/server\\\/databases\\\/manage-databases-cpanel-phpmyadmin\\\/\"},\"wordCount\":2315,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/server\\\/databases\\\/manage-databases-cpanel-phpmyadmin\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/cpanel-tools-databases.png\",\"articleSection\":[\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/server\\\/databases\\\/manage-databases-cpanel-phpmyadmin\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/server\\\/databases\\\/manage-databases-cpanel-phpmyadmin\\\/\",\"url\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/server\\\/databases\\\/manage-databases-cpanel-phpmyadmin\\\/\",\"name\":\"How To Manage Databases in cPanel with phpMyAdmin\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/server\\\/databases\\\/manage-databases-cpanel-phpmyadmin\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/server\\\/databases\\\/manage-databases-cpanel-phpmyadmin\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/cpanel-tools-databases.png\",\"datePublished\":\"2025-12-31T18:44:25+00:00\",\"dateModified\":\"2026-08-03T23:56:01+00:00\",\"description\":\"Use phpMyAdmin in cPanel to back up, import, optimize, and repair MySQL databases for WordPress, Magento, Drupal, Laravel, and custom PHP apps.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/server\\\/databases\\\/manage-databases-cpanel-phpmyadmin\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/server\\\/databases\\\/manage-databases-cpanel-phpmyadmin\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/server\\\/databases\\\/manage-databases-cpanel-phpmyadmin\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/cpanel-tools-databases.png\",\"contentUrl\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/cpanel-tools-databases.png\",\"width\":1998,\"height\":544},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/server\\\/databases\\\/manage-databases-cpanel-phpmyadmin\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Manage Databases in cPanel with phpMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/#website\",\"url\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support &amp; Tutorials\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/inmotionhosting\\\/\",\"https:\\\/\\\/x.com\\\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/#\\\/schema\\\/person\\\/595948dab2995d347a87076abdae19d8\",\"name\":\"Carrie Smaha\",\"description\":\"Carrie Smaha is a digital strategy, web development, and SEO leader with 20 years of experience. She built her foundation in fast-paced agency environments before moving in-house to InMotion Hosting, where she leads go-to-market programs, agency initiatives, and technical product marketing that connects product capability to real customer decisions.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/carriesmaha\\\/\",\"https:\\\/\\\/x.com\\\/carriesmaha\"],\"url\":\"https:\\\/\\\/www.inmotionhosting.com\\\/support\\\/author\\\/carries\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Manage Databases in cPanel with phpMyAdmin","description":"Use phpMyAdmin in cPanel to back up, import, optimize, and repair MySQL databases for WordPress, Magento, Drupal, Laravel, and custom PHP apps.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/","og_locale":"en_US","og_type":"article","og_title":"How To Manage Databases in cPanel with phpMyAdmin","og_description":"Use phpMyAdmin in cPanel to back up, import, optimize, and repair MySQL databases for WordPress, Magento, Drupal, Laravel, and custom PHP apps.","og_url":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2025-12-31T18:44:25+00:00","article_modified_time":"2026-08-03T23:56:01+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2025\/12\/cpanel-tools-databases.png","type":"","width":"","height":""}],"author":"Carrie Smaha","twitter_card":"summary_large_image","twitter_creator":"@carriesmaha","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"Carrie Smaha","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/"},"author":{"name":"Carrie Smaha","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/595948dab2995d347a87076abdae19d8"},"headline":"How To Manage Databases in cPanel with phpMyAdmin","datePublished":"2025-12-31T18:44:25+00:00","dateModified":"2026-08-03T23:56:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/"},"wordCount":2315,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2025\/12\/cpanel-tools-databases.png","articleSection":["Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/","url":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/","name":"How To Manage Databases in cPanel with phpMyAdmin","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2025\/12\/cpanel-tools-databases.png","datePublished":"2025-12-31T18:44:25+00:00","dateModified":"2026-08-03T23:56:01+00:00","description":"Use phpMyAdmin in cPanel to back up, import, optimize, and repair MySQL databases for WordPress, Magento, Drupal, Laravel, and custom PHP apps.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2025\/12\/cpanel-tools-databases.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2025\/12\/cpanel-tools-databases.png","width":1998,"height":544},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How To Manage Databases in cPanel with phpMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support &amp; Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/595948dab2995d347a87076abdae19d8","name":"Carrie Smaha","description":"Carrie Smaha is a digital strategy, web development, and SEO leader with 20 years of experience. She built her foundation in fast-paced agency environments before moving in-house to InMotion Hosting, where she leads go-to-market programs, agency initiatives, and technical product marketing that connects product capability to real customer decisions.","sameAs":["https:\/\/www.linkedin.com\/in\/carriesmaha\/","https:\/\/x.com\/carriesmaha"],"url":"https:\/\/www.inmotionhosting.com\/support\/author\/carries\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":{"id":4305,"name":"Working with Databases","slug":"databases","link":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/"},"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/4181","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/56983"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=4181"}],"version-history":[{"count":9,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/4181\/revisions"}],"predecessor-version":[{"id":900256,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/4181\/revisions\/900256"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=4181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=4181"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=4181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}