{"id":2034,"date":"2025-07-01T14:00:34","date_gmt":"2025-07-01T07:00:34","guid":{"rendered":"https:\/\/idc.metaserv.vn\/?p=2034"},"modified":"2025-07-10T16:01:01","modified_gmt":"2025-07-10T09:01:01","slug":"thiet-lap-khoi-phuc-mat-khau-root-mysql","status":"publish","type":"post","link":"https:\/\/idc.metaserv.vn\/en\/2025\/07\/01\/thiet-lap-khoi-phuc-mat-khau-root-mysql\/","title":{"rendered":"C\u00e1ch thi\u1ebft l\u1eadp, thay \u0111\u1ed5i v\u00e0 kh\u00f4i ph\u1ee5c m\u1eadt kh\u1ea9u root MySQL c\u1ee7a b\u1ea1n"},"content":{"rendered":"

N\u1ebfu b\u1ea1n ch\u01b0a bao gi\u1edd \u0111\u1eb7t, qu\u00ean ho\u1eb7c thay \u0111\u1ed5i m\u1eadt kh\u1ea9u MySQL, b\u1ea1n th\u1eadt may m\u1eafn. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1c b\u01b0\u1edbc n\u00e0y, do \u0111\u00f3 b\u1ea1n s\u1ebd kh\u00f4ng bao gi\u1edd ph\u1ea3i m\u1ea5t m\u1eadt kh\u1ea9u ng\u01b0\u1eddi d\u00f9ng root c\u01a1 s\u1edf d\u1eef li\u1ec7u \u0111\u00f3.<\/p>\n\n\n\n

B\u1ea1n c\u00f3 th\u1ec3 c\u00f3 MySQL \u0111ang ch\u1ea1y \u1edf \u0111\u00e2u \u0111\u00f3 trong trung t\u00e2m d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh. N\u1ebfu \u0111\u00fang nh\u01b0 v\u1eady, c\u00f3 th\u1ec3 c\u00f3 l\u00fac b\u1ea1n c\u1ea7n \u0111\u1eb7t ho\u1eb7c thay \u0111\u1ed5i m\u1eadt kh\u1ea9u ng\u01b0\u1eddi d\u00f9ng root. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 x\u1ea3y ra khi b\u1ea1n qu\u00ean m\u1eadt kh\u1ea9u ho\u1eb7c khi b\u1ea1n mu\u1ed1n \u0111\u1eb7t l\u1ea1i m\u1eadt kh\u1ea9u.<\/p>\n\n\n\n

Qu\u00e1 tr\u00ecnh n\u00e0y \u0111\u01b0\u1ee3c x\u1eed l\u00fd ho\u00e0n to\u00e0n th\u00f4ng qua d\u00f2ng l\u1ec7nh v\u00e0 ho\u1ea1t \u0111\u1ed9ng v\u1edbi c\u1ea3 c\u00e0i \u0111\u1eb7t MySQL ho\u1eb7c MariaDB. B\u1ea3n ph\u00e2n ph\u1ed1i Linux \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00f4ng quan tr\u1ecdng mi\u1ec5n l\u00e0 b\u1ea1n c\u00f3 quy\u1ec1n truy c\u1eadp qu\u1ea3n tr\u1ecb th\u00f4ng qua su<\/em> ho\u1eb7c sudo<\/em>.<\/p>\n\n\n\n

C\u00e1ch thi\u1ebft l\u1eadp m\u1eadt kh\u1ea9u MySQL l\u1ea7n \u0111\u1ea7u ti\u00ean<\/h2>\n\n\n\n

Xin l\u01b0u \u00fd r\u1eb1ng t\u00f4i s\u1ebd nh\u1eafc \u0111\u1ebfn MySQL v\u1edbi \u00fd t\u01b0\u1edfng r\u1eb1ng m\u1ecdi th\u1ee9 \u0111\u1ec1u c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng v\u1edbi c\u1ea3 MySQL v\u00e0 MariaDB.<\/p>\n\n\n\n

Th\u00f4ng th\u01b0\u1eddng, trong qu\u00e1 tr\u00ecnh c\u00e0i \u0111\u1eb7t MySQL v\u00e0 MariaDB, b\u1ea1n \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u \u0111\u1eb7t m\u1eadt kh\u1ea9u ban \u0111\u1ea7u. N\u1ebfu kh\u00f4ng, b\u1ea1n s\u1ebd c\u1ea7n \u0111\u1eb7t m\u1eadt kh\u1ea9u l\u1ea7n \u0111\u1ea7u ti\u00ean. \u0110\u1ec3 th\u1ef1c hi\u1ec7n, h\u00e3y m\u1edf c\u1eeda s\u1ed5 terminal v\u00e0 \u0111\u01b0a ra l\u1ec7nh sau:<\/p>\n\n\n\n

mysqladmin -u root password NEWPASSWORD<\/em><\/p>\n\n\n\n

Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, NEWPASSWORD<\/em> l\u00e0 m\u1eadt kh\u1ea9u gi\u1eef ch\u1ed7. Ti\u1ebfp theo, khi b\u1ea1n \u0111\u0103ng nh\u1eadp v\u00e0o MySQL b\u1eb1ng l\u1ec7nh mysql -u root -p<\/em>, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c nh\u1eafc nh\u1eadp m\u1eadt kh\u1ea9u m\u1edbi \u0111\u01b0\u1ee3c c\u1ea5u h\u00ecnh.<\/p>\n\n\n\n

M\u1ed9t ph\u01b0\u01a1ng ph\u00e1p thay th\u1ebf \u0111\u1ec3 thi\u1ebft l\u1eadp m\u1eadt kh\u1ea9u root l\u1ea7n \u0111\u1ea7u ti\u00ean – gi\u00fap t\u0103ng th\u00eam m\u1ed9t ch\u00fat b\u1ea3o m\u1eadt cho c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL c\u1ee7a b\u1ea1n – l\u00e0 s\u1eed d\u1ee5ng mysql_secure_connection<\/em>. L\u1ec7nh n\u00e0y s\u1ebd thi\u1ebft l\u1eadp m\u1eadt kh\u1ea9u ng\u01b0\u1eddi d\u00f9ng root v\u00e0 cho ph\u00e9p b\u1ea1n x\u00f3a ng\u01b0\u1eddi d\u00f9ng \u1ea9n danh, kh\u00f4ng cho ph\u00e9p \u0111\u0103ng nh\u1eadp root t\u1eeb xa v\u00e0 x\u00f3a c\u01a1 s\u1edf d\u1eef li\u1ec7u th\u1eed nghi\u1ec7m. \u0110\u1ec3 s\u1eed d\u1ee5ng l\u1ec7nh n\u00e0y, ch\u1ec9 c\u1ea7n nh\u1eadp:<\/p>\n\n\n\n

mysql_secure_connection<\/em><\/p>\n\n\n\n

Tr\u1ea3 l\u1eddi c\u00e1c c\u00e2u h\u1ecfi \u0111\u01b0\u1ee3c \u0111\u01b0a ra v\u00e0 m\u1eadt kh\u1ea9u c\u1ee7a b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp, gi\u00fap c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n an to\u00e0n h\u01a1n.<\/p>\n\n\n\n

C\u00e1ch thay \u0111\u1ed5i m\u1eadt kh\u1ea9u ng\u01b0\u1eddi d\u00f9ng root MySQL<\/h2>\n\n\n\n

\u0110\u1ec3 \u0111\u1eb7t l\u1ea1i m\u1eadt kh\u1ea9u cho MySQL, tr\u01b0\u1edbc ti\u00ean b\u1ea1n ph\u1ea3i t\u1ea1o m\u1ed9t t\u1ec7p m\u1edbi c\u00f3 n\u1ed9i dung sau:<\/p>\n\n\n\n

ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘PASSWORD’;<\/em><\/p>\n\n\n\n

PASSWORD<\/em> l\u00e0 m\u1eadt kh\u1ea9u m\u1edbi s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng. L\u01b0u t\u1ec7p \u0111\u00f3 d\u01b0\u1edbi d\u1ea1ng ~\/mysql-pwd.<\/em><\/p>\n\n\n\n

Ti\u1ebfp theo, d\u1eebng daemon MySQL b\u1eb1ng l\u1ec7nh:<\/p>\n\n\n\n

sudo systemctl stop mysql<\/em><\/p>\n\n\n\n

Sau khi daemon \u0111\u00e3 d\u1eebng, h\u00e3y \u0111\u01b0a ra l\u1ec7nh:<\/p>\n\n\n\n

sudo mysqld -init-file=~\/mysql-pwd<\/em><\/p>\n\n\n\n

Khi d\u1ea5u nh\u1eafc l\u1ec7nh xu\u1ea5t hi\u1ec7n, h\u00e3y kh\u1edfi \u0111\u1ed9ng l\u1ea1i daemon MySQL b\u1eb1ng l\u1ec7nh:<\/p>\n\n\n\n

sudo systemctl start mysql<\/em><\/p>\n\n\n\n

B\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 \u0111\u0103ng nh\u1eadp v\u00e0o d\u1ea5u nh\u1eafc l\u1ec7nh MySQL b\u1eb1ng m\u1eadt kh\u1ea9u qu\u1ea3n tr\u1ecb vi\u00ean m\u1edbi nh\u01b0 sau:<\/p>\n\n\n\n

mysql -u root -p<\/em><\/p>\n\n\n\n

Khi \u0111\u01b0\u1ee3c nh\u1eafc, h\u00e3y nh\u1eadp m\u1eadt kh\u1ea9u qu\u1ea3n tr\u1ecb vi\u00ean v\u00e0 b\u1ea1n \u0111\u00e3 s\u1eb5n s\u00e0ng.<\/p>\n\n\n\n

C\u00e1ch thay \u0111\u1ed5i m\u1eadt kh\u1ea9u ng\u01b0\u1eddi d\u00f9ng MySQL<\/h2>\n\n\n\n

\u0110\u1ec3 thay \u0111\u1ed5i m\u1eadt kh\u1ea9u c\u1ee7a ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng ph\u1ea3i root, sau khi \u0111\u0103ng nh\u1eadp, h\u00e3y ch\u1ea1y truy v\u1ea5n sau:<\/p>\n\n\n\n

ALTER USER \u2018username\u2019@\u2018host\u2019 IDENTIFIED BY \u2018PASSWORD\u2019;<\/em><\/p>\n\n\n\n

username<\/em> T\u00ean ng\u01b0\u1eddi d\u00f9ng MySQL l\u00e0 g\u00ec , host<\/em> m\u00e1y ch\u1ee7 m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 k\u1ebft n\u1ed1i l\u00e0 g\u00ec v\u00e0 PASSWORD<\/em> m\u1eadt kh\u1ea9u m\u1edbi l\u00e0 g\u00ec.<\/p>\n\n\n\n

Sau \u0111\u00f3 \u00e1p d\u1ee5ng c\u00e1c thay \u0111\u1ed5i b\u1eb1ng c\u00e1ch ch\u1ea1y l\u1ec7nh:<\/p>\n\n\n\n

FLUSH PRIVILEGES;<\/em><\/p>\n\n\n\n

L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 kh\u00f4i ph\u1ee5c m\u1eadt kh\u1ea9u MySQL c\u1ee7a b\u1ea1n<\/h2>\n\n\n\n

N\u1ebfu b\u1ea1n qu\u00ean m\u1eadt kh\u1ea9u ng\u01b0\u1eddi d\u00f9ng root MySQL th\u00ec sao? \u0110\u1ec3 kh\u00f4i ph\u1ee5c m\u1eadt kh\u1ea9u, b\u1ea1n ch\u1ec9 c\u1ea7n l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n\n\n\n

D\u1eebng ti\u1ebfn tr\u00ecnh m\u00e1y ch\u1ee7 MySQL b\u1eb1ng l\u1ec7nh sudo service mysql stop<\/em><\/p>\n\n\n\n

Kh\u1edfi \u0111\u1ed9ng m\u00e1y ch\u1ee7 MySQL b\u1eb1ng l\u1ec7nh sudo mysqld_safe \u2013skip-grant-tables \u2013skip-networking &amp;<\/em><\/p>\n\n\n\n

K\u1ebft n\u1ed1i v\u1edbi m\u00e1y ch\u1ee7 MySQL v\u1edbi t\u01b0 c\u00e1ch l\u00e0 ng\u01b0\u1eddi d\u00f9ng root b\u1eb1ng l\u1ec7nh mysql -u root<\/em><\/p>\n\n\n\n

T\u1ea1i th\u1eddi \u0111i\u1ec3m n\u00e0y, b\u1ea1n c\u1ea7n ph\u1ea3i th\u1ef1c hi\u1ec7n c\u00e1c l\u1ec7nh MySQL sau \u0111\u1ec3 \u0111\u1eb7t l\u1ea1i m\u1eadt kh\u1ea9u root:<\/p>\n\n\n\n

mysql> use mysql;<\/em><\/p>\n\n\n\n

\u008bmysql> update user set authentication_string=password(‘NEWPASSWORD’) where user=’root’;<\/em><\/p>\n\n\n\n

\u008bmysql> flush privileges;<\/em><\/p>\n\n\n\n

\u008bmysql> quit<\/em><\/p>\n\n\n\n

NEWPASSWORD<\/em> M\u1eadt kh\u1ea9u m\u1edbi s\u1ebd s\u1eed d\u1ee5ng \u1edf \u0111\u00e2u?<\/p>\n\n\n\n

Kh\u1edfi \u0111\u1ed9ng l\u1ea1i daemon MySQL b\u1eb1ng l\u1ec7nh sudo service mysql restart<\/em>. B\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 \u0111\u0103ng nh\u1eadp v\u00e0o MySQL b\u1eb1ng m\u1eadt kh\u1ea9u m\u1edbi.<\/p>\n\n\n\n

V\u00e0 th\u1ebf l\u00e0 xong. B\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp, \u0111\u1eb7t l\u1ea1i v\u00e0 kh\u00f4i ph\u1ee5c m\u1eadt kh\u1ea9u MySQL c\u1ee7a m\u00ecnh.<\/p>\n\n\n\n

C\u00e1ch hi\u1ec3n th\u1ecb ng\u01b0\u1eddi d\u00f9ng v\u00e0 m\u1eadt kh\u1ea9u MySQL<\/h2>\n\n\n\n

Th\u1ec9nh tho\u1ea3ng, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n t\u1ea1o danh s\u00e1ch ng\u01b0\u1eddi d\u00f9ng v\u00e0 m\u1eadt kh\u1ea9u MySQL \u0111\u1ec3 ki\u1ec3m tra ho\u1eb7c sao l\u01b0u th\u00f4ng tin x\u00e1c th\u1ef1c. B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y b\u1eb1ng c\u00e1ch truy v\u1ea5n b\u1ea3ng mysql.user<\/em>, nh\u01b0ng l\u01b0u \u00fd r\u1eb1ng m\u1eadt kh\u1ea9u \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef \u1edf \u0111\u1ecbnh d\u1ea1ng hashed, do \u0111\u00f3 kh\u00f4ng th\u1ec3 truy xu\u1ea5t tr\u1ef1c ti\u1ebfp d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n thu\u1ea7n t\u00fay.<\/p>\n\n\n\n

Ch\u1ea1y truy v\u1ea5n sau \u0111\u1ec3 l\u1ea5y c\u00e1c c\u1ed9t ng\u01b0\u1eddi d\u00f9ng v\u00e0 m\u1eadt kh\u1ea9u:<\/p>\n\n\n\n

SELECT User, Host, authentication_string FROM mysql.user;<\/em><\/p>\n\n\n\n

Trong \u0111\u00f3 User<\/em> t\u00ean ng\u01b0\u1eddi d\u00f9ng MySQL l\u00e0 g\u00ec, Host<\/em> m\u00e1y ch\u1ee7 m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 k\u1ebft n\u1ed1i, ch\u1eb3ng h\u1ea1n nh\u01b0 localhost<\/em>, v\u00e0 authentication_string<\/em> m\u1eadt kh\u1ea9u hashed.<\/p>\n\n\n\n

\u0110\u1eb7t m\u1eadt kh\u1ea9u kh\u00f3 cho ng\u01b0\u1eddi d\u00f9ng root MySQL c\u1ee7a b\u1ea1n<\/h2>\n\n\n\n

V\u1edbi t\u00ecnh h\u00ecnh t\u1ea5n c\u00f4ng hi\u1ec7n t\u1ea1i tr\u00ean to\u00e0n b\u1ed9 l\u0129nh v\u1ef1c CNTT, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng m\u1eadt kh\u1ea9u m\u1ea1nh cho c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh. Thay v\u00ec s\u1eed d\u1ee5ng m\u1eadt kh\u1ea9u d\u1ec5 nh\u1edb, h\u00e3y s\u1eed d\u1ee5ng tr\u00ecnh t\u1ea1o m\u1eadt kh\u1ea9u ng\u1eabu nhi\u00ean v\u00e0 l\u01b0u tr\u1eef trong tr\u00ecnh qu\u1ea3n l\u00fd m\u1eadt kh\u1ea9u. An to\u00e0n h\u01a1n c\u1ea3 an to\u00e0n.<\/p>\n\n\n\n

\n\n\n\n

C\u00f4ng ty TNHH METASERV<\/strong>
Email: sales@metaserv.vn
Hotline: \u202d096 308 7773\u202c | 1800 558 820
Thi ch\u1ee9ng ch\u1ec9: 028 3933 8888
\u0110\u1ecba ch\u1ec9: 287B \u0110i\u1ec7n Bi\u00ean Ph\u1ee7, Ph\u01b0\u1eddng Xu\u00e2n H\u00f2a, TP. H\u1ed3 Ch\u00ed Minh
Fanpage:\u00a0IDC METASERV<\/a><\/p>","protected":false},"excerpt":{"rendered":"

N\u1ebfu b\u1ea1n ch\u01b0a bao gi\u1edd \u0111\u1eb7t, qu\u00ean ho\u1eb7c thay \u0111\u1ed5i m\u1eadt kh\u1ea9u MySQL, b\u1ea1n th\u1eadt may m\u1eafn. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1c b\u01b0\u1edbc n\u00e0y, do \u0111\u00f3 b\u1ea1n s\u1ebd kh\u00f4ng bao gi\u1edd ph\u1ea3i m\u1ea5t m\u1eadt kh\u1ea9u ng\u01b0\u1eddi d\u00f9ng root c\u01a1 s\u1edf d\u1eef li\u1ec7u \u0111\u00f3. B\u1ea1n c\u00f3 th\u1ec3 c\u00f3 […]<\/p>","protected":false},"author":2,"featured_media":2035,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[23],"tags":[31],"class_list":["post-2034","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-blog"],"jetpack_featured_media_url":"https:\/\/idc.metaserv.vn\/wp-content\/uploads\/2025\/06\/3.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/idc.metaserv.vn\/en\/wp-json\/wp\/v2\/posts\/2034","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/idc.metaserv.vn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/idc.metaserv.vn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/idc.metaserv.vn\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/idc.metaserv.vn\/en\/wp-json\/wp\/v2\/comments?post=2034"}],"version-history":[{"count":2,"href":"https:\/\/idc.metaserv.vn\/en\/wp-json\/wp\/v2\/posts\/2034\/revisions"}],"predecessor-version":[{"id":2105,"href":"https:\/\/idc.metaserv.vn\/en\/wp-json\/wp\/v2\/posts\/2034\/revisions\/2105"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/idc.metaserv.vn\/en\/wp-json\/wp\/v2\/media\/2035"}],"wp:attachment":[{"href":"https:\/\/idc.metaserv.vn\/en\/wp-json\/wp\/v2\/media?parent=2034"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/idc.metaserv.vn\/en\/wp-json\/wp\/v2\/categories?post=2034"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/idc.metaserv.vn\/en\/wp-json\/wp\/v2\/tags?post=2034"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}