{"id":3345,"date":"2017-07-24T10:57:23","date_gmt":"2017-07-24T03:57:23","guid":{"rendered":"https:\/\/huongdanjava.com\/?p=3345"},"modified":"2018-03-07T04:18:39","modified_gmt":"2018-03-06T21:18:39","slug":"reset-mysql-root-password-in-macos","status":"publish","type":"post","link":"https:\/\/huongdanjava.com\/reset-mysql-root-password-in-macos.html","title":{"rendered":"Reset MySQL root password in macOS"},"content":{"rendered":"

In this tutorial, I will show you the way to reset MySQL root password in macOS.<\/p>\n

Note: I work with MySQL 5.7.x for this tutorial,<\/p>\n

First of all, we need stop MySQL server using MySQL Start\/Stop Configuration as below:<\/p>\n

\"Reset<\/p>\n

Then, open Terminal and start MySQL server in safe mode:<\/p>\n

sudo mysqld_safe --skip-grant-tables<\/pre>\n
\"Reset<\/p>\n
Next, open other Terminal and try to login with user root without password:<\/p>\n
mysql -u root<\/pre>\n
\"Reset<\/p>\n
Update password for root user by using following command:<\/p>\n
UPDATE mysql.user SET authentication_string=PASSWORD('<enter_your_password_here>') WHERE User='root';<\/pre>\n
Update privileges:<\/p>\n
FLUSH PRIVILEGES;<\/pre>\n
\"Reset<\/p>\n
Now, you can login user root with your password.<\/p>\n
\"Reset<\/p>\n
But right now, if you try to execute any SQL statements, you will get the messages as below:<\/p>\n
\"Reset<\/p>\n
To resolve this message, you must execute again the statement to update the password:<\/p>\n
SET PASSWORD=PASSWORD('enter_your_password_here');<\/pre>\n
\"Reset<\/p>\n
Now, you can execute your statement.<\/p>\n
\"Reset<\/p>\n
 <\/p>\n\n\n
\n            \n
\n    \n
\n            
\n            \n\n
<\/div>\n        <\/div>\n            
\n            \n\n
<\/div>\n        <\/div>\n            
\n            \n\n
<\/div>\n        <\/div>\n            
\n            \n\n
<\/div>\n        <\/div>\n            
\n            \n\n
<\/div>\n        <\/div>\n    <\/div>\n    \n
\n            
\n            \n\n
<\/div>\n        <\/div>\n            
\n            \n\n
<\/div>\n        <\/div>\n            
\n            \n\n
<\/div>\n        <\/div>\n            
\n            \n\n
<\/div>\n        <\/div>\n            
\n            \n\n
<\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n
\n            <\/span>\n    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"
In this tutorial, I will show you the way to reset MySQL root password in macOS. Note: I work with MySQL 5.7.x for this tutorial, First of all, we need stop MySQL server using MySQL Start\/Stop Configuration as below: Then, open Terminal and start MySQL… Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":3357,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[408],"tags":[],"class_list":["post-3345","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql-en","clearfix"],"yoast_head":"\nReset MySQL root password in macOS - Huong Dan Java<\/title>\n<meta name=\"description\" content=\"In this tutorial, I will show you how to reset MySQL root password in macOS.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/huongdanjava.com\/reset-mysql-root-password-in-macos.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reset MySQL root password in macOS - Huong Dan Java\" \/>\n<meta property=\"og:description\" content=\"In this tutorial, I will show you how to reset MySQL root password in macOS.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/huongdanjava.com\/reset-mysql-root-password-in-macos.html\" \/>\n<meta property=\"og:site_name\" content=\"Huong Dan Java\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/nhkhanh2406\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/nhkhanh2406\" \/>\n<meta property=\"article:published_time\" content=\"2017-07-24T03:57:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-03-06T21:18:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/huongdanjava.com\/wp-content\/uploads\/2017\/07\/mysql.png\" \/>\n\t<meta property=\"og:image:width\" content=\"491\" \/>\n\t<meta property=\"og:image:height\" content=\"497\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Khanh Nguyen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/KhanhNguyenJ\" \/>\n<meta name=\"twitter:site\" content=\"@KhanhNguyenJ\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Khanh Nguyen\" \/>\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:\\\/\\\/huongdanjava.com\\\/reset-mysql-root-password-in-macos.html#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/huongdanjava.com\\\/reset-mysql-root-password-in-macos.html\"},\"author\":{\"name\":\"Khanh Nguyen\",\"@id\":\"https:\\\/\\\/huongdanjava.com\\\/#\\\/schema\\\/person\\\/dc859d7f8cbea3b593e6738de9cbb82d\"},\"headline\":\"Reset MySQL root password in macOS\",\"datePublished\":\"2017-07-24T03:57:23+00:00\",\"dateModified\":\"2018-03-06T21:18:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/huongdanjava.com\\\/reset-mysql-root-password-in-macos.html\"},\"wordCount\":128,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/huongdanjava.com\\\/#\\\/schema\\\/person\\\/dc859d7f8cbea3b593e6738de9cbb82d\"},\"image\":{\"@id\":\"https:\\\/\\\/huongdanjava.com\\\/reset-mysql-root-password-in-macos.html#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/huongdanjava.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/mysql.png\",\"articleSection\":[\"MySQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/huongdanjava.com\\\/reset-mysql-root-password-in-macos.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/huongdanjava.com\\\/reset-mysql-root-password-in-macos.html\",\"url\":\"https:\\\/\\\/huongdanjava.com\\\/reset-mysql-root-password-in-macos.html\",\"name\":\"Reset MySQL root password in macOS - Huong Dan Java\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/huongdanjava.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/huongdanjava.com\\\/reset-mysql-root-password-in-macos.html#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/huongdanjava.com\\\/reset-mysql-root-password-in-macos.html#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/huongdanjava.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/mysql.png\",\"datePublished\":\"2017-07-24T03:57:23+00:00\",\"dateModified\":\"2018-03-06T21:18:39+00:00\",\"description\":\"In this tutorial, I will show you how to reset MySQL root password in macOS.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/huongdanjava.com\\\/reset-mysql-root-password-in-macos.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/huongdanjava.com\\\/reset-mysql-root-password-in-macos.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/huongdanjava.com\\\/reset-mysql-root-password-in-macos.html#primaryimage\",\"url\":\"https:\\\/\\\/huongdanjava.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/mysql.png\",\"contentUrl\":\"https:\\\/\\\/huongdanjava.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/mysql.png\",\"width\":491,\"height\":497},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/huongdanjava.com\\\/reset-mysql-root-password-in-macos.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/huongdanjava.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Reset MySQL root password in macOS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/huongdanjava.com\\\/#website\",\"url\":\"https:\\\/\\\/huongdanjava.com\\\/\",\"name\":\"Huong Dan Java\",\"description\":\"Java development tutorials\",\"publisher\":{\"@id\":\"https:\\\/\\\/huongdanjava.com\\\/#\\\/schema\\\/person\\\/dc859d7f8cbea3b593e6738de9cbb82d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/huongdanjava.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/huongdanjava.com\\\/#\\\/schema\\\/person\\\/dc859d7f8cbea3b593e6738de9cbb82d\",\"name\":\"Khanh Nguyen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/huongdanjava.com\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/CC6FAC58-D227-4DD8-93D1-6D6A795577E3_1_201_a.jpeg\",\"url\":\"https:\\\/\\\/huongdanjava.com\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/CC6FAC58-D227-4DD8-93D1-6D6A795577E3_1_201_a.jpeg\",\"contentUrl\":\"https:\\\/\\\/huongdanjava.com\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/CC6FAC58-D227-4DD8-93D1-6D6A795577E3_1_201_a.jpeg\",\"width\":1267,\"height\":1517,\"caption\":\"Khanh Nguyen\"},\"logo\":{\"@id\":\"https:\\\/\\\/huongdanjava.com\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/CC6FAC58-D227-4DD8-93D1-6D6A795577E3_1_201_a.jpeg\"},\"description\":\"I love Java and everything related to Java.\",\"sameAs\":[\"https:\\\/\\\/huongdanjava.com\",\"https:\\\/\\\/www.facebook.com\\\/nhkhanh2406\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/KhanhNguyenJ\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Reset MySQL root password in macOS - Huong Dan Java","description":"In this tutorial, I will show you how to reset MySQL root password in macOS.","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:\/\/huongdanjava.com\/reset-mysql-root-password-in-macos.html","og_locale":"en_US","og_type":"article","og_title":"Reset MySQL root password in macOS - Huong Dan Java","og_description":"In this tutorial, I will show you how to reset MySQL root password in macOS.","og_url":"https:\/\/huongdanjava.com\/reset-mysql-root-password-in-macos.html","og_site_name":"Huong Dan Java","article_publisher":"https:\/\/www.facebook.com\/nhkhanh2406","article_author":"https:\/\/www.facebook.com\/nhkhanh2406","article_published_time":"2017-07-24T03:57:23+00:00","article_modified_time":"2018-03-06T21:18:39+00:00","og_image":[{"width":491,"height":497,"url":"https:\/\/huongdanjava.com\/wp-content\/uploads\/2017\/07\/mysql.png","type":"image\/png"}],"author":"Khanh Nguyen","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/KhanhNguyenJ","twitter_site":"@KhanhNguyenJ","twitter_misc":{"Written by":"Khanh Nguyen","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/huongdanjava.com\/reset-mysql-root-password-in-macos.html#article","isPartOf":{"@id":"https:\/\/huongdanjava.com\/reset-mysql-root-password-in-macos.html"},"author":{"name":"Khanh Nguyen","@id":"https:\/\/huongdanjava.com\/#\/schema\/person\/dc859d7f8cbea3b593e6738de9cbb82d"},"headline":"Reset MySQL root password in macOS","datePublished":"2017-07-24T03:57:23+00:00","dateModified":"2018-03-06T21:18:39+00:00","mainEntityOfPage":{"@id":"https:\/\/huongdanjava.com\/reset-mysql-root-password-in-macos.html"},"wordCount":128,"commentCount":0,"publisher":{"@id":"https:\/\/huongdanjava.com\/#\/schema\/person\/dc859d7f8cbea3b593e6738de9cbb82d"},"image":{"@id":"https:\/\/huongdanjava.com\/reset-mysql-root-password-in-macos.html#primaryimage"},"thumbnailUrl":"https:\/\/huongdanjava.com\/wp-content\/uploads\/2017\/07\/mysql.png","articleSection":["MySQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/huongdanjava.com\/reset-mysql-root-password-in-macos.html#respond"]}]},{"@type":"WebPage","@id":"https:\/\/huongdanjava.com\/reset-mysql-root-password-in-macos.html","url":"https:\/\/huongdanjava.com\/reset-mysql-root-password-in-macos.html","name":"Reset MySQL root password in macOS - Huong Dan Java","isPartOf":{"@id":"https:\/\/huongdanjava.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/huongdanjava.com\/reset-mysql-root-password-in-macos.html#primaryimage"},"image":{"@id":"https:\/\/huongdanjava.com\/reset-mysql-root-password-in-macos.html#primaryimage"},"thumbnailUrl":"https:\/\/huongdanjava.com\/wp-content\/uploads\/2017\/07\/mysql.png","datePublished":"2017-07-24T03:57:23+00:00","dateModified":"2018-03-06T21:18:39+00:00","description":"In this tutorial, I will show you how to reset MySQL root password in macOS.","breadcrumb":{"@id":"https:\/\/huongdanjava.com\/reset-mysql-root-password-in-macos.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/huongdanjava.com\/reset-mysql-root-password-in-macos.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/huongdanjava.com\/reset-mysql-root-password-in-macos.html#primaryimage","url":"https:\/\/huongdanjava.com\/wp-content\/uploads\/2017\/07\/mysql.png","contentUrl":"https:\/\/huongdanjava.com\/wp-content\/uploads\/2017\/07\/mysql.png","width":491,"height":497},{"@type":"BreadcrumbList","@id":"https:\/\/huongdanjava.com\/reset-mysql-root-password-in-macos.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/huongdanjava.com\/"},{"@type":"ListItem","position":2,"name":"Reset MySQL root password in macOS"}]},{"@type":"WebSite","@id":"https:\/\/huongdanjava.com\/#website","url":"https:\/\/huongdanjava.com\/","name":"Huong Dan Java","description":"Java development tutorials","publisher":{"@id":"https:\/\/huongdanjava.com\/#\/schema\/person\/dc859d7f8cbea3b593e6738de9cbb82d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/huongdanjava.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/huongdanjava.com\/#\/schema\/person\/dc859d7f8cbea3b593e6738de9cbb82d","name":"Khanh Nguyen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/huongdanjava.com\/wp-content\/uploads\/2021\/07\/CC6FAC58-D227-4DD8-93D1-6D6A795577E3_1_201_a.jpeg","url":"https:\/\/huongdanjava.com\/wp-content\/uploads\/2021\/07\/CC6FAC58-D227-4DD8-93D1-6D6A795577E3_1_201_a.jpeg","contentUrl":"https:\/\/huongdanjava.com\/wp-content\/uploads\/2021\/07\/CC6FAC58-D227-4DD8-93D1-6D6A795577E3_1_201_a.jpeg","width":1267,"height":1517,"caption":"Khanh Nguyen"},"logo":{"@id":"https:\/\/huongdanjava.com\/wp-content\/uploads\/2021\/07\/CC6FAC58-D227-4DD8-93D1-6D6A795577E3_1_201_a.jpeg"},"description":"I love Java and everything related to Java.","sameAs":["https:\/\/huongdanjava.com","https:\/\/www.facebook.com\/nhkhanh2406","https:\/\/x.com\/https:\/\/twitter.com\/KhanhNguyenJ"]}]}},"_links":{"self":[{"href":"https:\/\/huongdanjava.com\/wp-json\/wp\/v2\/posts\/3345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/huongdanjava.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/huongdanjava.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/huongdanjava.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/huongdanjava.com\/wp-json\/wp\/v2\/comments?post=3345"}],"version-history":[{"count":6,"href":"https:\/\/huongdanjava.com\/wp-json\/wp\/v2\/posts\/3345\/revisions"}],"predecessor-version":[{"id":7373,"href":"https:\/\/huongdanjava.com\/wp-json\/wp\/v2\/posts\/3345\/revisions\/7373"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/huongdanjava.com\/wp-json\/wp\/v2\/media\/3357"}],"wp:attachment":[{"href":"https:\/\/huongdanjava.com\/wp-json\/wp\/v2\/media?parent=3345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/huongdanjava.com\/wp-json\/wp\/v2\/categories?post=3345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/huongdanjava.com\/wp-json\/wp\/v2\/tags?post=3345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}