{"id":447,"date":"2011-04-25T12:12:51","date_gmt":"2011-04-25T12:12:51","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=447"},"modified":"2023-12-29T05:20:40","modified_gmt":"2023-12-29T12:20:40","slug":"change-mysql-user-password","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-administration\/change-mysql-user-password\/","title":{"rendered":"How to Change MySQL User Password"},"content":{"rendered":"\n<p><strong>Summary<\/strong>: in this tutorial, you will learn how to change MySQL user password using the <code>ALTER USER<\/code> statement.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignright\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"161\" src=\"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2011\/04\/mysql-change-password-300x161.jpg\" alt=\"How To Change MySQL User Password\" class=\"wp-image-5385\" title=\"How To Change MySQL User Password\" srcset=\"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2011\/04\/mysql-change-password-300x161.jpg 300w, https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2011\/04\/mysql-change-password.jpg 500w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/figure>\n<\/div>\n\n\n<p>Before changing the password for a\u00a0<a href=\"https:\/\/www.mysqltutorial.org\/mysql-administration\/mysql-create-user\/\">MySQL user<\/a>\u00a0account, it&#8217;s essential to consider the following important questions:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Which user account do you want to change the password for?<\/li>\n\n\n\n<li>What application is using the user account whose password is being changed? If you change the password without changing the connection string of the application using the user account, the application may no longer be able to connect to the MySQL server.<\/li>\n<\/ul>\n\n\n\n<p>Once you have these questions answered, you can start proceeding with changing the MySQL user&#8217;s password.<\/p>\n\n\n\n<p>To change the password for a MySQL user, you use the <code>ALTER USER ... IDENTIFIED BY<\/code> statement:<\/p>\n\n\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">ALTER USER username\nIDENTIFIED BY new_password;<\/code><\/span><\/pre>\n\n\n<p>In this statement:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, specify the username after the <code>ALTER USER<\/code> keywords.<\/li>\n\n\n\n<li>Second, provide the new password after the <code>IDENTIFIED BY<\/code> keywords.<\/li>\n<\/ul>\n\n\n\n<p>To execute the statement, you need to have an account with has global <code>CREATE USER<\/code> privilege or the <code>UPDATE<\/code> privilege for the <code>mysql<\/code> system database.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Changing MySQL User Password Example<\/h2>\n\n\n\n<p>First, open the Command Prompt on Windows or Terminal on Unix-like systems and log into the MySQL server:<\/p>\n\n\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">mysql -u root -p<\/code><\/span><\/pre>\n\n\n<p>Second, create a new user called <code>dolphin<\/code> for demonstration:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\"><span class=\"hljs-selector-tag\">CREATE<\/span> <span class=\"hljs-selector-tag\">USER<\/span> <span class=\"hljs-selector-tag\">dolphin<\/span><span class=\"hljs-keyword\">@localhost<\/span>\nIDENTIFIED BY <span class=\"hljs-string\">'abcd1234'<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Third, change the password of the <code>dolphin<\/code> user using the ALTER TABLE &#8230; IDENTIFIED BY statement:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\"><span class=\"hljs-selector-tag\">ALTER<\/span> <span class=\"hljs-selector-tag\">USER<\/span> <span class=\"hljs-selector-tag\">dolphin<\/span><span class=\"hljs-keyword\">@localhost<\/span>\nIDENTIFIED BY <span class=\"hljs-string\">'qDvOD3@L10'<\/span>; <span class=\"hljs-selector-tag\">--<\/span> <span class=\"hljs-selector-tag\">new<\/span> <span class=\"hljs-selector-tag\">password<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h2 class=\"wp-block-heading\">Summary<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use the <code>ALTER USER ... IDENTIFIED BY<\/code> statement to change the password of a MySQL user<\/li>\n<\/ul>\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful? <\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"447\"\n\t\t\t\tdata-post-url=\"https:\/\/www.mysqltutorial.org\/mysql-administration\/change-mysql-user-password\/\"\n\t\t\t\tdata-post-title=\"How to Change MySQL User Password\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"447\"\n\t\t\t\tdata-post-url=\"https:\/\/www.mysqltutorial.org\/mysql-administration\/change-mysql-user-password\/\"\n\t\t\t\tdata-post-title=\"How to Change MySQL User Password\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial you will learn how to change or reset password for MySQL account in various ways by using the UPDATE, SET PASSWORD and GRANT statements.<\/p>\n","protected":false},"author":2,"featured_media":5387,"parent":441,"menu_order":36,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-447","page","type-page","status-publish","has-post-thumbnail","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Change MySQL User Password<\/title>\n<meta name=\"description\" content=\"In this tutorial, you will learn how to change MySQL user password by using the ALTER TABLE ... IDENTIFIED BY statement.\" \/>\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.mysqltutorial.org\/mysql-administration\/change-mysql-user-password\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Change MySQL User Password\" \/>\n<meta property=\"og:description\" content=\"In this tutorial, you will learn how to change MySQL user password by using the ALTER TABLE ... IDENTIFIED BY statement.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mysqltutorial.org\/mysql-administration\/change-mysql-user-password\/\" \/>\n<meta property=\"og:site_name\" content=\"MySQL Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-29T12:20:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2011\/04\/mysql-change-password-statements.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"150\" \/>\n\t<meta property=\"og:image:height\" content=\"104\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-administration\\\/change-mysql-user-password\\\/\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-administration\\\/change-mysql-user-password\\\/\",\"name\":\"How to Change MySQL User Password\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-administration\\\/change-mysql-user-password\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-administration\\\/change-mysql-user-password\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mysqltutorial.org\\\/wp-content\\\/uploads\\\/2011\\\/04\\\/mysql-change-password-statements.jpg\",\"datePublished\":\"2011-04-25T12:12:51+00:00\",\"dateModified\":\"2023-12-29T12:20:40+00:00\",\"description\":\"In this tutorial, you will learn how to change MySQL user password by using the ALTER TABLE ... IDENTIFIED BY statement.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-administration\\\/change-mysql-user-password\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-administration\\\/change-mysql-user-password\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-administration\\\/change-mysql-user-password\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/wp-content\\\/uploads\\\/2011\\\/04\\\/mysql-change-password-statements.jpg\",\"contentUrl\":\"https:\\\/\\\/www.mysqltutorial.org\\\/wp-content\\\/uploads\\\/2011\\\/04\\\/mysql-change-password-statements.jpg\",\"width\":150,\"height\":104},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-administration\\\/change-mysql-user-password\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.mysqltutorial.org\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Administration\",\"item\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-administration\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Change MySQL User Password\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/#website\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/\",\"name\":\"MySQL Tutorial\",\"description\":\"A comprehensive MySQL Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mysqltutorial.org\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Change MySQL User Password","description":"In this tutorial, you will learn how to change MySQL user password by using the ALTER TABLE ... IDENTIFIED BY statement.","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.mysqltutorial.org\/mysql-administration\/change-mysql-user-password\/","og_locale":"en_US","og_type":"article","og_title":"How to Change MySQL User Password","og_description":"In this tutorial, you will learn how to change MySQL user password by using the ALTER TABLE ... IDENTIFIED BY statement.","og_url":"https:\/\/www.mysqltutorial.org\/mysql-administration\/change-mysql-user-password\/","og_site_name":"MySQL Tutorial","article_modified_time":"2023-12-29T12:20:40+00:00","og_image":[{"width":150,"height":104,"url":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2011\/04\/mysql-change-password-statements.jpg","type":"image\/jpeg"}],"twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.mysqltutorial.org\/mysql-administration\/change-mysql-user-password\/","url":"https:\/\/www.mysqltutorial.org\/mysql-administration\/change-mysql-user-password\/","name":"How to Change MySQL User Password","isPartOf":{"@id":"https:\/\/www.mysqltutorial.org\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-administration\/change-mysql-user-password\/#primaryimage"},"image":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-administration\/change-mysql-user-password\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2011\/04\/mysql-change-password-statements.jpg","datePublished":"2011-04-25T12:12:51+00:00","dateModified":"2023-12-29T12:20:40+00:00","description":"In this tutorial, you will learn how to change MySQL user password by using the ALTER TABLE ... IDENTIFIED BY statement.","breadcrumb":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-administration\/change-mysql-user-password\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mysqltutorial.org\/mysql-administration\/change-mysql-user-password\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mysqltutorial.org\/mysql-administration\/change-mysql-user-password\/#primaryimage","url":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2011\/04\/mysql-change-password-statements.jpg","contentUrl":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2011\/04\/mysql-change-password-statements.jpg","width":150,"height":104},{"@type":"BreadcrumbList","@id":"https:\/\/www.mysqltutorial.org\/mysql-administration\/change-mysql-user-password\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mysqltutorial.org\/"},{"@type":"ListItem","position":2,"name":"MySQL Administration","item":"https:\/\/www.mysqltutorial.org\/mysql-administration\/"},{"@type":"ListItem","position":3,"name":"How to Change MySQL User Password"}]},{"@type":"WebSite","@id":"https:\/\/www.mysqltutorial.org\/#website","url":"https:\/\/www.mysqltutorial.org\/","name":"MySQL Tutorial","description":"A comprehensive MySQL Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mysqltutorial.org\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/447","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/comments?post=447"}],"version-history":[{"count":5,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/447\/revisions"}],"predecessor-version":[{"id":13563,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/447\/revisions\/13563"}],"up":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/441"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/media\/5387"}],"wp:attachment":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/media?parent=447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}