{"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":"2025-10-27T16:45:57","modified_gmt":"2025-10-27T09:45:57","slug":"thay-doi-mat-khau-cho-may-chu-sql","status":"publish","type":"ht_kb","link":"https:\/\/helpsme.misa.vn\/2023\/kb\/thay-doi-mat-khau-cho-may-chu-sql\/","title":{"rendered":"Thay \u0111\u1ed5i m\u1eadt kh\u1ea9u cho m\u00e1y ch\u1ee7 SQL"},"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.<\/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>C\u00e1ch k\u1ebft n\u1ed1i l\u1ea1i m\u00e1y tr\u1ea1m sau khi \u0111\u1ed5i m\u1eadt kh\u1ea9u<\/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=\"\/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_2-1-700x457.png 700w, \/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_2-1-768x501.png 768w, \/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_2-1-50x33.png 50w, \/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_2-1-60x39.png 60w, \/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_2-1-100x65.png 100w, \/2023\/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 2022 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.SME2022.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=\"\/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_4-3-700x576.png 700w, \/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_4-3-800x658.png 800w, \/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_4-3-768x632.png 768w, \/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_4-3-50x41.png 50w, \/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_4-3-60x49.png 60w, \/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_4-3-100x82.png 100w, \/2023\/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=\"\/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_5-1.png 407w, \/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_5-1-50x47.png 50w, \/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_5-1-60x57.png 60w, \/2023\/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=\"\/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_1-700x592.png 700w, \/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_1-800x677.png 800w, \/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_1-768x650.png 768w, \/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_1-50x42.png 50w, \/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_1-60x51.png 60w, \/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_1-100x85.png 100w, \/2023\/wp-content\/uploads\/2022\/05\/ketnoisql_1.png 927w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n<p><em><strong>L\u01b0u \u00fd<\/strong>: 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\u00a0<strong>M\u1eadt kh\u1ea9u SQL<\/strong><\/em><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&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\/2023\/wp-json\/wp\/v2\/ht-kb\/25850","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/users\/107"}],"replies":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/comments?post=25850"}],"version-history":[{"count":4,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/25850\/revisions"}],"predecessor-version":[{"id":45971,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/25850\/revisions\/45971"}],"wp:attachment":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/media?parent=25850"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb-category?post=25850"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb-tag?post=25850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}