{"id":425,"date":"2020-02-13T15:30:43","date_gmt":"2020-02-13T08:30:43","guid":{"rendered":"https:\/\/www.st.ac.th\/krubuncha\/?p=425"},"modified":"2021-12-05T21:18:08","modified_gmt":"2021-12-05T14:18:08","slug":"mysql-5-7-root-%e0%b9%80%e0%b8%82%e0%b9%89%e0%b8%b2%e0%b8%a3%e0%b8%b0%e0%b8%9a%e0%b8%9a%e0%b9%84%e0%b8%a1%e0%b9%88%e0%b9%84%e0%b8%94%e0%b9%89-%e0%b9%81%e0%b8%a5%e0%b8%b0%e0%b9%84%e0%b8%a1%e0%b9%88","status":"publish","type":"post","link":"https:\/\/www.st.ac.th\/krubuncha\/mysql-5-7-root-%e0%b9%80%e0%b8%82%e0%b9%89%e0%b8%b2%e0%b8%a3%e0%b8%b0%e0%b8%9a%e0%b8%9a%e0%b9%84%e0%b8%a1%e0%b9%88%e0%b9%84%e0%b8%94%e0%b9%89-%e0%b9%81%e0%b8%a5%e0%b8%b0%e0%b9%84%e0%b8%a1%e0%b9%88\/","title":{"rendered":"Mysql 5.7 Root \u0e40\u0e02\u0e49\u0e32\u0e23\u0e30\u0e1a\u0e1a\u0e44\u0e21\u0e48\u0e44\u0e14\u0e49 \u0e41\u0e25\u0e30\u0e44\u0e21\u0e48\u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16\u0e43\u0e0a\u0e49 Remote \u0e44\u0e14\u0e49 \u0e21\u0e35\u0e27\u0e34\u0e18\u0e35\u0e41\u0e01\u0e49"},"content":{"rendered":"

\u0e17\u0e35\u0e48 \u0e2b\u0e19\u0e49\u0e32 Terminal
\n#mysql_secure_installation
\n\u0e41\u0e25\u0e49\u0e27\u0e2a\u0e23\u0e49\u0e32\u0e07 Password \u0e43\u0e2b\u0e49\u0e01\u0e31\u0e1a Root \u0e43\u0e2b\u0e21\u0e48
\n\u0e2b\u0e23\u0e37\u0e2d
\n----------------------------------<\/span><\/code><\/p>\n

sudo<\/code> service mysql stop<\/code><\/div>\n
sudo<\/code> mysqld_safe --skip-grant-tables &<\/code><\/div>\n
\n

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

UPDATE<\/code> mysql.<\/code>user<\/code> SET<\/code> authentication_string=<\/code>PASSWORD<\/code>(<\/code>'mypassword'<\/code>) <\/code>WHERE<\/code> User<\/code>=<\/code>'root'<\/code>;<\/code><\/div>\n
UPDATE<\/code> mysql.<\/code>user<\/code> SET<\/code> plugin=<\/code>\"mysql_native_password\"<\/code> WHERE<\/code> User<\/code>=<\/code>'root'<\/code>;<\/code><\/div>\n
FLUSH <\/code>PRIVILEGES<\/code>;<\/code><\/div>\n<\/div>\n

\u0e01\u0e23\u0e13\u0e35\u0e2a\u0e23\u0e49\u0e32\u0e07 User \u0e44\u0e21\u0e48\u0e44\u0e14\u0e49\u0e25\u0e2d\u0e07\u0e15\u0e32\u0e21\u0e19\u0e35\u0e49<\/p>\n

SHOW VARIABLES <\/span>LIKE<\/span> 'validate_password%'<\/span>;<\/span><\/code><\/pre>\n
<\/code>The output should be something like that :<\/pre>\n
+<\/span>--------------------------------------+-------+<\/span>\r\n|<\/span> Variable_name                        <\/span>|<\/span> Value <\/span>|<\/span>\r\n+<\/span>--------------------------------------+-------+<\/span>\r\n|<\/span> validate_password<\/span>.<\/span>check_user_name    <\/span>|<\/span> ON<\/span>    |<\/span>\r\n|<\/span> validate_password<\/span>.<\/span>dictionary_file    <\/span>|<\/span>       |<\/span>\r\n|<\/span> validate_password<\/span>.<\/span>length             <\/span>|<\/span> 6<\/span>     |<\/span>\r\n|<\/span> validate_password<\/span>.<\/span>mixed_case_count   <\/span>|<\/span> 1<\/span>     |<\/span>\r\n|<\/span> validate_password<\/span>.<\/span>number_count       <\/span>|<\/span> 1<\/span>     |<\/span>\r\n|<\/span> validate_password<\/span>.<\/span>policy             <\/span>|<\/span> LOW   <\/span>|<\/span>\r\n|<\/span> validate_password<\/span>.<\/span>special_char_count <\/span>|<\/span> 1<\/span>     |<\/span>\r\n+<\/span>--------------------------------------+-------+<\/span><\/code><\/pre>\n
<\/code>then you can set the password policy level lower, for example:<\/pre>\n
SET<\/span> GLOBAL validate_password<\/span>.<\/span>length <\/span>=<\/span> 6<\/span>;<\/span>\r\nSET<\/span> GLOBAL validate_password<\/span>.<\/span>number_count <\/span>=<\/span> 0<\/span>;<\/span><\/code><\/pre>\n
<\/code>\u00a0----------------------------------\r\n\u0e2a\u0e48\u0e27\u0e19\u0e01\u0e23\u0e13\u0e35\u0e44\u0e21\u0e48\u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16 Remote \u0e44\u0e14\u0e49\r\n\u0e43\u0e2b\u0e49\u0e41\u0e01\u0e49\u0e44\u0e02 File\r\n# vi \/usr\/local\/etc\/mysql\/my.cnf\r\n\u0e15\u0e23\u0e07\u0e1a\u0e23\u0e23\u0e17\u0e31\u0e14\r\nbind-address = 127.0.0.1\r\n<\/span><\/code><\/pre>\n
<\/code><\/p>\n
<\/code><\/p>\n
<\/code><\/p>\n
<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"
\u0e17\u0e35\u0e48 \u0e2b\u0e19\u0e49\u0e32 Terminal #mysql_secure_installation \u0e41\u0e25\u0e49\u0e27\u0e2a\u0e23\u0e49\u0e32\u0e07 Password \u0e43\u0e2b\u0e49\u0e01\u0e31\u0e1a Root \u0e43\u0e2b\u0e21\u0e48 \u0e2b\u0e23\u0e37\u0e2d ———————————- sudo service mysql stop sudo mysqld_safe –skip-grant-tables & mysql -u root mysql UPDATE mysql.user [\u0e2d\u0e48\u0e32\u0e19\u0e15\u0e48\u0e2d]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":534,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-425","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category--freebsd"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2020\/02\/unnamed.jpg?fit=425%2C425&ssl=1","blog_post_layout_featured_media_urls":{"thumbnail":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2020\/02\/unnamed.jpg?resize=150%2C150&ssl=1",150,150,true],"full":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2020\/02\/unnamed.jpg?fit=425%2C425&ssl=1",425,425,false]},"categories_names":{"3":{"name":"\u0e1a\u0e31\u0e19\u0e17\u0e36\u0e01\u0e0a\u0e48\u0e27\u0e22\u0e08\u0e33 FreeBSD","link":"https:\/\/www.st.ac.th\/krubuncha\/category\/%e0%b8%9a%e0%b8%b1%e0%b8%99%e0%b8%97%e0%b8%b6%e0%b8%81%e0%b8%8a%e0%b9%88%e0%b8%a7%e0%b8%a2%e0%b8%88%e0%b8%b3-freebsd\/"}},"tags_names":[],"comments_number":0,"wpmagazine_modules_lite_featured_media_urls":{"thumbnail":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2020\/02\/unnamed.jpg?resize=150%2C150&ssl=1",150,150,true],"cvmm-medium":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2020\/02\/unnamed.jpg?resize=300%2C300&ssl=1",300,300,true],"cvmm-medium-plus":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2020\/02\/unnamed.jpg?resize=305%2C207&ssl=1",305,207,true],"cvmm-portrait":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2020\/02\/unnamed.jpg?resize=400%2C425&ssl=1",400,425,true],"cvmm-medium-square":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2020\/02\/unnamed.jpg?resize=425%2C425&ssl=1",425,425,true],"cvmm-large":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2020\/02\/unnamed.jpg?resize=425%2C425&ssl=1",425,425,true],"cvmm-small":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2020\/02\/unnamed.jpg?resize=130%2C95&ssl=1",130,95,true],"full":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2020\/02\/unnamed.jpg?fit=425%2C425&ssl=1",425,425,false]},"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5Mvvj-6R","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/posts\/425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/comments?post=425"}],"version-history":[{"count":5,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/posts\/425\/revisions"}],"predecessor-version":[{"id":430,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/posts\/425\/revisions\/430"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/media\/534"}],"wp:attachment":[{"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/media?parent=425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/categories?post=425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/tags?post=425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}