{"id":13278,"date":"2021-06-24T07:21:58","date_gmt":"2021-06-24T07:21:58","guid":{"rendered":"https:\/\/www.milesweb.in\/hosting-faqs\/?p=13278"},"modified":"2021-07-19T07:37:41","modified_gmt":"2021-07-19T07:37:41","slug":"change-mysql-root-password-whm","status":"publish","type":"post","link":"https:\/\/www.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/","title":{"rendered":"How to Change your MySQL Root Password via WHM?"},"content":{"rendered":"<p><strong>Watch this video for a step by step process on how to Change your MySQL Root Password via WHM<\/strong><\/p>\n<div class=\"youtube-video\" style=\"border: 1px solid #ddd;\"><iframe src=\"https:\/\/www.youtube.com\/embed\/-Z6tovPEi9o\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<p>Logging in to your MySQL account allows you to access and manage your server&#8217;s databases. The MySQL account belongs to a different application than WHM. Thus, your WHM root account credentials will not work for logging in to MySQL as it has its own username and password. However, you can change the login details like MySQL root password to this account with the WHM panel.<\/p>\n<h2>To Change your MySQL Root Password<\/h2>\n<p>1. Log in to WHM with your root account.<\/p>\n<p>2. Search and select <strong>SQL Services\u00a0<\/strong>from the navigation menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12050\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/06\/whm_sql_services.png\" alt=\"\" width=\"1919\" height=\"790\" \/><\/p>\n<p>3. Click on <strong>MySQL Root Password<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12051\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/06\/whm_mysql_root_pass.png\" alt=\"\" width=\"1595\" height=\"371\" \/><\/p>\n<p>The system assigns a\u00a0random string as the MySQL Root Password by default.<\/p>\n<p>4. You will have to enter the new password twice.<\/p>\n<div class=\"kb-wisdom-wrapr kb-wisdom-info kb-wisdom-wrapr-blue\">\n<div class=\"kb-wisdom-col kb-wisdom-col-icon\">\n<div class=\"kb-wisdom-icon\">\n<div><\/div>\n<\/div>\n<\/div>\n<div class=\"kb-wisdom-col kb-wisdom-col-content\">\n<p><strong>Note<\/strong>: The root password should be a combination of uppercase and lowercase letters, numbers, and special characters.<\/p>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12052\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/06\/whm_change_pass.png\" alt=\"\" width=\"1628\" height=\"442\" \/><\/p>\n<p>Alternatively, you can also use the <strong>Password Generator<\/strong> button that will produce a random string that you can copy and paste as a strong password. We recommend you copy the password somewhere so that you can use it again.<\/p>\n<p>Tick the box beside &#8220;I have copied this password in a safe place.&#8221; Click the <strong>Use Password<\/strong> button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12054\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/06\/whm_mysql_pass_generator.png\" alt=\"\" width=\"481\" height=\"309\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>5. Click the <strong>Change Password<\/strong> button.<\/p>\n<p>The system will assign the new password for your MySQL root account. The next time you log in to your MySQL root account, you will have to use the new password.<\/p>\n<p><script type=\"application\/ld+json\">{\n  \"@context\": \"http:\/\/schema.org\",\n  \"@type\": \"VideoObject\",\n  \"name\": \"How to Change your MySQL Root Password via WHM? | MilesWeb\",\n  \"description\": \"Here's an in-depth guide on how to change your MySQL root password via WHM:  https:\/\/www.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/  Give a thumbs up \ud83d\udc4d if you liked this video.  Subscribe to our channel and get notified for all the latest videos.  To know more about web hosting visit our website - https:\/\/www.milesweb.in\",\n  \"thumbnailUrl\": \"https:\/\/i.ytimg.com\/vi\/-Z6tovPEi9o\/default.jpg\",\n  \"uploadDate\": \"2021-07-15T12:06:31Z\",\n  \"duration\": \"PT2M36S\",\n  \"embedUrl\": \"https:\/\/www.youtube.com\/embed\/-Z6tovPEi9o\",\n  \"interactionCount\": \"68\"\n}<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Watch this video for a step by step process on how to Change your MySQL Root Password via WHM Logging in to your MySQL account allows you to access and manage your server&#8217;s databases. The MySQL account belongs to a different application than WHM. Thus, your WHM root account credentials will not work for logging [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41,967,229],"tags":[2309,2308,2307,1049],"class_list":["post-13278","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-howtos","category-mysql","category-whm","tag-change-mysql-root-password","tag-change-your-mysql-root-password-via-whm","tag-how-to-change-your-mysql-root-password-via-whm","tag-root-mysql-password"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Change your MySQL Root Password via WHM?<\/title>\n<meta name=\"description\" content=\"This article has the steps to change the MySQL password for the root account via WHM.\" \/>\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.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Change your MySQL Root Password via WHM?\" \/>\n<meta property=\"og:description\" content=\"This article has the steps to change the MySQL password for the root account via WHM.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2021-06-24T07:21:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-19T07:37:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/06\/whm_sql_services.png\" \/>\n<meta name=\"author\" content=\"Prasad Khartadkar\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prasad Khartadkar\" \/>\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.milesweb.in\\\/hosting-faqs\\\/change-mysql-root-password-whm\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/change-mysql-root-password-whm\\\/\"},\"author\":{\"name\":\"Prasad Khartadkar\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/#\\\/schema\\\/person\\\/c9138a9488172a8d0aa2d4f40878d83e\"},\"headline\":\"How to Change your MySQL Root Password via WHM?\",\"datePublished\":\"2021-06-24T07:21:58+00:00\",\"dateModified\":\"2021-07-19T07:37:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/change-mysql-root-password-whm\\\/\"},\"wordCount\":255,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/change-mysql-root-password-whm\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/whm_sql_services.png\",\"keywords\":[\"Change MySQL Root Password\",\"Change your MySQL Root Password via WHM\",\"How to Change your MySQL Root Password via WHM\",\"root mysql password\"],\"articleSection\":[\"How-Tos\",\"MySQL\",\"Web Host Manager\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/change-mysql-root-password-whm\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/change-mysql-root-password-whm\\\/\",\"url\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/change-mysql-root-password-whm\\\/\",\"name\":\"How to Change your MySQL Root Password via WHM?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/change-mysql-root-password-whm\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/change-mysql-root-password-whm\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/whm_sql_services.png\",\"datePublished\":\"2021-06-24T07:21:58+00:00\",\"dateModified\":\"2021-07-19T07:37:41+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/#\\\/schema\\\/person\\\/c9138a9488172a8d0aa2d4f40878d83e\"},\"description\":\"This article has the steps to change the MySQL password for the root account via WHM.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/change-mysql-root-password-whm\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/change-mysql-root-password-whm\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/change-mysql-root-password-whm\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/stats_domain.png\",\"contentUrl\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/stats_domain.png\",\"width\":1026,\"height\":178},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/change-mysql-root-password-whm\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Change your MySQL Root Password via WHM?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/#website\",\"url\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/#\\\/schema\\\/person\\\/c9138a9488172a8d0aa2d4f40878d83e\",\"name\":\"Prasad Khartadkar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Prasad-K.-1-150x150.jpg\",\"url\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Prasad-K.-1-150x150.jpg\",\"contentUrl\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Prasad-K.-1-150x150.jpg\",\"caption\":\"Prasad Khartadkar\"},\"description\":\"Prasad is a business grad specialized in Marketing. He has garnered experience as a technical content writer and a digital marketer that he brings out in his work. He likes reading classics and travel in his free time.\",\"sameAs\":[\"https:\\\/\\\/www.milesweb.in\"],\"url\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/author\\\/prasad-khartadkar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Change your MySQL Root Password via WHM?","description":"This article has the steps to change the MySQL password for the root account via WHM.","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.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/","og_locale":"en_US","og_type":"article","og_title":"How to Change your MySQL Root Password via WHM?","og_description":"This article has the steps to change the MySQL password for the root account via WHM.","og_url":"https:\/\/www.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2021-06-24T07:21:58+00:00","article_modified_time":"2021-07-19T07:37:41+00:00","og_image":[{"url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/06\/whm_sql_services.png","type":"","width":"","height":""}],"author":"Prasad Khartadkar","twitter_misc":{"Written by":"Prasad Khartadkar","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/#article","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/"},"author":{"name":"Prasad Khartadkar","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e"},"headline":"How to Change your MySQL Root Password via WHM?","datePublished":"2021-06-24T07:21:58+00:00","dateModified":"2021-07-19T07:37:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/"},"wordCount":255,"commentCount":0,"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/06\/whm_sql_services.png","keywords":["Change MySQL Root Password","Change your MySQL Root Password via WHM","How to Change your MySQL Root Password via WHM","root mysql password"],"articleSection":["How-Tos","MySQL","Web Host Manager"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/","url":"https:\/\/www.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/","name":"How to Change your MySQL Root Password via WHM?","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/06\/whm_sql_services.png","datePublished":"2021-06-24T07:21:58+00:00","dateModified":"2021-07-19T07:37:41+00:00","author":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e"},"description":"This article has the steps to change the MySQL password for the root account via WHM.","breadcrumb":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/#primaryimage","url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/stats_domain.png","contentUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/02\/stats_domain.png","width":1026,"height":178},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/change-mysql-root-password-whm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.in\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How to Change your MySQL Root Password via WHM?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.in\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.in\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e","name":"Prasad Khartadkar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/08\/Prasad-K.-1-150x150.jpg","url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/08\/Prasad-K.-1-150x150.jpg","contentUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/08\/Prasad-K.-1-150x150.jpg","caption":"Prasad Khartadkar"},"description":"Prasad is a business grad specialized in Marketing. He has garnered experience as a technical content writer and a digital marketer that he brings out in his work. He likes reading classics and travel in his free time.","sameAs":["https:\/\/www.milesweb.in"],"url":"https:\/\/www.milesweb.in\/hosting-faqs\/author\/prasad-khartadkar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/13278","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=13278"}],"version-history":[{"count":2,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/13278\/revisions"}],"predecessor-version":[{"id":13519,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/13278\/revisions\/13519"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=13278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=13278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=13278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}