{"id":6411,"date":"2022-03-11T06:22:28","date_gmt":"2022-03-11T12:22:28","guid":{"rendered":"https:\/\/www.knownhost.com\/kb\/?p=6411"},"modified":"2022-03-11T09:02:58","modified_gmt":"2022-03-11T15:02:58","slug":"how-to-reset-the-mysql-root-password","status":"publish","type":"post","link":"https:\/\/www.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/","title":{"rendered":"How to reset the MySQL root password?"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 ez-toc-wrap-right counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #212121;color:#212121\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #212121;color:#212121\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/#using_whm_panel\" >Using WHM Panel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/#using_ssh\" >Using SSH<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/#conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>DBAs (Database Administrators) need to have root-level access to MySQL; sometimes, you might need to change the MySQL password for security or other reasons. In this article, you will learn how to reset the MySQL root password?<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"using_whm_panel\"><\/span>Using WHM Panel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>1. First, login into WHM panel,<\/p>\n\n\n\n<p><strong>https:\/\/your-domain.com:2087<\/strong>&nbsp;or&nbsp;<strong>https:\/\/IP-address:&nbsp;2087&nbsp;<\/strong>or&nbsp;<strong>https:\/\/server-hostname:&nbsp;2087<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/10\/login-to-whm-cpanel-1024x627.jpg.webp\" alt=\"login-to-whm-panel\" class=\"wp-image-3960\"\/><\/figure>\n\n\n\n<p>2. Navigate to&nbsp;<strong>SQL Services \u2192 MySQL Root Password<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/01\/change-mysql-root-password-1024x753.jpg.webp\" alt=\"change mysql root password\" class=\"wp-image-6127\"\/><\/figure>\n\n\n\n<p>3.&nbsp;<strong>Enter<\/strong>&nbsp;the&nbsp;<strong>password<\/strong>&nbsp;<strong>\u2192<\/strong>&nbsp;<strong>Click<\/strong>&nbsp;on&nbsp;<strong>Change<\/strong>&nbsp;<strong>Password<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/01\/enter-new-password-for-root-mysql-1024x443.jpg.webp\" alt=\"enter new password for root mysql\" class=\"wp-image-6129\"\/><\/figure>\n\n\n\n<p>3. Congratulations! You have successfully changed MySQL password for root.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/01\/how-to-change-mysql-root-password-1024x443.jpg.webp\" alt=\"how to change mysql root password\" class=\"wp-image-6126\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"using_ssh\"><\/span>Using SSH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>1. Login to SSH and run the following to login into MySQL as user root and enter the present MySQL&#8217;s root user password,<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u root -p<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"437\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/login-to-mysql-root-with-password-1024x437.jpg\" alt=\"login to mysql root with password\" class=\"wp-image-6417\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/login-to-mysql-root-with-password-1024x437.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/login-to-mysql-root-with-password-300x128.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/login-to-mysql-root-with-password-768x328.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/login-to-mysql-root-with-password-1536x656.jpg 1536w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/login-to-mysql-root-with-password.jpg 1668w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>If did not configure any password for MySQL root user then run the following command and simply hit Enter,<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"437\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/login-to-mysql-as-root-user-1024x437.jpg\" alt=\"login to mysql as root user\" class=\"wp-image-6416\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/login-to-mysql-as-root-user-1024x437.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/login-to-mysql-as-root-user-300x128.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/login-to-mysql-as-root-user-768x328.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/login-to-mysql-as-root-user-1536x656.jpg 1536w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/login-to-mysql-as-root-user.jpg 1668w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>2. Run the following command to set the new password,<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER USER 'root'@'localhost' IDENTIFIED BY 'MY-NEW-PASSWORD';<\/code><\/pre>\n\n\n\n<p><em><em>In the above command, we changed MySQL&#8217;s root user password to &#8220;MY-NEW-PASSWORD&#8221;; replace &#8216;MY-NEW-PASSWORD&#8221; with the desired password.<\/em><\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"437\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/how-to-change-mysql-root-password-using-cli-1024x437.jpg\" alt=\"how to change mysql root password using cli\" class=\"wp-image-6415\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/how-to-change-mysql-root-password-using-cli-1024x437.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/how-to-change-mysql-root-password-using-cli-300x128.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/how-to-change-mysql-root-password-using-cli-768x328.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/how-to-change-mysql-root-password-using-cli-1536x656.jpg 1536w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/how-to-change-mysql-root-password-using-cli.jpg 1668w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>3. Next, run the following command to flush the privileges,<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>FLUSH PRIVILEGES;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"437\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/FLUSH-PRIVILEGES-mysql-user-1024x437.jpg\" alt=\"FLUSH PRIVILEGES mysql user\" class=\"wp-image-6414\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/FLUSH-PRIVILEGES-mysql-user-1024x437.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/FLUSH-PRIVILEGES-mysql-user-300x128.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/FLUSH-PRIVILEGES-mysql-user-768x328.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/FLUSH-PRIVILEGES-mysql-user-1536x656.jpg 1536w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2022\/03\/FLUSH-PRIVILEGES-mysql-user.jpg 1668w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"conclusion\"><span class=\"ez-toc-section\" id=\"conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>We\u2019ve gone over how to reset the MySQL root password for WHM and use the command-line interface. If you ever want to change the MySQL root password, you need to go through this article.<\/p>\n\n\n\n<p>KnownHost offers 365 days a year, 24 hours a day, all 7 days of the week best in class technical support. A dedicated team ready to help you with requests should you need our assistance. You\u2019re not using KnownHost for the best webhosting experience? Well, why not? Check with&nbsp;<a href=\"https:\/\/www.knownhost.com\/contact\">our Sales team<\/a>&nbsp;to see what can&nbsp;<a href=\"https:\/\/www.knownhost.com\/\">KnownHost<\/a>&nbsp;do for you in improving your webhosting experience.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DBAs (Database Administrators) need to have root-level access to MySQL; sometimes, you might need to change the MySQL password for security or other reasons. In this article, you will learn how to reset the MySQL root password? Using WHM Panel 1. First, login into WHM panel, https:\/\/your-domain.com:2087&nbsp;or&nbsp;https:\/\/IP-address:&nbsp;2087&nbsp;or&nbsp;https:\/\/server-hostname:&nbsp;2087. 2. Navigate to&nbsp;SQL Services \u2192 MySQL Root Password. [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[101],"tags":[109,186,329],"class_list":["post-6411","post","type-post","status-publish","format-standard","hentry","category-cpanel","tag-cpanel","tag-mysql","tag-reset"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to reset the MySQL root password? - KnownHost<\/title>\n<meta name=\"description\" content=\"Oops! You forget the MySQL root password? Don&#039;t worry, learn step by step guide on how to reset 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.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to reset the MySQL root password? - KnownHost\" \/>\n<meta property=\"og:description\" content=\"Oops! You forget the MySQL root password? Don&#039;t worry, learn step by step guide on how to reset the MySQL root password.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/\" \/>\n<meta property=\"og:site_name\" content=\"KnownHost\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-11T12:22:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-11T15:02:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/10\/login-to-whm-cpanel-1024x627.jpg.webp\" \/>\n<meta name=\"author\" content=\"Somesh Z\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Somesh Z\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-reset-the-mysql-root-password\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-reset-the-mysql-root-password\\\/\"},\"author\":{\"name\":\"Somesh Z\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/8b518f13cf69dd00d147e577d63ff3b1\"},\"headline\":\"How to reset the MySQL root password?\",\"datePublished\":\"2022-03-11T12:22:28+00:00\",\"dateModified\":\"2022-03-11T15:02:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-reset-the-mysql-root-password\\\/\"},\"wordCount\":281,\"image\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-reset-the-mysql-root-password\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/login-to-whm-cpanel-1024x627.jpg.webp\",\"keywords\":[\"cpanel\",\"mysql\",\"reset\"],\"articleSection\":[\"cPanel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-reset-the-mysql-root-password\\\/\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-reset-the-mysql-root-password\\\/\",\"name\":\"How to reset the MySQL root password? - KnownHost\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-reset-the-mysql-root-password\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-reset-the-mysql-root-password\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/login-to-whm-cpanel-1024x627.jpg.webp\",\"datePublished\":\"2022-03-11T12:22:28+00:00\",\"dateModified\":\"2022-03-11T15:02:58+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/8b518f13cf69dd00d147e577d63ff3b1\"},\"description\":\"Oops! You forget the MySQL root password? Don't worry, learn step by step guide on how to reset the MySQL root password.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-reset-the-mysql-root-password\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-reset-the-mysql-root-password\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-reset-the-mysql-root-password\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/login-to-whm-cpanel-1024x627.jpg.webp\",\"contentUrl\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/login-to-whm-cpanel-1024x627.jpg.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-reset-the-mysql-root-password\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to reset the MySQL root password?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/\",\"name\":\"KnownHost\",\"description\":\"KnownHost provides a comprehensive webhosting knowledge base to help answer many of your common webhosting and linux questions.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/8b518f13cf69dd00d147e577d63ff3b1\",\"name\":\"Somesh Z\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g\",\"caption\":\"Somesh Z\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to reset the MySQL root password? - KnownHost","description":"Oops! You forget the MySQL root password? Don't worry, learn step by step guide on how to reset 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.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/","og_locale":"en_US","og_type":"article","og_title":"How to reset the MySQL root password? - KnownHost","og_description":"Oops! You forget the MySQL root password? Don't worry, learn step by step guide on how to reset the MySQL root password.","og_url":"https:\/\/www.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/","og_site_name":"KnownHost","article_published_time":"2022-03-11T12:22:28+00:00","article_modified_time":"2022-03-11T15:02:58+00:00","og_image":[{"url":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/10\/login-to-whm-cpanel-1024x627.jpg.webp","type":"","width":"","height":""}],"author":"Somesh Z","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Somesh Z","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/#article","isPartOf":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/"},"author":{"name":"Somesh Z","@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/8b518f13cf69dd00d147e577d63ff3b1"},"headline":"How to reset the MySQL root password?","datePublished":"2022-03-11T12:22:28+00:00","dateModified":"2022-03-11T15:02:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/"},"wordCount":281,"image":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/#primaryimage"},"thumbnailUrl":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/10\/login-to-whm-cpanel-1024x627.jpg.webp","keywords":["cpanel","mysql","reset"],"articleSection":["cPanel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/","url":"https:\/\/www.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/","name":"How to reset the MySQL root password? - KnownHost","isPartOf":{"@id":"https:\/\/www.knownhost.com\/kb\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/#primaryimage"},"image":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/#primaryimage"},"thumbnailUrl":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/10\/login-to-whm-cpanel-1024x627.jpg.webp","datePublished":"2022-03-11T12:22:28+00:00","dateModified":"2022-03-11T15:02:58+00:00","author":{"@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/8b518f13cf69dd00d147e577d63ff3b1"},"description":"Oops! You forget the MySQL root password? Don't worry, learn step by step guide on how to reset the MySQL root password.","breadcrumb":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/#primaryimage","url":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/10\/login-to-whm-cpanel-1024x627.jpg.webp","contentUrl":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/10\/login-to-whm-cpanel-1024x627.jpg.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/www.knownhost.com\/kb\/how-to-reset-the-mysql-root-password\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.knownhost.com\/kb\/"},{"@type":"ListItem","position":2,"name":"How to reset the MySQL root password?"}]},{"@type":"WebSite","@id":"https:\/\/www.knownhost.com\/kb\/#website","url":"https:\/\/www.knownhost.com\/kb\/","name":"KnownHost","description":"KnownHost provides a comprehensive webhosting knowledge base to help answer many of your common webhosting and linux questions.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.knownhost.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/8b518f13cf69dd00d147e577d63ff3b1","name":"Somesh Z","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g","caption":"Somesh Z"}}]}},"_links":{"self":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/6411","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/comments?post=6411"}],"version-history":[{"count":0,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/6411\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/media?parent=6411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/categories?post=6411"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/tags?post=6411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}