{"id":86,"date":"2025-11-17T13:22:49","date_gmt":"2025-11-17T13:22:49","guid":{"rendered":"https:\/\/blogs.giamkichsan.com\/?p=86"},"modified":"2025-11-17T13:22:54","modified_gmt":"2025-11-17T13:22:54","slug":"mysql-cach-doi-hoac-reset-mat-khau","status":"publish","type":"post","link":"https:\/\/blogs.giamkichsan.com\/index.php\/2025\/11\/17\/mysql-cach-doi-hoac-reset-mat-khau\/","title":{"rendered":"MYSQL &#8211; C\u00c1CH \u0110\u1ed4I HO\u1eb6C RESET M\u1eacT KH\u1ea8U"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">\ud83d\udd27 <strong>C\u00c1CH RESET M\u1eacT KH\u1ea8U ROOT MYSQL 8<\/strong><\/h1>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>B\u01b0\u1edbc 1: D\u1eebng MySQL<\/strong><\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo systemctl stop mysqld\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>B\u01b0\u1edbc 2: Kh\u1edfi \u0111\u1ed9ng MySQL v\u1edbi ch\u1ebf \u0111\u1ed9 m\u1edf kh\u00f3a (kh\u00f4ng c\u1ea7n m\u1eadt kh\u1ea9u)<\/strong><\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mysqld --skip-grant-tables --skip-networking &amp;\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>--skip-grant-tables<\/code>: b\u1ecf qua ki\u1ec3m tra m\u1eadt kh\u1ea9u<\/li>\n\n\n\n<li><code>--skip-networking<\/code>: tr\u00e1nh truy c\u1eadp t\u1eeb b\u00ean ngo\u00e0i (an to\u00e0n h\u01a1n)<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>B\u01b0\u1edbc 3: \u0110\u0103ng nh\u1eadp v\u00e0o MySQL kh\u00f4ng c\u1ea7n m\u1eadt kh\u1ea9u<\/strong><\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u root\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>B\u01b0\u1edbc 4: L\u00e0m m\u1edbi quy\u1ec1n<\/strong><\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>FLUSH PRIVILEGES;\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>B\u01b0\u1edbc 5: \u0110\u1eb7t m\u1eadt kh\u1ea9u m\u1edbi cho root<\/strong><\/h2>\n\n\n\n<p>MySQL 8 d\u00f9ng <code>ALTER USER<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER USER 'root'@'localhost' IDENTIFIED BY 'MatKhauMoi@123';\n<\/code><\/pre>\n\n\n\n<p>(Nh\u1edb d\u00f9ng m\u1eadt kh\u1ea9u m\u1ea1nh c\u00f3 ch\u1eef hoa \/ ch\u1eef th\u01b0\u1eddng \/ k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t.)<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>B\u01b0\u1edbc 6: Tho\u00e1t MySQL<\/strong><\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>EXIT;\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>B\u01b0\u1edbc 7: T\u1eaft ti\u1ebfn tr\u00ecnh mysqld t\u1ea1m<\/strong><\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo pkill mysqld\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>B\u01b0\u1edbc 8: Kh\u1edfi \u0111\u1ed9ng l\u1ea1i MySQL b\u00ecnh th\u01b0\u1eddng<\/strong><\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo systemctl start mysqld\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>B\u01b0\u1edbc 9: \u0110\u0103ng nh\u1eadp b\u1eb1ng m\u1eadt kh\u1ea9u m\u1edbi<\/strong><\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u root -p<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p>\u0110\u1ec3 \u0111\u1ed5i m\u1eadt kh\u1ea9u <strong>y\u1ebfu<\/strong> v\u1eabn \u0111\u01b0\u1ee3c, b\u1ea1n c\u00f3 v\u00e0i c\u00e1ch.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\ud83d\udd39 <strong>C\u00e1ch 1 \u2013 Thay \u0111\u1ed5i m\u1eadt kh\u1ea9u v\u1edbi plugin mysql_native_password<\/strong><\/h1>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u0110\u0103ng nh\u1eadp MySQL:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u root -p\n<\/code><\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>Ch\u1ea1y l\u1ec7nh sau (thay <code>password123<\/code> b\u1eb1ng m\u1eadt kh\u1ea9u y\u1ebfu b\u1ea1n mu\u1ed1n):<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password123';\nFLUSH PRIVILEGES;\n<\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><code>mysql_native_password<\/code> b\u1ecf ki\u1ec3m tra \u0111\u1ed9 m\u1ea1nh m\u1eadt kh\u1ea9u.<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\ud83d\udd39 <strong>C\u00e1ch 2 \u2013 T\u1ea1m t\u1eaft validate_password plugin<\/strong><\/h1>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Ki\u1ec3m tra plugin validate_password:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW VARIABLES LIKE 'validate_password%';\n<\/code><\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>T\u1eaft plugin t\u1ea1m th\u1eddi:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>UNINSTALL PLUGIN validate_password;\n<\/code><\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Sau \u0111\u00f3 \u0111\u1ed5i m\u1eadt kh\u1ea9u b\u00ecnh th\u01b0\u1eddng:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER USER 'root'@'localhost' IDENTIFIED BY 'password123';\nFLUSH PRIVILEGES;\n<\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>Sau khi \u0111\u1ed5i xong, b\u1ea1n c\u00f3 th\u1ec3 c\u00e0i l\u1ea1i plugin n\u1ebfu mu\u1ed1n.<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\ud83d\udd39 <strong>C\u00e1ch 3 \u2013 Thay \u0111\u1ed5i ch\u00ednh s\u00e1ch cho ph\u00e9p m\u1eadt kh\u1ea9u y\u1ebfu<\/strong><\/h1>\n\n\n\n<p>N\u1ebfu mu\u1ed1n gi\u1eef plugin, nh\u01b0ng gi\u1ea3m ch\u00ednh s\u00e1ch:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SET GLOBAL validate_password.length = 4;\nSET GLOBAL validate_password.policy = LOW;\nALTER USER 'root'@'localhost' IDENTIFIED BY '1234';\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>policy = LOW<\/code> \u2192 ch\u1ec9 y\u00eau c\u1ea7u t\u1ed1i thi\u1ec3u 4 k\u00fd t\u1ef1<\/li>\n\n\n\n<li><code>policy = MEDIUM<\/code> \u2192 8 k\u00fd t\u1ef1, ph\u1ea3i c\u00f3 ch\u1eef + s\u1ed1 + k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t<\/li>\n\n\n\n<li><code>policy = STRONG<\/code> \u2192 8 k\u00fd t\u1ef1, ch\u1eef hoa + ch\u1eef th\u01b0\u1eddng + s\u1ed1 + k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>\ud83d\udd27 C\u00c1CH RESET M\u1eacT KH\u1ea8U ROOT MYSQL 8 B\u01b0\u1edbc 1: D\u1eebng MySQL B\u01b0\u1edbc 2: Kh\u1edfi \u0111\u1ed9ng MySQL v\u1edbi ch\u1ebf \u0111\u1ed9 m\u1edf kh\u00f3a (kh\u00f4ng c\u1ea7n m\u1eadt <a class=\"mh-excerpt-more\" href=\"https:\/\/blogs.giamkichsan.com\/index.php\/2025\/11\/17\/mysql-cach-doi-hoac-reset-mat-khau\/\" title=\"MYSQL &#8211; C\u00c1CH \u0110\u1ed4I HO\u1eb6C RESET M\u1eacT KH\u1ea8U\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-86","post","type-post","status-publish","format-standard","hentry","category-mysql-he-quan-tri-co-so-du-lieu"],"_links":{"self":[{"href":"https:\/\/blogs.giamkichsan.com\/index.php\/wp-json\/wp\/v2\/posts\/86","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.giamkichsan.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.giamkichsan.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.giamkichsan.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.giamkichsan.com\/index.php\/wp-json\/wp\/v2\/comments?post=86"}],"version-history":[{"count":1,"href":"https:\/\/blogs.giamkichsan.com\/index.php\/wp-json\/wp\/v2\/posts\/86\/revisions"}],"predecessor-version":[{"id":87,"href":"https:\/\/blogs.giamkichsan.com\/index.php\/wp-json\/wp\/v2\/posts\/86\/revisions\/87"}],"wp:attachment":[{"href":"https:\/\/blogs.giamkichsan.com\/index.php\/wp-json\/wp\/v2\/media?parent=86"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.giamkichsan.com\/index.php\/wp-json\/wp\/v2\/categories?post=86"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.giamkichsan.com\/index.php\/wp-json\/wp\/v2\/tags?post=86"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}