{"id":2919,"date":"2013-10-24T14:08:36","date_gmt":"2013-10-24T14:08:36","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2013\/10\/24\/run-mysql-statement\/"},"modified":"2021-08-16T23:10:34","modified_gmt":"2021-08-17T03:10:34","slug":"run-mysql-statement","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/","title":{"rendered":"Running MySQL statements in phpMyAdmin"},"content":{"rendered":"

When working within your PhpMyAdmin tool, you have the ability to create and run custom MySQL statements. This can be very helpful if you are performing things like a site move or creating a test site and need to change specific site information stored in the database. Follow the instructions below as we demonstrate how to use manual MySQL statements in your PhpMyAdmin tool.<\/p>\n

Using mySQL statements in phpMyAdmin<\/h2>\n
    \n
  1. Log into your cPanel dashboard<\/a>.\n
    <\/div>\n<\/li>\n
  2. \"click<\/a>\n
    <\/div>\n

    Once in the cpanel dashboard, find the Databases<\/em> category and click on the phpMyAdmin<\/strong> tool.<\/p>\n

    <\/div>\n<\/li>\n
  3. \"choose<\/a>\n
    <\/div>\n

    This leads you to the main page. From here, look to the left-hand sidebar and click on the name of the database you want to work with. Here, we selected the database named wp962<\/strong>, which is for a WordPress installation.<\/p>\n

    <\/div>\n<\/li>\n
  4. \"select<\/a>\n
    <\/div>\n

    Next, you want to select the database table you will be working with. From the sidebar menu click on the name of the table you will be creating the statement for. For our example, we chose the wp_users<\/strong> table.<\/p>\n

    <\/div>\n<\/li>\n
  5. \"click<\/a>\n
    <\/div>\n

    Once on the table page, look to the tabs in the upper part of the screen and select the SQL<\/strong> tab.<\/p>\n

    <\/div>\n<\/li>\n
  6. \"enter<\/a>\n
    <\/div>\n

    You are brought to an editor screen where you can enter your MySQL statement. Once the statement has been entered, click on the Go<\/strong> button in the lower right corner of the screen to run it. In our example, we simply changed the email address of the admin user. Below you can see that the database now has the new email address in the user_email<\/em> field.<\/p>\n

    <\/div>\n\n\n\n<\/tr>\n
    Before<\/th>\nAfter<\/th>\n<\/tr>
    \"before<\/a>\n
    <\/div>\n<\/td>\n
    		\"after<\/a>\n
    <\/div>\n<\/td>\n<\/tr>\n\n\n<\/table>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    When working within your PhpMyAdmin tool, you have the ability to create and run custom MySQL statements. This can be very helpful if you are performing things like a site move or creating a test site and need to change specific site information stored in the database. Follow the instructions below as we demonstrate how Read More ><\/a><\/p>\n","protected":false},"author":8,"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":[4288,4305],"tags":[],"class_list":["post-2919","post","type-post","status-publish","format-standard","hentry","category-website","category-databases"],"acf":[],"yoast_head":"\nRunning MySQL statements in phpMyAdmin | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"Learn how to run mySQL statements from within your phpMyAdmin tool.\" \/>\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\/website\/run-mysql-statement\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Running MySQL statements in phpMyAdmin | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"Learn how to run mySQL statements from within your phpMyAdmin tool.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/\" \/>\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=\"2013-10-24T14:08:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-17T03:10:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/10\/phpmyadmin_run-mysql-statements_click-phpmyadmin-tool.png\" \/>\n<meta name=\"author\" content=\"Scott Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Scott Mitchell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/\"},\"author\":{\"name\":\"Scott Mitchell\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\"},\"headline\":\"Running MySQL statements in phpMyAdmin\",\"datePublished\":\"2013-10-24T14:08:36+00:00\",\"dateModified\":\"2021-08-17T03:10:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/\"},\"wordCount\":264,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/10\/phpmyadmin_run-mysql-statements_click-phpmyadmin-tool.png\",\"articleSection\":[\"Website\",\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/\",\"name\":\"Running MySQL statements in phpMyAdmin | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/10\/phpmyadmin_run-mysql-statements_click-phpmyadmin-tool.png\",\"datePublished\":\"2013-10-24T14:08:36+00:00\",\"dateModified\":\"2021-08-17T03:10:34+00:00\",\"description\":\"Learn how to run mySQL statements from within your phpMyAdmin tool.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/10\/phpmyadmin_run-mysql-statements_click-phpmyadmin-tool.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/10\/phpmyadmin_run-mysql-statements_click-phpmyadmin-tool.png\",\"width\":517,\"height\":114,\"caption\":\"Click here to view the larger image\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Running MySQL statements in 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 & 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\/d850efb28ef3573db7d24b0d8fa9eaed\",\"name\":\"Scott Mitchell\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Running MySQL statements in phpMyAdmin | InMotion Hosting","description":"Learn how to run mySQL statements from within your phpMyAdmin tool.","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\/website\/run-mysql-statement\/","og_locale":"en_US","og_type":"article","og_title":"Running MySQL statements in phpMyAdmin | InMotion Hosting","og_description":"Learn how to run mySQL statements from within your phpMyAdmin tool.","og_url":"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2013-10-24T14:08:36+00:00","article_modified_time":"2021-08-17T03:10:34+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/10\/phpmyadmin_run-mysql-statements_click-phpmyadmin-tool.png","type":"","width":"","height":""}],"author":"Scott Mitchell","twitter_card":"summary_large_image","twitter_creator":"@InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"Scott Mitchell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/"},"author":{"name":"Scott Mitchell","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed"},"headline":"Running MySQL statements in phpMyAdmin","datePublished":"2013-10-24T14:08:36+00:00","dateModified":"2021-08-17T03:10:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/"},"wordCount":264,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/10\/phpmyadmin_run-mysql-statements_click-phpmyadmin-tool.png","articleSection":["Website","Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/","url":"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/","name":"Running MySQL statements in phpMyAdmin | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/10\/phpmyadmin_run-mysql-statements_click-phpmyadmin-tool.png","datePublished":"2013-10-24T14:08:36+00:00","dateModified":"2021-08-17T03:10:34+00:00","description":"Learn how to run mySQL statements from within your phpMyAdmin tool.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/10\/phpmyadmin_run-mysql-statements_click-phpmyadmin-tool.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/10\/phpmyadmin_run-mysql-statements_click-phpmyadmin-tool.png","width":517,"height":114,"caption":"Click here to view the larger image"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/run-mysql-statement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"Running MySQL statements in 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 & 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\/d850efb28ef3573db7d24b0d8fa9eaed","name":"Scott Mitchell","url":"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":null,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2919","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\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=2919"}],"version-history":[{"count":2,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2919\/revisions"}],"predecessor-version":[{"id":84458,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2919\/revisions\/84458"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=2919"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=2919"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=2919"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}