{"id":1928,"date":"2021-09-16T05:58:51","date_gmt":"2021-09-16T05:58:51","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=1928"},"modified":"2021-09-16T06:00:28","modified_gmt":"2021-09-16T06:00:28","slug":"how-to-reset-the-mysql-root-password-and-mysql-user-passwords","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/how-to-reset-the-mysql-root-password-and-mysql-user-passwords\/","title":{"rendered":"How To Reset the MySQL\u00ae Root Password And MySQL User Passwords"},"content":{"rendered":"<p>The sites hosted on cPanel-managed servers has the MySQL primary database software , as well as WordPress\u00ae and ecommerce applications like Magento. As a result of MySQL has to manage read and write permissions for several different sites and databases, it&#8217;s a multi-user system.<\/p>\n<p>Each user account incorporates a set of permissions that limit its access. The MySQL root user has no restriction, because the root user, the database server\u2019s administrator will create and delete accounts and modify the other account or database.<\/p>\n<p>If the MySQL root user\u2019s password get reveal to 3rd parties or non-admin server users, it should to be modified. A bad actor who gets hold of the password could abuse it to disrupt sites and access sensitive data.<\/p>\n<p>In this article, we are going to justify the way to change the MySQL root password with cPanel &amp; WHM.<\/p>\n<h2><strong>Reset the MySQL Root Password with cPanel &amp; WHM<\/strong><\/h2>\n<p>Let&#8217;s see the steps to change the MySQL root password.<\/p>\n<p>Step 1: Open WHM uisng username and password<\/p>\n<p>Step 2: Navigate to <em>MySQL Root Password\u00a0<\/em>under\u00a0<em>SQL Services\u00a0<\/em>which will be present in the sidebar menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1929\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/password-1-300x238.png\" alt=\"password-1\" width=\"1261\" height=\"999\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/password-1-300x238.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/password-1-1024x811.png 1024w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/password-1-768x608.png 768w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/password-1.png 1261w\" sizes=\"auto, (max-width: 1261px) 100vw, 1261px\" \/><\/p>\n<p>Step 3: Enter a new password in the\u00a0<em>Password\u00a0<\/em>and\u00a0<em>Password[again]\u00a0<\/em>fields.<\/p>\n<ul>\n<li>The password should be long, complex, and difficult to guess. A weak password is also compromised during a brute force or dictionary attack, making a crucial security vulnerability.<\/li>\n<li>The page includes a password strength take a look at, and you should select a password it considers Very Strong. We also have an additionally integrate a Password Generator programmed with default choices to make a secure and hard-to-guess password.<\/li>\n<\/ul>\n<p>Step 4: After checking the strength of password simply click on Change Password button.<\/p>\n<p>We greatly advise that you just change the MySQL root password in WHM and not by interacting with the MySQL service directly.<\/p>\n<h2><strong>Reset MySQL User Account Passwords\u00a0<\/strong><\/h2>\n<p>To Change the password for other MySQL users is also very simple. The server administrator has the rights to edit any MySQL user\u2019s account in WHM whereas the cPanel users has the rights to edit passwords for databases from their account manages.<\/p>\n<h3><strong>Below are the explanation of Changing MySQL User Account Passwords in WHM<\/strong><\/h3>\n<p>Open WHM by using login details and from the sidebar menu select <em>Change MySQL User Password\u00a0<\/em>under\u00a0<em>SQL Services<\/em>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1930\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/password-2-300x238.png\" alt=\"password-2\" width=\"1261\" height=\"999\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/password-2-300x238.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/password-2-1024x811.png 1024w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/password-2-768x608.png 768w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/password-2.png 1261w\" sizes=\"auto, (max-width: 1261px) 100vw, 1261px\" \/><\/p>\n<p>Select the MySQL user from the dropdown menu for which you\u2019d like to edit. Enter the password and confirm the new password. The <em>Change MySQL User Password\u00a0 has a password strength meter and a password generator <\/em>through which you can check password strength and can generate strong password<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The sites hosted on cPanel-managed servers has the MySQL primary database software , as well as WordPress\u00ae and ecommerce applications like Magento. As a result of MySQL has to manage read and write permissions for several different sites and databases, it&#8217;s a multi-user system. Each user account incorporates a set of permissions that limit its [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-1928","post","type-post","status-publish","format-standard","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v15.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Reset the MySQL\u00ae Root Password And MySQL User Passwords - OWS KB<\/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:\/\/ownwebservers.com\/kb\/how-to-reset-the-mysql-root-password-and-mysql-user-passwords\/\" \/>\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\u00ae Root Password And MySQL User Passwords - OWS KB\" \/>\n<meta property=\"og:description\" content=\"The sites hosted on cPanel-managed servers has the MySQL primary database software , as well as WordPress\u00ae and ecommerce applications like Magento. As a result of MySQL has to manage read and write permissions for several different sites and databases, it&#8217;s a multi-user system. Each user account incorporates a set of permissions that limit its [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ownwebservers.com\/kb\/how-to-reset-the-mysql-root-password-and-mysql-user-passwords\/\" \/>\n<meta property=\"og:site_name\" content=\"OWS KB\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-16T05:58:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-16T06:00:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/password-1-300x238.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\">\n\t<meta name=\"twitter:data1\" content=\"admin\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"2 minutes\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"OWS KB\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/ownwebservers.com\/kb\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-reset-the-mysql-root-password-and-mysql-user-passwords\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/password-1.png\",\"width\":1261,\"height\":999,\"caption\":\"password-1\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-reset-the-mysql-root-password-and-mysql-user-passwords\/#webpage\",\"url\":\"https:\/\/ownwebservers.com\/kb\/how-to-reset-the-mysql-root-password-and-mysql-user-passwords\/\",\"name\":\"How To Reset the MySQL\\u00ae Root Password And MySQL User Passwords - OWS KB\",\"isPartOf\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-reset-the-mysql-root-password-and-mysql-user-passwords\/#primaryimage\"},\"datePublished\":\"2021-09-16T05:58:51+00:00\",\"dateModified\":\"2021-09-16T06:00:28+00:00\",\"author\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\"},\"breadcrumb\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-reset-the-mysql-root-password-and-mysql-user-passwords\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ownwebservers.com\/kb\/how-to-reset-the-mysql-root-password-and-mysql-user-passwords\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-reset-the-mysql-root-password-and-mysql-user-passwords\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-reset-the-mysql-root-password-and-mysql-user-passwords\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/how-to-reset-the-mysql-root-password-and-mysql-user-passwords\/\",\"name\":\"How To Reset the MySQL\\u00ae Root Password And MySQL User Passwords\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/ownwebservers.com\/kb\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","_links":{"self":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/1928","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/comments?post=1928"}],"version-history":[{"count":3,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/1928\/revisions"}],"predecessor-version":[{"id":1933,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/1928\/revisions\/1933"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=1928"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=1928"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=1928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}