{"id":7077,"date":"2020-01-21T10:05:52","date_gmt":"2020-01-21T10:05:52","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=7077"},"modified":"2020-01-21T10:08:07","modified_gmt":"2020-01-21T10:08:07","slug":"how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/","title":{"rendered":"How to Resolve \u201cMySQL passwords do not work after upgrade\u201d Error?"},"content":{"rendered":"

In this article, you will learn to resolve the problem that occurs after a server is upgraded to MySQL 5.6.5 or later.<\/p>\n

In case you don\u2019t know which MySQL version is installed on your server, follow these steps:<\/strong><\/p>\n

    \n
  1. Log in to cPanel.<\/li>\n
  2. Go to the right sidebar of the cPanel home screen, under General Information, click Server Information.<\/li>\n
  3. Under Server Information, locate the MySQL Version row to check the MySQL version installed on the server.<\/li>\n<\/ol>\n

    Problem<\/strong><\/p>\n

    When accessing a database on the server running MySQL 5.6.5 or later, the login fails even if you have been using the correct username and password.<\/p>\n

    For instance, while running WordPress on your site, you see the below error message:<\/p>\n

    Error establishing a database connection<\/pre>\n
    Also with other web applications, similar messages may get displayed about database connection errors.<\/p>\n
    Cause<\/strong><\/p>\n
    The cause of this issue is the use of a new hashtag method for user passwords by MySQL 5.6.5. The further MySQL versions don\u2019t support the hash method, used in older versions of MySQL to store passwords and so the logins fail.<\/p>\n
    Resolution<\/strong><\/p>\n
    For resolving this issue, you should delete and recreate the database user. While doing this, the new hash method is used by MySQL to store the password, and the database user can log in again.<\/p>\n
    To do this, follow the below steps:<\/p>\n
      \n
    1. Log in to your cPanel account.<\/li>\n
    2. Go to the Databases<\/strong> section of the cPanel home screen and click on MySQL\u00ae Databases<\/strong>.
      \n\"\"<\/li>\n
    3. Then locate the database user that you want to recreate under Current Users<\/strong> and click Delete<\/strong>.
      \n\"\"<\/li>\n
    4. In order to confirm the deletion, click Delete User<\/strong> and then click on Go Back<\/strong>.
      \n\"\"<\/li>\n
    5. Under Add New User<\/strong>, in the Username<\/strong> text box, type the username of the user you deleted just now.
      \n\"\"<\/li>\n
    6. In the Password<\/strong> text box, type the user password.
      \nNote:<\/strong> There is no need to create a new password for the user. The previous password can be used, if you want to keep the password unchanged. For finding the current password, check your application’s configuration files. For example, for WordPress, you will need to check the wp-config.php file for database configuration information.<\/li>\n
    7. Retype the user password in the Password (Again)<\/strong> text box.
      \nNote:<\/strong> As an alternative, you can click Password Generator<\/strong> and cPanel will generate a random, strong password for you.<\/li>\n
    8. Now click on Create User<\/strong>. cPanel creates the database user with the new hashing method to store the password.<\/li>\n<\/ol>\n
      In this way, you can resolve the error “Error establishing a database connection”<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"
      In this article, you will learn to resolve the problem that occurs after a server is upgraded to MySQL 5.6.5 or later. In case you don\u2019t know which MySQL version is installed on your server, follow these steps: Log in to cPanel. Go to the right sidebar of the cPanel home screen, under General Information, […]<\/p>\n","protected":false},"author":16,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[947],"tags":[205,1224,1223,1222],"class_list":["post-7077","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-mysql","tag-mysql","tag-mysql-passwords","tag-mysql-passwords-do-not-work-after-upgrade","tag-resolve-mysql-passwords-error"],"yoast_head":"\nHow to Resolve \u201cMySQL passwords do not work after upgrade\u201d Error?<\/title>\n<meta name=\"description\" content=\"The article reveals steps to resolve the "MySQL passwords do not work after upgrade\u201d error.\" \/>\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.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Resolve \u201cMySQL passwords do not work after upgrade\u201d Error?\" \/>\n<meta property=\"og:description\" content=\"The article reveals steps to resolve the "MySQL passwords do not work after upgrade\u201d error.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-21T10:05:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-21T10:08:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/01\/cpanel-database-min-1.png\" \/>\n<meta name=\"author\" content=\"Pallavi Godse\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pallavi Godse\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated 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\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/\",\"name\":\"How to Resolve \u201cMySQL passwords do not work after upgrade\u201d Error?\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/01\/cpanel-database-min-1.png\",\"datePublished\":\"2020-01-21T10:05:52+00:00\",\"dateModified\":\"2020-01-21T10:08:07+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945\"},\"description\":\"The article reveals steps to resolve the \\\"MySQL passwords do not work after upgrade\u201d error.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Resolve \u201cMySQL passwords do not work after upgrade\u201d Error?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945\",\"name\":\"Pallavi Godse\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g\",\"caption\":\"Pallavi Godse\"},\"description\":\"Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/pallavi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Resolve \u201cMySQL passwords do not work after upgrade\u201d Error?","description":"The article reveals steps to resolve the \"MySQL passwords do not work after upgrade\u201d error.","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.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/","og_locale":"en_GB","og_type":"article","og_title":"How to Resolve \u201cMySQL passwords do not work after upgrade\u201d Error?","og_description":"The article reveals steps to resolve the \"MySQL passwords do not work after upgrade\u201d error.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2020-01-21T10:05:52+00:00","article_modified_time":"2020-01-21T10:08:07+00:00","og_image":[{"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/01\/cpanel-database-min-1.png","type":"","width":"","height":""}],"author":"Pallavi Godse","twitter_misc":{"Written by":"Pallavi Godse","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/","name":"How to Resolve \u201cMySQL passwords do not work after upgrade\u201d Error?","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/01\/cpanel-database-min-1.png","datePublished":"2020-01-21T10:05:52+00:00","dateModified":"2020-01-21T10:08:07+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945"},"description":"The article reveals steps to resolve the \"MySQL passwords do not work after upgrade\u201d error.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How to Resolve \u201cMySQL passwords do not work after upgrade\u201d Error?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945","name":"Pallavi Godse","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g","caption":"Pallavi Godse"},"description":"Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/pallavi\/"}]}},"views":552,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/7077","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=7077"}],"version-history":[{"count":1,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/7077\/revisions"}],"predecessor-version":[{"id":7078,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/7077\/revisions\/7078"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=7077"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=7077"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=7077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}