{"id":610,"date":"2026-10-27T07:12:34","date_gmt":"2026-10-27T00:12:34","guid":{"rendered":"https:\/\/www.st.ac.th\/krubuncha\/?p=610"},"modified":"2026-10-27T07:12:34","modified_gmt":"2026-10-27T00:12:34","slug":"%e0%b8%9e%e0%b8%b7%e0%b9%89%e0%b8%99%e0%b8%90%e0%b8%b2%e0%b8%99-mariadb","status":"publish","type":"post","link":"https:\/\/www.st.ac.th\/krubuncha\/%e0%b8%9e%e0%b8%b7%e0%b9%89%e0%b8%99%e0%b8%90%e0%b8%b2%e0%b8%99-mariadb\/","title":{"rendered":"\u0e1e\u0e37\u0e49\u0e19\u0e10\u0e32\u0e19 MariaDB"},"content":{"rendered":"\n

\u0e08\u0e33\u0e25\u0e2d\u0e07\u0e40\u0e2b\u0e15\u0e38\u0e01\u0e32\u0e23\u0e13\u0e4c \u0e22\u0e49\u0e32\u0e22\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e23\u0e30\u0e2b\u0e27\u0e48\u0e32\u0e07 Server \u0e2a\u0e21\u0e21\u0e38\u0e15\u0e34\u0e0a\u0e37\u0e48\u0e2d wordpress_db
**\u0e40\u0e04\u0e23\u0e37\u0e48\u0e2d\u0e07\u0e15\u0e49\u0e19\u0e17\u0e32\u0e07**
– \u0e14\u0e39\u0e43\u0e2b\u0e49\u0e41\u0e19\u0e48\u0e43\u0e08\u0e27\u0e48\u0e32\u0e21\u0e35\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e40\u0e1b\u0e49\u0e32\u0e2b\u0e21\u0e32\u0e22\u0e21\u0e35\u0e2d\u0e22\u0e39\u0e48\u0e08\u0e23\u0e34\u0e07
mysql -u root -p -e “SHOW DATABASES;”
– Dump \u0e40\u0e09\u0e1e\u0e32\u0e30\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 wordpress_db \u0e44\u0e1b\u0e40\u0e01\u0e47\u0e1a\u0e44\u0e27\u0e49 \u0e40\u0e0a\u0e48\u0e19 root\/wordpress_db.sql
mysqldump -u root -p \\
–routines \\
–triggers \\
–single-transaction \\
–default-character-set=utf8mb4 \\
wordpress_db > \/root\/wordpress_db.sql
-\u0e2a\u0e48\u0e07 \u0e44\u0e1b\u0e22\u0e31\u0e07\u0e40\u0e04\u0e23\u0e37\u0e48\u0e2d\u0e07\u0e43\u0e2b\u0e21\u0e48 (User \u0e15\u0e49\u0e2d\u0e07\u0e21\u0e35\u0e2a\u0e34\u0e17\u0e18\u0e34\u0e4c\u0e40\u0e1b\u0e47\u0e19 Root)\u00a0
scp \/root\/wordpress_db.sql root@[IP_\u0e40\u0e04\u0e23\u0e37\u0e48\u0e2d\u0e07_DB_\u0e43\u0e2b\u0e21\u0e48]:\/root\/
——————————-
**** \u0e40\u0e04\u0e23\u0e37\u0e48\u0e2d\u0e07\u0e1b\u0e25\u0e32\u0e22\u0e17\u0e32\u0e07 ***
-\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e40\u0e1b\u0e25\u0e48\u0e32\u0e23\u0e2d\u0e07\u0e23\u0e31\u0e1a\u0e1d\u0e31\u0e48\u0e07\u0e1b\u0e25\u0e32\u0e22\u0e17\u0e32\u0e07
mariadb -u root -p -e “CREATE DATABASE wordpress_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;”
-\u0e19\u0e33\u0e40\u0e02\u0e49\u0e32\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25
mariadb -u root -p wordpress_db < \/root\/wordpress_db.sql
-\u0e15\u0e23\u0e27\u0e08\u0e2a\u0e2d\u0e1a\u0e04\u0e27\u0e32\u0e21\u0e2a\u0e21\u0e1a\u0e39\u0e23\u0e13\u0e4c\u0e02\u0e2d\u0e07\u0e42\u0e04\u0e23\u0e07\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07
mariadb-upgrade -u root -p
-\u0e2a\u0e23\u0e49\u0e32\u0e07 user \u0e17\u0e35\u0e48\u0e21\u0e35\u0e2a\u0e34\u0e17\u0e18\u0e34\u0e4c\u0e40\u0e02\u0e49\u0e32\u0e43\u0e0a\u0e49 \u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 wordpress_db
mariadb -u root -p<\/p>\n

— \u0e01\u0e23\u0e13\u0e35\u0e23\u0e30\u0e1a\u0e38 IP \u0e40\u0e09\u0e1e\u0e32\u0e30\u0e40\u0e08\u0e32\u0e30\u0e08\u0e07\u0e02\u0e2d\u0e07 Web Server (\u0e41\u0e19\u0e30\u0e19\u0e33\u0e17\u0e35\u0e48\u0e2a\u0e38\u0e14\u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e04\u0e27\u0e32\u0e21\u0e1b\u0e25\u0e2d\u0e14\u0e20\u0e31\u0e22)
CREATE USER ‘wp_user’@’IP_WEB_SERVER’ IDENTIFIED BY ‘\u0e01\u0e33\u0e2b\u0e19\u0e14\u0e23\u0e2b\u0e31\u0e2a\u0e1c\u0e48\u0e32\u0e19\u0e17\u0e35\u0e48\u0e19\u0e35\u0e48’;
GRANT ALL PRIVILEGES ON wordpress_db.* TO ‘wp_user’@’IP_WEB_SERVER’;<\/p>\n

— \u0e2b\u0e23\u0e37\u0e2d\u0e01\u0e23\u0e13\u0e35\u0e2d\u0e19\u0e38\u0e0d\u0e32\u0e15\u0e17\u0e31\u0e49\u0e07\u0e27\u0e07 LAN (\u0e40\u0e0a\u0e48\u0e19 192.168.1.X)
— CREATE USER ‘wp_user’@’192.168.1.%’ IDENTIFIED BY ‘\u0e01\u0e33\u0e2b\u0e19\u0e14\u0e23\u0e2b\u0e31\u0e2a\u0e1c\u0e48\u0e32\u0e19\u0e17\u0e35\u0e48\u0e19\u0e35\u0e48’;
— GRANT ALL PRIVILEGES ON wordpress_db.* TO ‘wp_user’@’192.168.1.%’;<\/p>\n

FLUSH PRIVILEGES;
EXIT;

**\u0e17\u0e14\u0e2a\u0e2d\u0e1a\u0e01\u0e32\u0e23\u0e40\u0e0a\u0e37\u0e48\u0e2d\u0e21\u0e15\u0e48\u0e2d\u0e17\u0e35\u0e48\u0e40\u0e04\u0e23\u0e37\u0e48\u0e2d\u0e07 WebServer\u00a0
mariadb -h IP_\u0e40\u0e04\u0e23\u0e37\u0e48\u0e2d\u0e07_DB_\u0e43\u0e2b\u0e21\u0e48 -u wp_user -p wordpress_db

<\/p>\n","protected":false},"excerpt":{"rendered":"

\u0e08\u0e33\u0e25\u0e2d\u0e07\u0e40\u0e2b\u0e15\u0e38\u0e01\u0e32\u0e23\u0e13\u0e4c \u0e22\u0e49\u0e32\u0e22\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e23\u0e30\u0e2b\u0e27\u0e48\u0e32\u0e07 Server \u0e2a\u0e21\u0e21\u0e38\u0e15\u0e34\u0e0a\u0e37\u0e48\u0e2d wordpress_db**\u0e40\u0e04\u0e23\u0e37\u0e48\u0e2d\u0e07\u0e15\u0e49\u0e19\u0e17\u0e32\u0e07**– \u0e14\u0e39\u0e43\u0e2b\u0e49\u0e41\u0e19\u0e48\u0e43\u0e08\u0e27\u0e48\u0e32\u0e21\u0e35\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e40\u0e1b\u0e49\u0e32\u0e2b\u0e21\u0e32\u0e22\u0e21\u0e35\u0e2d\u0e22\u0e39\u0e48\u0e08\u0e23\u0e34\u0e07mysql -u root -p -e “SHOW DATABASES;”– Dump \u0e40\u0e09\u0e1e\u0e32\u0e30\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 wordpress_db \u0e44\u0e1b\u0e40\u0e01\u0e47\u0e1a\u0e44\u0e27\u0e49 \u0e40\u0e0a\u0e48\u0e19 root\/wordpress_db.sqlmysqldump -u root -p \\–routines \\–triggers \\–single-transaction \\–default-character-set=utf8mb4 [\u0e2d\u0e48\u0e32\u0e19\u0e15\u0e48\u0e2d]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1],"tags":[],"class_list":["post-610","post","type-post","status-publish","format-standard","hentry","category-1"],"blog_post_layout_featured_media_urls":{"thumbnail":"","full":""},"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":"","cvmm-medium":"","cvmm-medium-plus":"","cvmm-portrait":"","cvmm-medium-square":"","cvmm-large":"","cvmm-small":"","full":""},"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5Mvvj-9Q","jetpack-related-posts":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/posts\/610","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=610"}],"version-history":[{"count":1,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/posts\/610\/revisions"}],"predecessor-version":[{"id":611,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/posts\/610\/revisions\/611"}],"wp:attachment":[{"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/media?parent=610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/categories?post=610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/tags?post=610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}