{"id":18593,"date":"2014-11-09T06:55:49","date_gmt":"2014-11-08T22:55:49","guid":{"rendered":"https:\/\/2blog.ilc.edu.tw\/25793\/2014\/11\/09\/wordress-%e6%9b%b4%e6%8f%9b-ip-%e4%b9%8b%e5%be%8c\/"},"modified":"2021-03-18T17:24:10","modified_gmt":"2021-03-18T09:24:10","slug":"wordress-%e6%9b%b4%e6%8f%9b-ip-%e4%b9%8b%e5%be%8c","status":"publish","type":"post","link":"https:\/\/2blog.ilc.edu.tw\/25793\/2014\/11\/09\/wordress-%e6%9b%b4%e6%8f%9b-ip-%e4%b9%8b%e5%be%8c\/","title":{"rendered":"Wordress \u66f4\u63db IP \u4e4b\u5f8c"},"content":{"rendered":"

\u56e0\u70ba WordPress\u00a0\u5728\u5b89\u88dd\u6642\u6703\u628a\u7db2\u8def\u7684\u8a2d\u5b9a\u5beb\u5165\u5230\u8cc7\u6599\u5eab\uff0c\u6240\u4ee5\u7576\u66f4\u63db IP\u00a0\u6642\uff0c\u5c31\u6703\u6709\u7121\u6cd5\u9023\u7dda\u7684\u554f\u984c\u3002
\"\"<\/a>
[@more@]\u89e3\u6c7a\u65b9\u6cd5\uff1a
\u53c3\u8003\u7db2\u9801\uff1a
wordpress \u4fee\u6539IP\u5730\u5740\u540e\u8fdb\u4e0d\u53bb\u540e\u53f0\u7684\u89e3\u51b3\u65b9\u6cd5_wordpress_\u65b0\u6d6a\u8f7b\u535a\u5ba2<\/a>
1.\u00a0\u4f7f\u7528 SQL\u00a0\u6307\u4ee4\u00a0\u7d05\u8272\u7684 IP\u00a0\u5c31\u662f\u65b0\u7684 IP
# \/usr\/bin\/mysql -u root -p wordpress<\/span>
Enter password:<\/span>
Reading table information for completion of table and column names<\/span>
You can turn off this feature to get a quicker startup with -A<\/span><\/p>\n

Welcome to the MariaDB monitor.\u00a0 Commands end with ; or g.<\/span>
Your MariaDB connection id is 16<\/span>
Server version: 10.0.14-MariaDB MariaDB Server<\/span><\/p>\n

Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.<\/span><\/p>\n

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.<\/span><\/p>\n

MariaDB [wordpress]> update wp_options set option_value = ‘http:\/\/192.168.1.109\/wordpress’ where option_name = ‘siteurl’ or option_name = ‘home’;<\/span><\/span>
Query OK, 2 rows affected (0.01 sec)<\/span>
Rows matched: 2\u00a0 Changed: 2\u00a0 Warnings: 0<\/span><\/p>\n

MariaDB [wordpress]> quit<\/span><\/span>
Bye<\/span>2.\u00a0\u4f7f\u7528 Script\u00a0\u00a0 \u7d05\u5b57\u90e8\u5206\u4ee3\u8868\u662f root SQL\u00a0\u7684\u5bc6\u78bc
# vim \/usr\/local\/bin\/setwordpressip<\/span>
#! \/bin\/bash<\/span>
# set wordpress admin ip<\/span><\/p>\n

param=$#<\/span><\/p>\n

if [ $param -eq 1 ]; then<\/span>
\u00a0\u00a0\u00a0\u00a0 echo “update wp_options set option_value = ‘http:\/\/”$1″\/wordpress’ where option_name = ‘siteurl’ or option_name = ‘home’;” > setwordpress.tmp<\/span>
\u00a0\u00a0\u00a0\u00a0 mysql -uroot -p123456<\/span> wordpress < setwordpress.tmp<\/span>
\u00a0\u00a0\u00a0\u00a0 rm setwordpress.tmp<\/span>
\u00a0\u00a0\u00a0\u00a0 echo “OK…”<\/span>
\u00a0\u00a0\u00a0\u00a0 exit 0<\/span>
fi<\/span><\/p>\n

echo “use: $0 IP Address (127.0.0.1)”<\/span><\/p>\n

\u66f4\u6539\u6b0a\u9650
# chmod 700 \/usr\/local\/bin\/setwordpressip<\/span><\/p>\n

\u4f7f\u7528\u65b9\u5f0f
# \/usr\/local\/bin\/setwordpressip 192.168.1.109<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\u56e0\u70ba WordPress\u00a0\u5728\u5b89\u88dd\u6642\u6703\u628a\u7db2\u8def\u7684\u8a2d\u5b9a\u5beb\u5165\u5230\u8cc7\u6599\u5eab\uff0c\u6240\u4ee5\u7576\u66f4\u63db IP\u00a0\u6642\uff0c\u5c31\u6703\u6709\u7121\u6cd5\u9023\u7dda\u7684\u554f\u984c\u3002[@ … <\/p>\n

\u95b1\u8b80\u5168\u6587\u3008Wordress \u66f4\u63db IP \u4e4b\u5f8c\u3009<\/span><\/a><\/p>\n","protected":false},"author":55,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[174],"tags":[],"class_list":["post-18593","post","type-post","status-publish","format-standard","hentry","category-c-86225"],"meta_key":{"_pingme":["1"],"_encloseme":["1"],"lt_post_id":["530070"]},"_links":{"self":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/18593"}],"collection":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/comments?post=18593"}],"version-history":[{"count":1,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/18593\/revisions"}],"predecessor-version":[{"id":20220,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/18593\/revisions\/20220"}],"wp:attachment":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/media?parent=18593"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/categories?post=18593"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/tags?post=18593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}