{"id":242,"date":"2013-09-20T14:50:52","date_gmt":"2013-09-20T07:50:52","guid":{"rendered":"http:\/\/www.st.ac.th\/krubuncha\/?p=242"},"modified":"2021-12-05T21:27:56","modified_gmt":"2021-12-05T14:27:56","slug":"mysql-%e0%b8%81%e0%b8%b1%e0%b8%9a%e0%b8%9b%e0%b8%b1%e0%b8%8d%e0%b8%ab%e0%b8%b2-old-password","status":"publish","type":"post","link":"https:\/\/www.st.ac.th\/krubuncha\/mysql-%e0%b8%81%e0%b8%b1%e0%b8%9a%e0%b8%9b%e0%b8%b1%e0%b8%8d%e0%b8%ab%e0%b8%b2-old-password\/","title":{"rendered":"Mysql \u0e01\u0e31\u0e1a\u0e1b\u0e31\u0e0d\u0e2b\u0e32 Old Password"},"content":{"rendered":"<p>\u0e41\u0e01\u0e49\u0e44\u0e02 \u0e2b\u0e23\u0e37\u0e2d\u0e40\u0e1e\u0e34\u0e48\u0e21\u0e40\u0e15\u0e34\u0e21 \/etc\/my.cnf<br \/>\nold_passwords=1<\/p>\n<p>\u0e08\u0e32\u0e01\u0e19\u0e31\u0e49\u0e19 \u0e43\u0e2b\u0e49\u0e1b\u0e23\u0e31\u0e1a Password \u0e42\u0e14\u0e22\u0e01\u0e32\u0e23\u0e40\u0e02\u0e49\u0e32 Mysql<\/p>\n<p><code>mysql -uYourRootUsername -pYourRootPassword<\/code><br \/>\nSET SESSION old_passwords=0;<\/p>\n<p>UPDATE mysql.user SET Password = PASSWORD(&#8216;my_password&#8217;) WHERE user = &#8216;my_db_username&#8217;;<br \/>\nFLUSH PRIVILEGES;<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>\u0e41\u0e01\u0e49\u0e44\u0e02 \u0e2b\u0e23\u0e37\u0e2d\u0e40\u0e1e\u0e34\u0e48\u0e21\u0e40\u0e15\u0e34\u0e21 \/etc\/my.cnf old_passwords=1 \u0e08\u0e32\u0e01\u0e19\u0e31\u0e49\u0e19 \u0e43\u0e2b\u0e49\u0e1b\u0e23\u0e31\u0e1a Password \u0e42\u0e14\u0e22\u0e01\u0e32\u0e23\u0e40\u0e02\u0e49\u0e32 Mysql mysql -uYourRootUsername -pYourRootPassword SET SESSION old_passwords=0; UPDATE mysql.user SET Password = PASSWORD(&#8216;my_password&#8217;) WHERE user = &#8216;my_db_username&#8217;; <a class=\"mh-excerpt-more\" href=\"https:\/\/www.st.ac.th\/krubuncha\/mysql-%e0%b8%81%e0%b8%b1%e0%b8%9a%e0%b8%9b%e0%b8%b1%e0%b8%8d%e0%b8%ab%e0%b8%b2-old-password\/\" title=\"Mysql \u0e01\u0e31\u0e1a\u0e1b\u0e31\u0e0d\u0e2b\u0e32 Old Password\">[\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":[1],"tags":[],"class_list":["post-242","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-1"],"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":{"1":{"name":"\u0e1a\u0e17\u0e04\u0e27\u0e32\u0e21\u0e04\u0e2d\u0e21\u0e1e\u0e34\u0e27\u0e40\u0e15\u0e2d\u0e2d\u0e23\u0e4c","link":"https:\/\/www.st.ac.th\/krubuncha\/category\/%e0%b8%9a%e0%b8%97%e0%b8%84%e0%b8%a7%e0%b8%b2%e0%b8%a1%e0%b8%84%e0%b8%ad%e0%b8%a1%e0%b8%9e%e0%b8%b4%e0%b8%a7%e0%b9%80%e0%b8%95%e0%b8%ad%e0%b8%ad%e0%b8%a3%e0%b9%8c\/"}},"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-3U","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/posts\/242","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=242"}],"version-history":[{"count":1,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/posts\/242\/revisions"}],"predecessor-version":[{"id":542,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/posts\/242\/revisions\/542"}],"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=242"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/categories?post=242"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/tags?post=242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}