{"id":25850,"date":"2022-05-31T08:34:47","date_gmt":"2022-05-31T01:34:47","guid":{"rendered":"http:\/\/helpsme.misa.vn\/2022\/?post_type=ht_kb&#038;p=25850"},"modified":"2026-04-24T10:39:28","modified_gmt":"2026-04-24T03:39:28","slug":"thay-doi-mat-khau-cho-may-chu-sql","status":"publish","type":"ht_kb","link":"https:\/\/helpsme.misa.vn\/2026\/kb\/thay-doi-mat-khau-cho-may-chu-sql\/","title":{"rendered":"N\u00e2ng cao b\u1ea3o m\u1eadt cho m\u00e1y ch\u1ee7 SQL khi publish m\u00e1y ch\u1ee7 SQL l\u00ean internet"},"content":{"rendered":"<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><strong>1. T\u1ed5ng quan<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>M\u1ee5c \u0111\u00edch: <\/strong>B\u00e0i vi\u1ebft n\u00e0y gi\u00fap ng\u01b0\u1eddi d\u00f9ng b\u1ea3o v\u1ec7 an to\u00e0n d\u1eef li\u1ec7u khi publish m\u00e1y ch\u1ee7 SQL l\u00ean internet, b\u1eb1ng c\u00e1ch thi\u1ebft l\u1eadp l\u1ea1i m\u1eadt kh\u1ea9u m\u1ea1nh cho m\u00e1y ch\u1ee7 v\u00e0 c\u1eadp nh\u1eadt k\u1ebft n\u1ed1i cho m\u00e1y tr\u1ea1m, ph\u00f2ng tr\u00e1nh nguy c\u01a1 b\u1ecb hacker t\u1ea5n c\u00f4ng v\u00e0 1 s\u1ed1 l\u01b0u \u00fd v\u1ec1 b\u1ea3o m\u1eadt v\u00e0 kh\u00f4ng k\u1ebft n\u1ed1i m\u00e1y tr\u1ea1m v\u1edbi m\u00e1y ch\u1ee7 n\u1ebfu kh\u00e1c m\u1ea1ng LAN n\u1ed9i b\u1ed9<\/p>\n<p><strong>Bi\u1ec3u hi\u1ec7n:<\/strong> C\u1ea3nh b\u00e1o ch\u01b0a thi\u1ebft l\u1eadp m\u1eadt kh\u1ea9u m\u00e1y ch\u1ee7 SQL<\/p>\n<p><strong>N\u1ed9i dung b\u00e0i vi\u1ebft g\u1ed3m:<\/strong><\/p>\n<ul>\n<li>H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp m\u1eadt kh\u1ea9u m\u1edbi cho m\u00e1y ch\u1ee7 SQL<\/li>\n<li>L\u01b0u \u00fd v\u1ec1 b\u1ea3o m\u1eadt v\u00e0 ghi nh\u1edb m\u1eadt kh\u1ea9u<\/li>\n<\/ul>\n<p><strong>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/strong> D\u00e0nh cho qu\u1ea3n tr\u1ecb vi\u00ean h\u1ec7 th\u1ed1ng, k\u1ebf to\u00e1n v\u00e0 ng\u01b0\u1eddi d\u00f9ng ph\u1ea7n m\u1ec1m MISA SME c\u00f3 nhu c\u1ea7u publish m\u00e1y ch\u1ee7 SQL ho\u1eb7c k\u1ebft n\u1ed1i t\u1eeb xa.<\/p>\n<\/div><\/div>\n<\/div>\n<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><strong>2. C\u00e1ch th\u1ef1c hi\u1ec7n<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>M\u1ee5c \u0111\u00edch:\u00a0<\/strong><\/p>\n<p>Khi ng\u01b0\u1eddi d\u00f9ng pulish m\u00e1y ch\u1ee7 k\u1ebft n\u1ed1i l\u00ean internet \u0111\u1ec3 ph\u1ee5c v\u1ee5 k\u1ebft n\u1ed1i t\u1eeb xa, hacker c\u00f3 th\u1ec3 d\u00f2 m\u1eadt kh\u1ea9u t\u1ef1 \u0111\u1ed9ng, chi\u1ebfm quy\u1ec1n truy c\u1eadp v\u00e0o m\u00e1y ch\u1ee7 SQL v\u00e0 th\u1ef1c hi\u1ec7n m\u00e3 h\u00f3a d\u1eef li\u1ec7u.<\/p>\n<p>V\u00ec v\u1eady, \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o an to\u00e0n b\u1ea3o m\u1eadt cho d\u1eef li\u1ec7u, MISA khuy\u1ebfn ngh\u1ecb ng\u01b0\u1eddi d\u00f9ng n\u00ean thi\u1ebft l\u1eadp l\u1ea1i m\u1eadt kh\u1ea9u cho m\u00e1y ch\u1ee7 SQL tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c ti\u1ebfp theo.<\/p>\n<p style=\"padding-left: 120px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-25883\" src=\"\/2022\/wp-content\/uploads\/2022\/05\/ketnoisql_2-1-700x457.png\" alt=\"\" width=\"700\" height=\"457\" srcset=\"\/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_2-1-700x457.png 700w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_2-1-768x501.png 768w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_2-1-50x33.png 50w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_2-1-60x39.png 60w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_2-1-100x65.png 100w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_2-1.png 772w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 100%;\"><\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4><strong>2.1 Thi\u1ebft l\u1eadp m\u1eadt kh\u1ea9u m\u00e1y ch\u1ee7 SQL<\/strong><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><span style=\"font-size: 12pt;\"><strong>B\u01b0\u1edbc 1:<\/strong> Nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng MISA SME tr\u00ean m\u00e0n h\u00ecnh m\u00e1y t\u00ednh, ch\u1ecdn <strong>Open file location.<\/strong><\/span><\/p>\n<p style=\"padding-left: 160px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-thumbnail wp-image-25857\" src=\"\/2022\/wp-content\/uploads\/2022\/05\/ketnoisql_3-300x400.png\" alt=\"\" width=\"300\" height=\"400\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> T\u1ea1i th\u01b0 m\u1ee5c <strong>Bin<\/strong>, t\u00ecm ki\u1ebfm v\u00e0 nh\u1ea5n m\u1edf <strong>MISA.SME.ServerSetting\u00a0<\/strong><\/p>\n<p style=\"padding-left: 40px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-25880\" src=\"\/2022\/wp-content\/uploads\/2022\/05\/ketnoisql_4-3-700x576.png\" alt=\"\" width=\"700\" height=\"576\" srcset=\"\/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_4-3-700x576.png 700w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_4-3-800x658.png 800w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_4-3-768x632.png 768w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_4-3-50x41.png 50w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_4-3-60x49.png 60w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_4-3-100x82.png 100w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_4-3.png 983w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Ch\u1ecdn m\u00e1y ch\u1ee7 SQL c\u1ea7n thi\u1ebft l\u1eadp.<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> T\u00edch ch\u1ecdn <strong>Thi\u1ebft l\u1eadp m\u1eadt kh\u1ea9u SQL<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> Nh\u1eadp m\u1eadt kh\u1ea9u SQL m\u1edbi.<\/p>\n<p><strong>B\u01b0\u1edbc 6:<\/strong> Nh\u1ea5n <strong>\u0110\u1ed3ng \u00fd.<\/strong><\/p>\n<p style=\"padding-left: 80px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-25866\" src=\"\/2022\/wp-content\/uploads\/2022\/05\/ketnoisql_5-1.png\" alt=\"\" width=\"407\" height=\"385\" srcset=\"\/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_5-1.png 407w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_5-1-50x47.png 50w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_5-1-60x57.png 60w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_5-1-100x95.png 100w\" sizes=\"auto, (max-width: 407px) 100vw, 407px\" \/><\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4><strong>2.2 K\u1ebft n\u1ed1i m\u00e1y tr\u1ea1m v\u1edbi m\u00e1y ch\u1ee7 (Sau khi thay \u0111\u1ed5i m\u1eadt kh\u1ea9u m\u00e1y ch\u1ee7 SQL)<\/strong><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p>Khi m\u00e1y tr\u1ea1m \u0111\u0103ng nh\u1eadp d\u1eef li\u1ec7u v\u1edbi m\u00e1y ch\u1ee7 k\u1ebft n\u1ed1i \u0111\u00e3 thay \u0111\u1ed5i m\u1eadt kh\u1ea9u SQL, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Li\u00ean h\u1ec7 v\u1edbi Qu\u1ea3n tr\u1ecb m\u00e1y ch\u1ee7 SQL \u0111\u1ec3 bi\u1ebft th\u00f4ng tin m\u1eadt kh\u1ea9u \u0111\u00e3 thay \u0111\u1ed5i.<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1eadp m\u1eadt kh\u1ea9u t\u00e0i kho\u1ea3n k\u1ebft n\u1ed1i SQL server (do m\u00e1y ch\u1ee7 cung c\u1ea5p).<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n <strong>\u0110\u1ed3ng \u00fd<\/strong>.<\/p>\n<p style=\"padding-left: 40px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-25879\" src=\"\/2022\/wp-content\/uploads\/2022\/05\/ketnoisql_1-700x592.png\" alt=\"\" width=\"700\" height=\"592\" srcset=\"\/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_1-700x592.png 700w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_1-800x677.png 800w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_1-768x650.png 768w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_1-50x42.png 50w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_1-60x51.png 60w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_1-100x85.png 100w, \/2026\/wp-content\/uploads\/2022\/05\/ketnoisql_1.png 927w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n<ul>\n<li><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/div>\n<h3><strong>3. L\u01b0u \u00fd<\/strong><\/h3>\n<ul>\n<li>Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd t\u1ef1 \u0111\u1ed9ng ghi nh\u1edb m\u1eadt kh\u1ea9u n\u00e0y, t\u1eeb l\u1ea7n \u0111\u0103ng nh\u1eadp sau, m\u00e1y tr\u1ea1m kh\u00f4ng c\u1ea7n nh\u1eadp l\u1ea1i <strong>M\u1eadt kh\u1ea9u SQL<\/strong><\/li>\n<li>Tr\u01b0\u1eddng h\u1ee3p m\u00e1y ch\u1ee7 kh\u00f4ng thay \u0111\u1ed5i m\u1eadt kh\u1ea9u SQL, m\u00e1y ch\u1ee7, m\u00e1y tr\u1ea1m m\u1edbi c\u00e0i \u0111\u1eb7t m\u00e0 b\u1ecb c\u1ea3nh b\u00e1o M\u1eadt kh\u1ea9u m\u00e1y ch\u1ee7 SQL b\u1ecb thay \u0111\u1ed5i khi m\u00e1y tr\u1ea1m \u0111\u0103ng nh\u1eadp th\u00ec c\u1ea7n ki\u1ec3m tra l\u1ea1i k\u1ebft n\u1ed1i tr\u1ea1m ch\u1ee7 theo nguy\u00ean nh\u00e2n 2 v\u00e0 6 h\u01b0\u1edbng d\u1eabn <a href=\"https:\/\/helpsme.misa.vn\/2026\/kb\/html_36020000\/#2-nguyen-nhan-va-cach-khac-phuc\">t\u1ea1i \u0111\u00e2y<\/a><\/li>\n<li>Ph\u1ea7n m\u1ec1m SME ch\u1ec9 h\u1ed7 tr\u1ee3 k\u1ebft n\u1ed1i m\u00e1y tr\u1ea1m v\u1edbi m\u00e1y ch\u1ee7 th\u00f4ng qua m\u1ea1ng LAN n\u1ed9i b\u1ed9, kh\u00f4ng h\u1ed7 tr\u1ee3 k\u1ebft n\u1ed1i qua m\u1ea1ng internet (n\u1ebfu kh\u00e1c m\u1ea1ng LAN) v\u00ed d\u1ee5 m\u00e1y ch\u1ee7 \u1edf t\u1ea7ng 1 d\u00f9ng m\u1ea1ng LAN, m\u00e1y tr\u1ea1m \u1edf t\u1ea7ng 3 d\u00f9ng m\u1ea1ng wifi v\u00e0 kh\u00f4ng h\u1ed7 tr\u1ee3 m\u00e1y tr\u1ea1m v\u00e0 m\u00e1y ch\u1ee7 \u0111\u1eb7t \u1edf c\u00e1c v\u1ecb tr\u00ed \u0111\u1ecba l\u00fd kh\u00e1c nhau, v\u00ed d\u1ee5 m\u00e1y tr\u1ea1m \u1edf H\u00e0 N\u1ed9i, m\u00e1y ch\u1ee7 \u1edf TP.HCM.<\/li>\n<\/ul>\n<\/div>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; &nbsp; &nbsp;<\/p>\n","protected":false},"author":107,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[2642],"ht-kb-tag":[3923],"class_list":["post-25850","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-sql-server","ht_kb_tag-mat-khau-may-chu-sql"],"_links":{"self":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb\/25850","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/users\/107"}],"replies":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/comments?post=25850"}],"version-history":[{"count":6,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb\/25850\/revisions"}],"predecessor-version":[{"id":70577,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb\/25850\/revisions\/70577"}],"wp:attachment":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/media?parent=25850"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb-category?post=25850"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb-tag?post=25850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}