{"id":31,"date":"2025-04-20T03:03:09","date_gmt":"2025-04-19T19:03:09","guid":{"rendered":"https:\/\/blog.tech-bit.org\/?p=31"},"modified":"2025-04-29T00:50:49","modified_gmt":"2025-04-28T16:50:49","slug":"31","status":"publish","type":"post","link":"https:\/\/blog.tech-bit.org\/?p=31","title":{"rendered":"VPS\u642d\u5efaWordPress\u535a\u5ba2\u5168\u8bb0\u5f55 – TechBit\u7b2c\u4e00\u671f"},"content":{"rendered":"\n

\u5927\u5bb6\u597d\uff01\u6211\u662fTechTao\uff0c\u6b22\u8fce\u4f53\u9a8cTechBit\u7684\u7b2c\u4e00\u4e2a\u5927\u9879\u76ee\uff01\ud83c\udf89 \u8fd9\u7bc7\u535a\u6587\u914d\u5408\u6211\u4eec\u7684\u7b2c\u4e00\u671f\u89c6\u9891<\/a>\uff0c\u5e26\u4f60\u7528Debian VPS\u4ece\u96f6\u642d\u5efa\u4e00\u4e2aWordPress\u535a\u5ba2\uff0c\u8dd1\u5728Nginx+PHP+MariaDB+phpMyAdmin\u73af\u5883\u3002\u6240\u6709\u547d\u4ee4\u90fd\u585e\u8fdb\u4ee3\u7801\u6846\uff0c\u70b9\u201c\u590d\u5236\u201d\u76f4\u63a5\u7528\uff0c\u61d2\u4eba\u798f\u97f3\uff01\ud83d\ude0e \u60f3\u770bTechTao\u8fb9\u5410\u69fd\u8fb9\u6298\u817e\u7684\u8fc7\u7a0b\uff1f\u5feb\u53bb\u89c6\u9891\u611f\u53d7\u4e0b\uff01<\/p>\n\n\n\n

1. \u51c6\u5907\u5de5\u4f5c<\/h2>\n\n\n\n

\u5148\u5f97\u6709\u4e2aVPS\u5f53\u201c\u57fa\u5730\u201d\uff01\u6211\u7528\u7684\u662fEvoxt\uff082.99\u7f8e\u5143\/\u6708\uff0c\u591f\u7528\uff09\uff0c\u76f4\u63a5\u53bbEvoxt\u5b98\u7f51<\/strong><\/a>\u8d2d\u4e70\uff0c\u7ed9\u5927\u5bb6\u63d0\u4f9b\u4e00\u4e2a\u4f18\u60e0\u7801\uff1aAFF2197-TechBit<\/strong>\uff0c\u4f7f\u7528\u6b64\u4f18\u60e0\u7801\u53ef\u4ee5\u4eab\u53d75%\u7684\u6298\u6263\u3002\u767b\u5f55VPS\u7528SSH\uff0c\u63a8\u8350\u4f7f\u7528FinalShell\uff0c\u6216\u8005\u76f4\u63a5\u7ec8\u7aef\u3002\u547d\u4ee4\u5982\u4e0b\uff1a<\/p>\n\n\n\n

Bash<\/span><\/path><\/path><\/svg><\/span>
ssh<\/span> <\/span>root@<\/span><<\/span>\u4f60\u7684VPS-I<\/span>P<\/span>><\/span><\/span><\/code><\/pre>Bash<\/span><\/div>\n\n\n\n
2. \u5b89\u88c5\u57fa\u7840\u73af\u5883<\/h2>\n\n\n\n
2.1 \u66f4\u65b0\u7cfb\u7edf<\/h3>\n\n\n\n
\u767b\u5f55\u540e\uff0c\u5148\u8ba9\u7cfb\u7edf\u201c\u6d17\u4e2a\u6fa1\u201d\uff0c\u4fdd\u6301\u6700\u65b0\u3002\u8dd1\u8fd9\u4fe9\u547d\u4ee4\uff0c\u7b49\u5b83\u5237\u5b8c\uff1a<\/p>\n\n\n\n
Bash<\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>apt<\/span> <\/span>update<\/span> <\/span>&&<\/span> <\/span>sudo<\/span> <\/span>apt<\/span> <\/span>upgrade<\/span> <\/span>-y<\/span><\/span><\/code><\/pre>Bash<\/span><\/div>\n\n\n\n
2.2 \u5b89\u88c5Nginx<\/h3>\n\n\n\n
Nginx\u662f\u54b1\u4eec\u7684\u201c\u8d85\u7ea7\u7f51\u7ba1\u201d\uff0c\u8d1f\u8d23\u7aef\u51fa\u535a\u5ba2\u3002\u88c5\u597d\u540e\uff0c\u6d4f\u89c8\u5668\u8bbf\u95ee\u4f60\u7684VPS IP\uff0c\u5e94\u8be5\u770b\u5230Nginx\u6b22\u8fce\u9875\u3002<\/p>\n\n\n\n
Bash<\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>apt<\/span> <\/span>install<\/span> <\/span>nginx<\/span> <\/span>-y<\/span><\/span>\nsudo<\/span> <\/span>systemctl<\/span> <\/span>enable<\/span> <\/span>nginx<\/span><\/span>\nsudo<\/span> <\/span>systemctl<\/span> <\/span>start<\/span> <\/span>nginx<\/span><\/span><\/code><\/pre>Bash<\/span><\/div>\n\n\n\n
2.3 \u5b89\u88c5MariaDB<\/h3>\n\n\n\n
\u535a\u5ba2\u9700\u8981\u4e2a\u201c\u8bb0\u5fc6\u5e93\u201d\uff0cMariaDB\u6765\u5f53\u6863\u6848\u5458\u3002\u88c5\u5b8c\u8dd1\u5b89\u5168\u8bbe\u7f6e\uff0c\u8bbe\u4e2a\u5bc6\u7801\uff08\u522b\u7528123456\uff0c\u4e0d\u7136\u6bd4\u6211\u5bb6WiFi\u8fd8\u5bb9\u6613\u88ab\u7834\u89e3\uff01\ud83d\ude02\uff09\u3002<\/p>\n\n\n\n
Bash<\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>apt<\/span> <\/span>install<\/span> <\/span>mariadb-server<\/span> <\/span>-y<\/span><\/span>\nsudo<\/span> <\/span>mysql_secure_installation<\/span><\/span><\/code><\/pre>Bash<\/span><\/div>\n\n\n\n
\u6309\u63d0\u793a\u64cd\u4f5c\uff1a
1\u3001\u8bbe\u7f6e root \u5bc6\u7801\uff08\u8bbe\u7f6e\u4e00\u4e2a\u80fd\u8ba9\u4f60\u7761\u584c\u5b9e\u7684\u5bc6\u7801\uff09
2\u3001\u5207\u6362\u8eab\u4efd\u8ba4\u8bc1\uff08\u8f93\u5165N\uff0c\u56de\u8f66\uff09
3\u3001\u4fee\u6539root\u5bc6\u7801\uff08\u8f93\u5165N\uff0c\u56de\u8f66\uff09
4\u3001\u5220\u9664\u533f\u540d\u7528\u6237\uff08\u8f93\u5165Y\uff0c\u56de\u8f66\uff09
5\u3001\u7981\u6b62\u8fdc\u7a0b root \u767b\u5f55\uff08\u8f93\u5165Y\uff0c\u56de\u8f66\uff09
6\u3001\u5220\u9664\u6d4b\u8bd5\u6570\u636e\u5e93\uff08\u8f93\u5165Y\uff0c\u56de\u8f66\uff09
7\u3001\u91cd\u65b0\u52a0\u8f7d\u6743\u9650\u8868\u786e\u4fdd\u6240\u6709\u66f4\u6539\u7acb\u5373\u751f\u6548\uff08\u8f93\u5165Y\uff0c\u56de\u8f66\uff09\u3002<\/p>\n\n\n\n
2.4 \u5b89\u88c5PHP\u548cGD<\/h3>\n\n\n\n
WordPress\u79bb\u4e0d\u4e86PHP\uff0cGD\u5e2e\u4f60\u5904\u7406\u56fe\u7247\uff0c\u4e0d\u7136\u7167\u7247\u7cca\u6210\u9a6c\u8d5b\u514b\uff01\ud83d\ude1c \u8dd1\u8fd9\u4e2a\uff0c\u7a0d\u7b49\u4e00\u4f1a\u3002<\/p>\n\n\n\n
Bash<\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>apt<\/span> <\/span>install<\/span> <\/span>php<\/span> <\/span>php-fpm<\/span> <\/span>php-mysql<\/span> <\/span>php-gd<\/span> <\/span>php-mbstring<\/span> <\/span>php-curl<\/span> <\/span>php-xml<\/span> <\/span>php-zip<\/span> <\/span>-y<\/span><\/span><\/code><\/pre>Bash<\/span><\/div>\n\n\n\n
\u68c0\u67e5 PHP-FPM \u8fd0\u884c\u72b6\u6001\uff1a<\/p>\n\n\n\n
Bash<\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>systemctl<\/span> <\/span>status<\/span> <\/span>php8.2-fpm<\/span>  <\/span># \u6839\u636e\u5b9e\u9645 PHP \u7248\u672c\u8c03\u6574\uff08\u5982 php8.1-fpm\uff09<\/span><\/span><\/code><\/pre>Bash<\/span><\/div>\n\n\n\n
2.5 \u914d\u7f6e Nginx \u652f\u6301 PHP<\/h3>\n\n\n\n
\u7f16\u8f91\u9ed8\u8ba4\u7ad9\u70b9\u914d\u7f6e\uff1a<\/p>\n\n\n\n
Bash<\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>nano<\/span> <\/span>\/etc\/nginx\/sites-available\/default<\/span><\/span><\/code><\/pre>Bash<\/span><\/div>\n\n\n\n
\u4fee\u6539 server \u5757\uff0c\u6dfb\u52a0 PHP \u652f\u6301\uff1a<\/p>\n\n\n\n
Nginx<\/span><\/path><\/path><\/svg><\/span>
server<\/span> {<\/span><\/span>\n   <\/span> listen <\/span>80<\/span> default_server;<\/span><\/span>\n   <\/span> listen <\/span>[::]:80<\/span> default_server;<\/span><\/span>\n   <\/span> root <\/span>\/var\/www\/html<\/span>;<\/span><\/span>\n   <\/span> index <\/span>index.php index.html index.htm index.nginx-debian.html<\/span>;<\/span><\/span>\n   <\/span> server_name <\/span>_<\/span>;<\/span><\/span>\n<\/span>\n    <\/span>location<\/span> \/ {<\/span><\/span>\n       <\/span> try_files $<\/span>uri<\/span> <\/span>$<\/span>uri<\/span>\/ <\/span>=404<\/span>;<\/span><\/span>\n    }<\/span><\/span>\n<\/span>\n    <\/span>location<\/span> <\/span>~<\/span> <\/span>\\.php$ <\/span>{<\/span><\/span>\n       <\/span> include <\/span>snippets\/fastcgi-php.conf<\/span>;<\/span><\/span>\n       <\/span> fastcgi_pass <\/span>unix:\/run\/php\/php8.2-fpm.sock<\/span>;<\/span>  <\/span># \u6839\u636e\u5b9e\u9645 PHP \u7248\u672c\u8c03\u6574<\/span><\/span>\n    }<\/span><\/span>\n<\/span>\n    <\/span>location<\/span> <\/span>~<\/span> <\/span>\/\\.ht <\/span>{<\/span><\/span>\n       <\/span> deny <\/span>all<\/span>;<\/span><\/span>\n    }<\/span><\/span>\n}<\/span><\/span><\/code><\/pre>Nginx<\/span><\/div>\n\n\n\n
Crtl+O\u4fdd\u5b58\uff0cCtrl+X\u9000\u51fa\u3002<\/p>\n\n\n\n
\u6d4b\u8bd5\u914d\u7f6e\u5e76\u91cd\u542f Nginx\uff1a<\/p>\n\n\n\n
Bash<\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>nginx<\/span> <\/span>-t<\/span><\/span>\nsudo<\/span> <\/span>systemctl<\/span> <\/span>reload<\/span> <\/span>nginx<\/span><\/span><\/code><\/pre>Bash<\/span><\/div>\n\n\n\n
3. \u914d\u7f6ephpMyAdmin<\/h2>\n\n\n\n
\u60f3\u5f53\u201c\u6570\u636e\u4fa6\u63a2\u201d\uff1f\u88c5phpMyAdmin\uff0c\u8f7b\u677e\u7ba1\u6570\u636e\u5e93\u3002\u5b89\u88c5\u65f6\u9009Nginx\uff0c\u914d\u7f6e\u4ee3\u7801\u4e22\u5728\u535a\u5ba2\u4e86\uff0c\u590d\u5236\u7c98\u8d34\u5c31\u884c\u3002\u88c5\u5b8c\u8bbf\u95ee \u4f60\u7684IP\/phpmyadmin<\/code>\uff0c\u767b\u5f55\u8bd5\u8bd5\uff01<\/p>\n\n\n\n
Bash<\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>apt<\/span> <\/span>install<\/span> <\/span>phpmyadmin<\/span> <\/span>-y<\/span><\/span><\/code><\/pre>Bash<\/span><\/div>\n\n\n\n
\u521b\u5efa\u7b26\u53f7\u94fe\u63a5\u5230 Nginx \u6839\u76ee\u5f55\uff1a<\/p>\n\n\n\n
Bash<\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>ln<\/span> <\/span>-s<\/span> <\/span>\/usr\/share\/phpmyadmin<\/span> <\/span>\/var\/www\/html\/phpmyadmin<\/span><\/span><\/code><\/pre>Bash<\/span><\/div>\n\n\n\n
\u6216\u8005<\/p>\n\n\n\n
Nginx\u914d\u7f6e\uff08\u52a0\u5230 \/etc\/nginx\/sites-available\/default<\/code>\uff09\uff1a<\/p>\n\n\n\n
Nginx<\/span><\/path><\/path><\/svg><\/span>
location<\/span> \/phpmyadmin {<\/span><\/span>\n   <\/span> alias <\/span>\/usr\/share\/phpmyadmin\/<\/span>;<\/span><\/span>\n}<\/span><\/span><\/code><\/pre>Nginx<\/span><\/div>\n\n\n\n
\u6388\u4e88 phpmyadmin \u7528\u6237\u6743\u9650<\/p>\n\n\n\n
\u4f7f\u7528 root \u7528\u6237\u767b\u5f55 MariaDB\uff1a<\/p>\n\n\n\n
Bash<\/span><\/path><\/path><\/svg><\/span>
mysql<\/span> <\/span>-u<\/span> <\/span>root<\/span> <\/span>-p<\/span>  <\/span># \u8f93\u5165 root \u5bc6\u7801\u767b\u5f55<\/span><\/span><\/code><\/pre>Bash<\/span><\/div>\n\n\n\n
\u65b9\u6848\u4e00\uff1a\u4ec5\u6388\u4e88\u521b\u5efa\u548c\u7ba1\u7406\u6570\u636e\u5e93\u7684\u6743\u9650\uff08\u63a8\u8350\uff09<\/p>\n\n\n\n
SQL<\/span><\/path><\/path><\/svg><\/span>
-- \u5141\u8bb8\u521b\u5efa\u6570\u636e\u5e93\u53ca\u7ba1\u7406\u6240\u6709\u6570\u636e\u5e93\u4e2d\u7684\u8868<\/span><\/span>\nGRANT<\/span> <\/span>CREATE<\/span>, <\/span>ALTER<\/span>, <\/span>DROP<\/span>, <\/span>REFERENCES<\/span>, <\/span>INDEX<\/span>, <\/span>INSERT<\/span>, <\/span>SELECT<\/span>, <\/span>UPDATE<\/span>, <\/span>DELETE<\/span> <\/span><\/span>\nON<\/span> <\/span>*<\/span>.<\/span>*<\/span> <\/span>TO<\/span> <\/span>'<\/span>phpmyadmin<\/span>'<\/span>@<\/span>'<\/span>localhost<\/span>'<\/span>;<\/span><\/span>\nFLUSH PRIVILEGES;<\/span><\/span><\/code><\/pre>SQL<\/span><\/div>\n\n\n\n
\u65b9\u6848\u4e8c\uff1a\u6388\u4e88\u5b8c\u6574\u6743\u9650\uff08\u4e0d\u63a8\u8350\uff0c\u5b58\u5728\u5b89\u5168\u98ce\u9669\uff09<\/p>\n\n\n\n
SQL<\/span><\/path><\/path><\/svg><\/span>
-- \u6388\u4e88\u6240\u6709\u6570\u636e\u5e93\u7684\u5b8c\u6574\u6743\u9650\uff08\u614e\u7528\uff01\uff09<\/span><\/span>\nGRANT<\/span> ALL PRIVILEGES <\/span>ON<\/span> <\/span>*<\/span>.<\/span>*<\/span> <\/span>TO<\/span> <\/span>'<\/span>phpmyadmin<\/span>'<\/span>@<\/span>'<\/span>localhost<\/span>'<\/span>;<\/span><\/span>\nFLUSH PRIVILEGES;<\/span><\/span><\/code><\/pre>SQL<\/span><\/div>\n\n\n\n
\u9a8c\u8bc1\u6743\u9650\u662f\u5426\u751f\u6548\uff1a<\/p>\n\n\n\n
SQL<\/span><\/path><\/path><\/svg><\/span>
SHOW GRANTS <\/span>FOR<\/span> <\/span>'<\/span>phpmyadmin<\/span>'<\/span>@<\/span>'<\/span>localhost<\/span>'<\/span>;<\/span><\/span><\/code><\/pre>SQL<\/span><\/div>\n\n\n\n
\u8f93\u51fa\u5e94\u5305\u542b\u7c7b\u4f3c\uff1a<\/p>\n\n\n\n
SQL<\/span><\/path><\/path><\/svg><\/span>
GRANT<\/span> <\/span>CREATE<\/span>, <\/span>SELECT<\/span>, <\/span>INSERT<\/span>, <\/span>UPDATE<\/span>, <\/span>DELETE<\/span> ... <\/span>ON<\/span> <\/span>*<\/span>.<\/span>*<\/span> <\/span>TO<\/span> <\/span>`<\/span>phpmyadmin<\/span>`<\/span>@<\/span>`<\/span>localhost<\/span>`<\/span><\/span><\/code><\/pre>SQL<\/span><\/div>\n\n\n\n
\u9000\u51fa MariaDB\uff1a<\/p>\n\n\n\n
SQL<\/span><\/path><\/path><\/svg><\/span>
exit;<\/span><\/span><\/code><\/pre>SQL<\/span><\/div>\n\n\n\n
\u91cd\u542fNginx\uff1a<\/p>\n\n\n\n
Bash<\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>systemctl<\/span> <\/span>reload<\/span> <\/span>nginx<\/span><\/span><\/code><\/pre>Bash<\/span><\/div>\n\n\n\n
4. \u6d4b\u8bd5\u73af\u5883<\/h2>\n\n\n\n
1\u3001\u6d4b\u8bd5 PHP\uff1a<\/p>\n\n\n\n
Bash<\/span><\/path><\/path><\/svg><\/span>
echo<\/span> <\/span>"<\/span><?php phpinfo(); ?><\/span>"<\/span> <\/span>|<\/span> <\/span>sudo<\/span> <\/span>tee<\/span> <\/span>\/var\/www\/html\/info.php<\/span><\/span><\/code><\/pre>Bash<\/span><\/div>\n\n\n\n
\u8bbf\u95ee http:\/\/\u670d\u52a1\u5668IP\/info.php\uff0c\u786e\u8ba4 PHP \u4fe1\u606f\u9875\u6b63\u5e38\u663e\u793a\u3002<\/p>\n\n\n\n
2\u3001\u6d4b\u8bd5 phpMyAdmin\uff1a
\u8bbf\u95ee http:\/\/\u670d\u52a1\u5668IP\/phpmyadmin\uff0c\u4f7f\u7528 MySQL root \u8d26\u6237\u767b\u5f55\u3002<\/p>\n\n\n\n
5. \u5b89\u5168\u52a0\u56fa<\/h2>\n\n\n\n
\u9650\u5236 phpMyAdmin \u8bbf\u95ee\uff1a<\/p>\n\n\n\n
\u7f16\u8f91 Nginx \u914d\u7f6e\uff1a<\/p>\n\n\n\n
Bash<\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>nano<\/span> <\/span>\/etc\/nginx\/sites-available\/default<\/span><\/span><\/code><\/pre>Bash<\/span><\/div>\n\n\n\n
\u5728 server \u5757\u5185\u6dfb\u52a0\u4ee5\u4e0b\u5185\u5bb9\uff1a<\/p>\n\n\n\n
Nginx<\/span><\/path><\/path><\/svg><\/span>
location<\/span> \/phpmyadmin {<\/span><\/span>\n   <\/span> auth_basic <\/span>"Restricted Access"<\/span>;<\/span><\/span>\n   <\/span> auth_basic_user_file <\/span>\/etc\/nginx\/.htpasswd<\/span>;<\/span><\/span>\n}<\/span><\/span><\/code><\/pre>Nginx<\/span><\/div>\n\n\n\n
\u751f\u6210\u5bc6\u7801\u6587\u4ef6\uff1a<\/p>\n\n\n\n
Bash<\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>apt<\/span> <\/span>install<\/span> <\/span>apache2-utils<\/span><\/span>\nsudo<\/span> <\/span>htpasswd<\/span> <\/span>-c<\/span> <\/span>\/etc\/nginx\/.htpasswd<\/span> <\/span>\u7528\u6237\u540d<\/span><\/span><\/code><\/pre>Bash<\/span><\/div>\n\n\n\n
\u91cd\u542f Nginx\uff1a<\/p>\n\n\n\n
Bash<\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>systemctl<\/span> <\/span>reload<\/span> <\/span>nginx<\/span><\/span><\/code><\/pre>Bash<\/span><\/div>\n\n\n\n
6. \u5b89\u88c5WordPress<\/h2>\n\n\n\n
\u9ad8\u5149\u65f6\u523b\uff01\u4e0b\u8f7dWordPress\uff0c\u89e3\u538b\uff0c\u632a\u5230Nginx\u76ee\u5f55\u3002\u6743\u9650\u548c\u6570\u636e\u5e93\u8bbe\u7f6e\u540e\uff0c\u6d4f\u89c8\u5668\u8bbf\u95ee \u4f60\u7684IP\/wordpress<\/code>\uff0c\u6309\u63d0\u793a\u586b\u4fe1\u606f\uff0c\u535a\u5ba2\u5c31\u4e0a\u7ebf\u5566\uff01<\/p>\n\n\n\n
Bash<\/span><\/path><\/path><\/svg><\/span>
wget<\/span> <\/span>https:\/\/wordpress.org\/latest.tar.gz<\/span><\/span>\ntar<\/span> <\/span>-xzvf<\/span> <\/span>latest.tar.gz<\/span><\/span>\nsudo<\/span> <\/span>mv<\/span> <\/span>wordpress<\/span> <\/span>\/var\/www\/html\/<\/span><\/span><\/code><\/pre>Bash<\/span><\/div>\n\n\n\n
\u8bbe\u7f6e\u6743\u9650\uff1a<\/p>\n\n\n\n
Bash<\/span><\/path><\/path><\/svg><\/span>
sudo<\/span> <\/span>chown<\/span> <\/span>-R<\/span> <\/span>www-data:www-data<\/span> <\/span>\/var\/www\/html\/wordpress<\/span><\/span>\nsudo<\/span> <\/span>chmod<\/span> <\/span>-R<\/span> <\/span>755<\/span> <\/span>\/var\/www\/html\/wordpress<\/span><\/span><\/code><\/pre>Bash<\/span><\/div>\n\n\n\n
\u521b\u5efa\u6570\u636e\u5e93\uff1a<\/p>\n\n\n\n
SQL<\/span><\/path><\/path><\/svg><\/span>
mysql <\/span>-<\/span>u <\/span>root<\/span> <\/span>-<\/span>p<\/span><\/span>\n-- \u521b\u5efa\u6570\u636e\u5e93<\/span><\/span>\nCREATE<\/span> <\/span>DATABASE<\/span> <\/span>wordpress<\/span>;<\/span><\/span>\n-- \u521b\u5efa\u7528\u6237<\/span><\/span>\nCREATE<\/span> <\/span>USER<\/span> '<\/span>wp_user<\/span>'@<\/span>'<\/span>localhost<\/span>'<\/span> IDENTIFIED <\/span>BY<\/span> <\/span>'<\/span>\u4f60\u8981\u8bbe\u7f6e\u7684\u5bc6\u7801<\/span>'<\/span>;<\/span><\/span>\n-- \u6388\u6743\u7528\u6237\u8bbf\u95ee\u7279\u5b9a\u6570\u636e\u5e93<\/span><\/span>\nGRANT<\/span> ALL <\/span>ON<\/span> wordpress.<\/span>*<\/span> <\/span>TO<\/span> <\/span>'<\/span>wp_user<\/span>'<\/span>@<\/span>'<\/span>localhost<\/span>'<\/span> IDENTIFIED <\/span>BY<\/span> <\/span>'<\/span>\u4f60\u7684\u5bc6\u7801<\/span>'<\/span>;<\/span><\/span>\n-- \u5237\u65b0\u6743\u9650<\/span><\/span>\nFLUSH PRIVILEGES;<\/span><\/span>\nEXIT;<\/span><\/span><\/code><\/pre>SQL<\/span><\/div>\n\n\n\n
7. \u989d\u5916\u63d0\u793a<\/h2>\n\n\n\n