{"id":74793,"date":"2021-06-18T15:19:39","date_gmt":"2021-06-18T19:19:39","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/?page_id=74793"},"modified":"2023-08-15T12:47:12","modified_gmt":"2023-08-15T16:47:12","slug":"phpmyadmin-mysql","status":"publish","type":"page","link":"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/","title":{"rendered":"PHPMyAdmin"},"content":{"rendered":"<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<p>For <a href=\"https:\/\/www.inmotionhosting.com\/php-hosting\">hosting PHP<\/a> on your website, PHPMyAdmin might be the most important tool in your arsenal. It lets you effortlessly manage all of your databases on your server. Whether you use MySQL, MariaDB, PostgreSQL, or some other database storage mechanism, PHPMyAdmin lets you easily search, organize, import, export, and much more. PHPMyAdmin is also a great place to test out SQL queries. A built-in SQL editor lets you easily run advanced queries without having to log in to a command line session.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"571\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/06\/PhpMyAdmin_logo.svg_-1024x571.png\" alt=\"\" class=\"wp-image-74801\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/06\/PhpMyAdmin_logo.svg_-1024x571.png 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/06\/PhpMyAdmin_logo.svg_-300x167.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/06\/PhpMyAdmin_logo.svg_-768x428.png 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/06\/PhpMyAdmin_logo.svg_-1536x856.png 1536w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/06\/PhpMyAdmin_logo.svg_-2048x1141.png 2048w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Getting Started With PHPMyAdmin<\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Here in the support center, we have everything you need to get started using PHPMyAdmin. It comes pre-installed in most accounts, but if you have a self-managed server, we\u2019ve got you covered.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/installing-phpmyadmin-on-your-account\/\">How to install PHPMyAdmin<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/\">How to import a MySQL database with PHPMyAdmin<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/manage-mysql-database-in-phpmyadmin\/\">How to manage a MySQL database with PHPMyAdmin<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/\">How to import a table using PHPMyAdmin<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/export-database-using-phpmyadmin\/\">How to export a database using PHPMyAdmin<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">More Advanced PHPMyAdmin Tutorials<\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Moving on with your mastery of PHPMyAdmin, we have more tutorials that will help support you as you accomplish more demanding database tasks.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/\">How to create a databases diagram with PHPMyAdmin<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/\">How to export a table in PHPMyAdmin<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/kill-mysql-processes-phpmyadmin\/\">How to kill MySQL processes with PHPMyAdmin<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/check-repair-database\/\">How to check and repair a database in PHPMyAdmin<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/drop-table\/\">How to drop a table in PHPMyAdmin<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/reset-database\/\">How to reset a database in PHPMyAdmin<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-phpmyadmin-to-optimize-a-database\/\">How to optimize a database with PHPMyAdmin<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n<ul class=\"lcp_catlist\" id=\"lcp_instance_0\"><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/cache-manager-cpanel\/\">Cache Manager for cPanel<\/a><\/li><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/remove-index-listing\/\">Preventing the &#8220;Index Of&#8221; listing page using the Index Manager<\/a><\/li><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/cpanel-pricing-structure\/\">How Much Will You Pay For cPanel Licenses?<\/a><\/li><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/setup-node-js-app\/\">How To Setup Node.js App in cPanel<\/a><\/li><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/rvm-ruby-version-manager\/\">Basics of RVM &#8211; Ruby Version Manager<\/a><\/li><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/understanding-character-encoding-in-the-code-editor-of-cpanel\/\">Understanding Website Character Encoding in cPanel<\/a><\/li><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/how-to-upload-a-file-using-file-manager-in-cpanel\/\">How to Upload a File With cPanel File Manager<\/a><\/li><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/file-manager-code-editor\/\">How to Edit HTML Code in cPanel<\/a><\/li><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/dmarc-setup\/\">How to Setup DMARC Records in cPanel<\/a><\/li><li><a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/how-to-create-a-thumbnail\/\">How to Create a Thumbnail Image Using cPanel<\/a><\/li><\/ul><ul class='lcp_paginator'><li class='lcp_currentpage'>1<\/li><li><a href='https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/74793?lcp_page0=2#lcp_instance_0' title='2'>2<\/a><\/li><li><a href='https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/74793?lcp_page0=3#lcp_instance_0' title='3'>3<\/a><\/li><li><a href='https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/74793?lcp_page0=4#lcp_instance_0' title='4'>4<\/a><\/li><li><a href='https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/74793?lcp_page0=5#lcp_instance_0' title='5'>5<\/a><\/li><li><a href='https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/74793?lcp_page0=6#lcp_instance_0' title='6'>6<\/a><\/li><span class='lcp_elipsis'>...<\/span><li><a href='https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/74793?lcp_page0=22#lcp_instance_0' title='22'>22<\/a><\/li><li><a href='https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/74793?lcp_page0=2#lcp_instance_0' title='2' class='lcp_nextlink'>&gt;&gt;<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>For hosting PHP on your website, PHPMyAdmin might be the most important tool in your arsenal. It lets you effortlessly manage all of your databases on your server. Whether you use MySQL, MariaDB, PostgreSQL, or some other database storage mechanism, PHPMyAdmin lets you easily search, organize, import, export, and much more. PHPMyAdmin is also a<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/\"> Read More ><\/a><\/p>\n","protected":false},"author":17,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"class_list":["post-74793","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>PHPMyAdmin | InMotion Hosting<\/title>\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\/phpmyadmin-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PHPMyAdmin | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"For hosting PHP on your website, PHPMyAdmin might be the most important tool in your arsenal. It lets you effortlessly manage all of your databases on your server. Whether you use MySQL, MariaDB, PostgreSQL, or some other database storage mechanism, PHPMyAdmin lets you easily search, organize, import, export, and much more. PHPMyAdmin is also a Read More &gt;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/\" \/>\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:modified_time\" content=\"2023-08-15T16:47:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/06\/PhpMyAdmin_logo.svg_-1024x571.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/\",\"name\":\"PHPMyAdmin | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/06\/PhpMyAdmin_logo.svg_-1024x571.png\",\"datePublished\":\"2021-06-18T19:19:39+00:00\",\"dateModified\":\"2023-08-15T16:47:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/06\/PhpMyAdmin_logo.svg_.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/06\/PhpMyAdmin_logo.svg_.png\",\"width\":3890,\"height\":2168},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"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\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PHPMyAdmin | InMotion Hosting","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\/phpmyadmin-mysql\/","og_locale":"en_US","og_type":"article","og_title":"PHPMyAdmin | InMotion Hosting","og_description":"For hosting PHP on your website, PHPMyAdmin might be the most important tool in your arsenal. It lets you effortlessly manage all of your databases on your server. Whether you use MySQL, MariaDB, PostgreSQL, or some other database storage mechanism, PHPMyAdmin lets you easily search, organize, import, export, and much more. PHPMyAdmin is also a Read More >","og_url":"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_modified_time":"2023-08-15T16:47:12+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/06\/PhpMyAdmin_logo.svg_-1024x571.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@InMotionHosting","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/","url":"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/","name":"PHPMyAdmin | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/06\/PhpMyAdmin_logo.svg_-1024x571.png","datePublished":"2021-06-18T19:19:39+00:00","dateModified":"2023-08-15T16:47:12+00:00","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/06\/PhpMyAdmin_logo.svg_.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/06\/PhpMyAdmin_logo.svg_.png","width":3890,"height":2168},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/phpmyadmin-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"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"]}]}},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/74793","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=74793"}],"version-history":[{"count":11,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/74793\/revisions"}],"predecessor-version":[{"id":106018,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/pages\/74793\/revisions\/106018"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=74793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}