{"id":2433,"date":"2012-11-21T17:15:50","date_gmt":"2012-11-21T17:15:50","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2012\/11\/21\/305-change-mysql-root-pass\/"},"modified":"2021-08-16T23:27:51","modified_gmt":"2021-08-17T03:27:51","slug":"305-change-mysql-root-pass","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/","title":{"rendered":"Change MySQL Root Password in WebHost Manager (WHM)"},"content":{"rendered":"

In this article we will discuss the procedure in changing your root password for MySQL. Please note that this task is available only to our VPS and dedicated customers with root access<\/em><\/a> and is not available at all for our shared server customers. The MySQL root password is separate from your main user root password. Below are the steps to changing your MySQL root password in your VPS or dedicated server WHM.<\/p>\n

Again, you must have root access to perform the steps below.<\/p>\n

Modifying your MySQL Root password in WHM<\/strong><\/p>\n

    \n
  1. Log into your WHM<\/a> account as the root user.<\/li>\n
  2. Once logged in, look to the left hand sidebar and scroll down until you see the SQL Services<\/strong> category. Under that category, locate the MySQL Root Password<\/strong> option and click that to continue to the next screen.
    \n    \"sql-services\"<\/a>\n
    <\/div>\n<\/li>\n
  3. You are now taken to the screen where you can enter your new MySQL root password. Be sure to enter one that is hard to guess, using letters (upper and lower case), numbers, and special characters. The higher the number in the strength indicator, the better. Alternatively, you can use the Generate Password<\/strong> button to have the server create a random password for you.
    \n    \"input-password\"<\/a>\n
    <\/div>\n<\/li>\n
  4. After you have a password you are satisfied with and have it written down in a safe place, click the Change Password<\/strong> button to finalize your change. You will see a screen with your new password indicating it was successful.
    \n    \"password-change-successful\"<\/a>\n
    <\/div>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    In this article we will discuss the procedure in changing your root password for MySQL. Please note that this task is available only to our VPS and dedicated customers with root access and is not available at all for our shared server customers. The MySQL root password is separate from your main user root password. 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":[4299,4289,4305],"tags":[],"class_list":["post-2433","post","type-post","status-publish","format-standard","hentry","category-security","category-whm","category-databases"],"acf":[],"yoast_head":"\nChange MySQL Root Password in WebHost Manager (WHM) | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"In this WHM tutorial, we teach you how to change the MYSQL root password.\" \/>\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\/security\/305-change-mysql-root-pass\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Change MySQL Root Password in WebHost Manager (WHM) | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"In this WHM tutorial, we teach you how to change the MYSQL root password.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/\" \/>\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=\"2012-11-21T17:15:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-17T03:27:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/11\/edu_whm_sql-services_change-mysql-root_sql-services.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\/security\/305-change-mysql-root-pass\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/\"},\"author\":{\"name\":\"Scott Mitchell\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\"},\"headline\":\"Change MySQL Root Password in WebHost Manager (WHM)\",\"datePublished\":\"2012-11-21T17:15:50+00:00\",\"dateModified\":\"2021-08-17T03:27:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/\"},\"wordCount\":248,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/11\/edu_whm_sql-services_change-mysql-root_sql-services.png\",\"articleSection\":[\"Security\",\"WebHost Manager (WHM)\",\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/\",\"name\":\"Change MySQL Root Password in WebHost Manager (WHM) | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/11\/edu_whm_sql-services_change-mysql-root_sql-services.png\",\"datePublished\":\"2012-11-21T17:15:50+00:00\",\"dateModified\":\"2021-08-17T03:27:51+00:00\",\"description\":\"In this WHM tutorial, we teach you how to change the MYSQL root password.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/11\/edu_whm_sql-services_change-mysql-root_sql-services.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/11\/edu_whm_sql-services_change-mysql-root_sql-services.png\",\"width\":1137,\"height\":686,\"caption\":\"sql-services\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Change MySQL Root Password in WebHost Manager (WHM)\"}]},{\"@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":"Change MySQL Root Password in WebHost Manager (WHM) | InMotion Hosting","description":"In this WHM tutorial, we teach you how to change the MYSQL root password.","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\/security\/305-change-mysql-root-pass\/","og_locale":"en_US","og_type":"article","og_title":"Change MySQL Root Password in WebHost Manager (WHM) | InMotion Hosting","og_description":"In this WHM tutorial, we teach you how to change the MYSQL root password.","og_url":"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2012-11-21T17:15:50+00:00","article_modified_time":"2021-08-17T03:27:51+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/11\/edu_whm_sql-services_change-mysql-root_sql-services.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\/security\/305-change-mysql-root-pass\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/"},"author":{"name":"Scott Mitchell","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed"},"headline":"Change MySQL Root Password in WebHost Manager (WHM)","datePublished":"2012-11-21T17:15:50+00:00","dateModified":"2021-08-17T03:27:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/"},"wordCount":248,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/11\/edu_whm_sql-services_change-mysql-root_sql-services.png","articleSection":["Security","WebHost Manager (WHM)","Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/","url":"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/","name":"Change MySQL Root Password in WebHost Manager (WHM) | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/11\/edu_whm_sql-services_change-mysql-root_sql-services.png","datePublished":"2012-11-21T17:15:50+00:00","dateModified":"2021-08-17T03:27:51+00:00","description":"In this WHM tutorial, we teach you how to change the MYSQL root password.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/11\/edu_whm_sql-services_change-mysql-root_sql-services.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/11\/edu_whm_sql-services_change-mysql-root_sql-services.png","width":1137,"height":686,"caption":"sql-services"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/security\/305-change-mysql-root-pass\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"Change MySQL Root Password in WebHost Manager (WHM)"}]},{"@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":{"id":4299,"name":"Security","slug":"security","link":"https:\/\/www.inmotionhosting.com\/support\/security\/"},"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2433","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=2433"}],"version-history":[{"count":4,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2433\/revisions"}],"predecessor-version":[{"id":85292,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2433\/revisions\/85292"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=2433"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=2433"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=2433"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}