{"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":"2025-12-31T13:45:49","modified_gmt":"2025-12-31T18:45:49","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>phpMyAdmin is a web-based tool for managing MySQL and MariaDB databases. While cPanel\u2019s MySQL Databases tool handles creating databases and users, phpMyAdmin is where you work with the data itself: browsing tables, running queries, importing backups, and fixing corrupted records.<\/p>\n\n\n\n<p>This guide covers the phpMyAdmin interface, explains what each menu tab does, and walks through common tasks like backing up your database before a WordPress update or fixing broken URLs after migrating to a new domain.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Before You Start<\/h2>\n\n\n\n<p>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>Before making any changes in phpMyAdmin:<\/p>\n\n\n\n<ol class=\"wp-block-list article_list\">\n<li>Export a backup of your database using the Export tab.<\/li>\n\n\n\n<li>If you\u2019re editing a WordPress or CMS database, also create a full site backup through cPanel\u2019s Backup Wizard.<\/li>\n\n\n\n<li>Test changes on a staging site when possible.<\/li>\n<\/ol>\n\n\n\n<p>A single mistyped SQL query can delete months of content or break every page on your site. The five minutes spent creating a backup can save hours of recovery work.<\/p>\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=\"\" 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 size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1199\" height=\"646\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/10\/phpmyadmin_basics_phpmyadmin-view.png\" alt=\"The phpMyAdmin Interface\" class=\"wp-image-14894\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/10\/phpmyadmin_basics_phpmyadmin-view.png 1199w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/10\/phpmyadmin_basics_phpmyadmin-view-300x162.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/10\/phpmyadmin_basics_phpmyadmin-view-768x414.png 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/10\/phpmyadmin_basics_phpmyadmin-view-1024x552.png 1024w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure>\n\n\n\n<p>The interface has two main areas:<\/p>\n\n\n\n<p><strong>Navigation panel (left side)<\/strong>: Lists all your databases. Click a database name to expand it and see its tables. Click a table name to view its contents.<\/p>\n\n\n\n<p><strong>Main panel (right side)<\/strong>: Displays information about whatever you\u2019ve selected, along with action tabs across the top.<\/p>\n\n\n\n<p>When you first open phpMyAdmin without selecting a database, the main panel shows server information: the MySQL version, character set, and phpMyAdmin version. This information can be useful when troubleshooting compatibility issues or contacting support.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Selecting and Viewing a Database<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1182\" height=\"654\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/10\/phpmyadmin_basics_database-in-phpmyadmin.png\" alt=\"Detailed look at tables within a database\" class=\"wp-image-14895\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/10\/phpmyadmin_basics_database-in-phpmyadmin.png 1182w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/10\/phpmyadmin_basics_database-in-phpmyadmin-300x166.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/10\/phpmyadmin_basics_database-in-phpmyadmin-768x425.png 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2017\/10\/phpmyadmin_basics_database-in-phpmyadmin-1024x567.png 1024w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure>\n\n\n\n<p>Click any database name in the left panel to select it. The main panel updates to show:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A list of all tables in that database<\/li>\n\n\n\n<li>Row counts for each table<\/li>\n\n\n\n<li>The size of each table on disk<\/li>\n\n\n\n<li>The storage engine (usually InnoDB)<\/li>\n<\/ul>\n\n\n\n<p>This overview helps identify which tables are consuming the most space. In WordPress sites, the <code>wp_posts<\/code> and <code>wp_postmeta<\/code> tables typically grow the largest, followed by any tables created by plugins.<\/p>\n\n\n\n<p>Click any table name to view its contents. phpMyAdmin displays the first 25 rows by default. You can change this limit or navigate through pages of results using 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>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>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>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>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>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>phpMyAdmin displays the results below the query box. For SELECT queries, you\u2019ll see a table of matching rows. For UPDATE or DELETE 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>Lets you find specific values across one or multiple tables without writing SQL. Enter your search term, select which tables and columns to search, and phpMyAdmin shows you every match.<\/p>\n\n\n\n<p>This is useful for locating where a particular setting, URL, or piece of content is stored in your database.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Query<\/h3>\n\n\n\n<p>Provides a visual query builder for users who prefer not to write SQL by hand. Select tables, choose columns, and set conditions using dropdown menus. phpMyAdmin generates the SQL for you.<\/p>\n\n\n\n<p>The Query tab is helpful for learning SQL syntax. Build your query visually, then examine the generated code to understand how it works.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Export<\/h3>\n\n\n\n<p>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><strong>Quick export<\/strong> downloads the entire database in SQL format with default settings. This works for most backup and migration scenarios.<\/p>\n\n\n\n<p><strong>Custom export<\/strong> lets you choose specific tables, change the output format (SQL, CSV, JSON, XML), and adjust options like adding DROP TABLE statements or compressing the output.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Import<\/h3>\n\n\n\n<p>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>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 <a href=\"#import-file-size-limits\">Import File Size Limits<\/a> section.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Operations<\/h3>\n\n\n\n<p>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>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<p>Most users open phpMyAdmin for one of these reasons:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Backing Up Before a WordPress Update<\/h3>\n\n\n\n<p>Before updating WordPress core, themes, or plugins, export your database so you can restore it if something breaks.<\/p>\n\n\n\n<ol class=\"wp-block-list article_list\">\n<li>Select your WordPress 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 downloaded .sql file somewhere safe.<\/li>\n<\/ol>\n\n\n\n<p>If the update causes problems, you can restore this backup using the Import tab.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Restoring a Database After Migration<\/h3>\n\n\n\n<p>After moving to a new host, you\u2019ll import your database backup:<\/p>\n\n\n\n<ol class=\"wp-block-list article_list\">\n<li>Create an empty database and user in cPanel\u2019s MySQL Databases tool.<\/li>\n\n\n\n<li>Open phpMyAdmin and select the new database.<\/li>\n\n\n\n<li>Click the <strong>Import<\/strong> tab.<\/li>\n\n\n\n<li>Click <strong>Choose File<\/strong> and select your .sql backup.<\/li>\n\n\n\n<li>Click <strong>Import<\/strong>.<\/li>\n<\/ol>\n\n\n\n<p>The import process may take several minutes for large databases. Don\u2019t close the browser tab until it completes.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Resetting a WordPress Admin Password<\/h3>\n\n\n\n<p>Locked out of your WordPress site? You can reset your password directly in the database.<\/p>\n\n\n\n<ol class=\"wp-block-list article_list\">\n<li>Select your WordPress database.<\/li>\n\n\n\n<li>Click the <strong>wp_users<\/strong> table (or whatever prefix your installation uses).<\/li>\n\n\n\n<li>Find your user account and click <strong>Edit<\/strong>.<\/li>\n\n\n\n<li>In the <strong>user_pass<\/strong> field, select <strong>MD5<\/strong> from the function dropdown.<\/li>\n\n\n\n<li>Enter your new password in the value field.<\/li>\n\n\n\n<li>Click <strong>Go<\/strong> to save.<\/li>\n<\/ol>\n\n\n\n<p>WordPress will recognize the MD5-hashed password and let you log in. For detailed steps, see <a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/reset-wordpress-password\/\">How to Reset a WordPress Password in phpMyAdmin<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Finding Large Tables<\/h3>\n\n\n\n<p>If your database has grown unexpectedly, the Structure tab shows which tables are using the most space.<\/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 <strong>Structure<\/strong> tab.<\/li>\n\n\n\n<li>Click the <strong>Size<\/strong> column header to sort by size.<\/li>\n<\/ol>\n\n\n\n<p>Common culprits in WordPress:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>wp_posts<\/strong>: Stores post revisions (WordPress keeps unlimited revisions by default)<\/li>\n\n\n\n<li><strong>wp_postmeta<\/strong>: Can bloat from plugins storing temporary data<\/li>\n\n\n\n<li><strong>wp_options<\/strong>: May contain transients that weren\u2019t cleaned up<\/li>\n\n\n\n<li>Plugin-specific tables for logging, analytics, or form submissions<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Optimizing and Repairing Tables<\/h2>\n\n\n\n<p>Database tables can become fragmented over time, especially after many insert and delete operations. Corrupted tables can cause missing data or error messages.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Optimizing Tables<\/h3>\n\n\n\n<p>Optimization reclaims unused space and defragments the data file.<\/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 <strong>Structure<\/strong> tab.<\/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 <strong>Optimize table<\/strong>.<\/li>\n\n\n\n<li>Click <strong>Go<\/strong>.<\/li>\n<\/ol>\n\n\n\n<p>phpMyAdmin reports the result for each table. A status of \u201cOK\u201d means the optimization completed successfully. A note saying \u201cTable does not support optimize\u201d appears for InnoDB tables, which handle optimization automatically.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Repairing Tables<\/h3>\n\n\n\n<p>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 <strong>Structure<\/strong> tab.<\/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 <strong>Repair table<\/strong>.<\/li>\n\n\n\n<li>Click <strong>Go<\/strong>.<\/li>\n<\/ol>\n\n\n\n<p>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>You can also use cPanel\u2019s built-in repair function: go to <strong>MySQL Databases<\/strong>, scroll to <strong>Modify Databases<\/strong>, select your database from the Repair dropdown, and click <strong>Repair Database<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Running SQL Queries<\/h2>\n\n\n\n<p>The SQL tab accepts any valid MySQL query. Here are some examples for common tasks.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Delete All Post Revisions in WordPress<\/h3>\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)\"><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>DELETE FROM wp_posts WHERE post_type = 'revision';<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewbox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><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<h3 class=\"wp-block-heading\">Delete All Spam Comments<\/h3>\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)\"><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>DELETE FROM wp_comments WHERE comment_approved = 'spam';<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewbox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><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_comments <\/span><span style=\"color: #F97583\">WHERE<\/span><span style=\"color: #E1E4E8\"> comment_approved <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">'spam'<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Find All Rows Containing a Specific URL<\/h3>\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)\"><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>SELECT * FROM wp_posts WHERE post_content LIKE '%oldsite.com%';<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewbox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><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\"> <\/span><span style=\"color: #F97583\">*<\/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_content <\/span><span style=\"color: #F97583\">LIKE<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">'%oldsite.com%'<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Update URLs After Domain Change<\/h3>\n\n\n\n<p>After migrating to a new domain, old URLs remain in your database. This query updates them in the posts table:<\/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)\"><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>UPDATE wp_posts SET post_content = REPLACE(post_content, 'http:\/\/oldsite.com', 'https:\/\/newsite.com');<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewbox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><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>You\u2019ll need to run similar queries for other tables like <code>wp_options<\/code>, <code>wp_postmeta<\/code>, and any plugin tables that store URLs.<\/p>\n\n\n\n<p><strong>Important<\/strong>: Simple find-and-replace queries can corrupt serialized data stored by WordPress plugins. For domain migrations, consider using a dedicated tool like the <a href=\"https:\/\/wordpress.org\/plugins\/better-search-replace\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Better Search Replace plugin<\/a> or WP-CLI\u2019s <code>search-replace<\/code> command, which handle serialized data correctly.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Import File Size Limits<\/h2>\n\n\n\n<p>phpMyAdmin imports are limited by your server\u2019s PHP configuration. On most shared hosting accounts, the maximum upload size ranges from 50MB to 256MB.<\/p>\n\n\n\n<p>Check your limit by clicking the Import tab. The maximum file size appears directly below the file selection button.<\/p>\n\n\n\n<p>If your database file exceeds this limit:<\/p>\n\n\n\n<p><strong>Compress the file<\/strong>: phpMyAdmin accepts .sql.gz and .sql.zip files. Compression often reduces file size by 80-90%.<\/p>\n\n\n\n<p><strong>Use cPanel\u2019s Backup Restore<\/strong>: The cPanel backup tool handles larger files than phpMyAdmin\u2019s browser-based uploader.<\/p>\n\n\n\n<p><strong>Import via SSH<\/strong>: For databases over 500MB, importing through the command line is faster and avoids timeout issues:<\/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)\"><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>mysql -u username -p database_name &lt; backup.sql<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewbox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #E1E4E8\">mysql <\/span><span style=\"color: #F97583\">-<\/span><span style=\"color: #E1E4E8\">u username <\/span><span style=\"color: #F97583\">-<\/span><span style=\"color: #E1E4E8\">p <\/span><span style=\"color: #F97583\">database_name<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">&lt;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">backup<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">sql<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>For detailed instructions, see <a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/ssh\/import-database-ssh\/\">Importing a Database via SSH<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Search and Replace<\/h2>\n\n\n\n<p>phpMyAdmin\u2019s Find and Replace feature lets you update values across an entire table without writing SQL.<\/p>\n\n\n\n<ol class=\"wp-block-list article_list\">\n<li>Select a table in the left panel.<\/li>\n\n\n\n<li>Click the <strong>Search<\/strong> tab.<\/li>\n\n\n\n<li>Click the <strong>Find and replace<\/strong> tab.<\/li>\n\n\n\n<li>Enter the text to find and the replacement text.<\/li>\n\n\n\n<li>Select which column to search.<\/li>\n\n\n\n<li>Click <strong>Go<\/strong> to preview matches.<\/li>\n\n\n\n<li>Click <strong>Replace<\/strong> to make the changes.<\/li>\n<\/ol>\n\n\n\n<p>This approach works well for simple text replacements within a single table. For site-wide URL changes across multiple tables, a dedicated search-replace plugin handles serialized data more safely.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Giving Developers phpMyAdmin Access<\/h2>\n\n\n\n<p>If a developer needs database access, don\u2019t share your cPanel credentials. Instead, install a separate phpMyAdmin instance that connects only to their assigned database.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Create a new database and database user for the developer in cPanel\u2019s MySQL Databases.<\/li>\n\n\n\n<li>Assign only the necessary privileges.<\/li>\n\n\n\n<li>Install phpMyAdmin in a subdirectory of your account.<\/li>\n\n\n\n<li>Configure it to connect with the developer\u2019s credentials.<\/li>\n<\/ol>\n\n\n\n<p>This approach limits their access to a single database and keeps your cPanel login secure. For step-by-step instructions, see <a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-install\/\">Installing phpMyAdmin on your Account<\/a>.<\/p>\n\n\n\n<p>Alternatively, if the developer only needs to run specific queries or view data, you can export the relevant tables and send them the SQL file.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Troubleshooting Common Issues<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u201cTable doesn\u2019t exist\u201d Errors<\/h3>\n\n\n\n<p>This usually means the table was dropped or the database prefix is wrong. Check that you\u2019re connected to the correct database and that the table name matches what your application expects (including the prefix, like <code>wp_<\/code> for WordPress).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Queries Timing Out<\/h3>\n\n\n\n<p>Large queries can exceed PHP\u2019s execution time limit. Options include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Breaking the query into smaller batches<\/li>\n\n\n\n<li>Running the query via SSH instead of phpMyAdmin<\/li>\n\n\n\n<li>Asking your host to temporarily increase the timeout<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Import Fails with \u201cScript timeout\u201d<\/h3>\n\n\n\n<p>Large imports may exceed the maximum execution time. Try:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Compressing the SQL file before uploading<\/li>\n\n\n\n<li>Using cPanel\u2019s command-line import instead<\/li>\n\n\n\n<li>Splitting the SQL file into smaller chunks<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Changes Don\u2019t Appear on the Website<\/h3>\n\n\n\n<p>WordPress and many CMS platforms use caching. After making database changes:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Clear any caching plugin (WP Super Cache, W3 Total Cache, etc.)<\/li>\n\n\n\n<li>Clear your browser cache<\/li>\n\n\n\n<li>If using a CDN, purge the CDN cache<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Next Steps<\/h2>\n\n\n\n<p>Now that you understand phpMyAdmin\u2019s interface and capabilities, you can:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-database\/\">Export a database backup<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-database\/\">Import a database from another server<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/manage-mysql-databases-cpanel\/\">Create databases and users in cPanel<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/setting-up-a-remote-mysql-connection-in-cpanel\/\">Set up remote database access<\/a><\/li>\n<\/ul>\n\n\n\n<p>Regular database maintenance keeps your site running smoothly. Export a backup before major changes, optimize tables periodically, and address corruption warnings promptly before they cause data loss.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>phpMyAdmin is a web-based tool for managing MySQL and MariaDB databases. While cPanel&#8217;s MySQL Databases tool handles creating databases and users, phpMyAdmin is where you work with the data itself: browsing tables, running queries, importing backups, and fixing corrupted records. This guide covers the phpMyAdmin interface, explains what each menu tab does, and walks through<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_memberships_contains_paid_content":false,"footnotes":""},"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 v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How To Manage Databases in cPanel with phpMyAdmin<\/title>\n<meta name=\"description\" content=\"Learn to create, configure, and maintain MySQL databases in cPanel, including user permissions, remote access, and troubleshooting.\" \/>\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=\"Learn to create, configure, and maintain MySQL databases in cPanel, including user permissions, remote access, and troubleshooting.\" \/>\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=\"2025-12-31T18:45:49+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=\"10 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\":\"2025-12-31T18:45:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/\"},\"wordCount\":2054,\"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\":\"2025-12-31T18:45:49+00:00\",\"description\":\"Learn to create, configure, and maintain MySQL databases in cPanel, including user permissions, remote access, and troubleshooting.\",\"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 Senior Marketing Operations leader with over 20 years of experience in digital strategy, web development, and IT project management. She specializes in go-to-market programs and SaaS solutions for WordPress and VPS Hosting, working closely with technical teams and customers to deliver high-performance, scalable platforms. At InMotion Hosting, she drives product marketing initiatives that blend strategic insight with technical depth.\",\"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":"Learn to create, configure, and maintain MySQL databases in cPanel, including user permissions, remote access, and troubleshooting.","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":"Learn to create, configure, and maintain MySQL databases in cPanel, including user permissions, remote access, and troubleshooting.","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":"2025-12-31T18:45:49+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":"10 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":"2025-12-31T18:45:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/manage-databases-cpanel-phpmyadmin\/"},"wordCount":2054,"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":"2025-12-31T18:45:49+00:00","description":"Learn to create, configure, and maintain MySQL databases in cPanel, including user permissions, remote access, and troubleshooting.","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 Senior Marketing Operations leader with over 20 years of experience in digital strategy, web development, and IT project management. She specializes in go-to-market programs and SaaS solutions for WordPress and VPS Hosting, working closely with technical teams and customers to deliver high-performance, scalable platforms. At InMotion Hosting, she drives product marketing initiatives that blend strategic insight with technical depth.","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":6,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/4181\/revisions"}],"predecessor-version":[{"id":131389,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/4181\/revisions\/131389"}],"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}]}}