{"id":5,"date":"2023-08-25T00:34:43","date_gmt":"2023-08-24T16:34:43","guid":{"rendered":"https:\/\/techblog.hxdy2013.com\/?p=5"},"modified":"2023-09-17T17:43:22","modified_gmt":"2023-09-17T09:43:22","slug":"lnmp-on-ubuntu-22-04","status":"publish","type":"post","link":"https:\/\/techblog.hxdy2013.com\/?p=5","title":{"rendered":"LNMP on Ubuntu 22.04"},"content":{"rendered":"<div class=\"wp-block-post-date\"><time datetime=\"2023-08-25T00:34:43+08:00\">2023-08-25<\/time><\/div>\n\n\n<p class=\"wp-block-paragraph\">LNMP\u662fLinux+Nginx+MariaDB\/MySQL+PHP\u73af\u5883\u7684\u7f29\u5199\uff0c\u6309\u7167\u53d1\u97f3\uff0c\u4e5f\u5199\u4f5cLEMP\u73af\u5883\u3002\u672c\u6587\u8bb2\u8ff0\u5982\u4f55\u5728Ubuntu 22.04\u4e2d\u5b89\u88c5\u548c\u914d\u7f6eNginx+MariaDB\/MySQL+PHP\u3002<\/p>\n\n\n\n<p class=\"has-large-font-size wp-block-paragraph\">\u786c\u4ef6\u73af\u5883<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Lenovo ThinkPad T14 Gen2 20W1S3H811: Intel i5-1145G7 + DDR4 16GB + NVMe 512GB<\/p>\n\n\n\n<p class=\"has-large-font-size wp-block-paragraph\">\u8f6f\u4ef6\u73af\u5883<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Win11 x64 Build 22621.2134 \u82f1\u6587\u4e13\u4e1a\u7248 + VirtualBox v7.0.8 r156879<\/p>\n\n\n\n<p class=\"has-large-font-size wp-block-paragraph\">VirtualBox\u5b89\u88c5Xubuntu 22.04<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Xubuntu\u662f\u57fa\u4e8eUbuntu\u7684Linux\u53d1\u884c\u7248\uff0c\u91c7\u7528\u8f7b\u91cf\u7ea7\u7684XFce\u684c\u9762\u73af\u5883\uff0c\u5e76\u5bf9\u4f4e\u7aef\u8ba1\u7b97\u673a\u505a\u4e86\u4f18\u5316\u3002\u672c\u6587\u540e\u9762\u63d0\u5230Ubuntu\u65f6\uff0c\u9664\u975e\u660e\u786e\u6307\u51fa\uff0c\u5426\u5219\u5747\u9ed8\u8ba4\u662fXubuntu\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e3a\u51cf\u5c11\u5b89\u88c5\u65f6\u95f4\u548c\u907f\u514d\u9ebb\u70e6\uff0c\u5b89\u88c5\u65f6\u9009English\u4f5c\u4e3a\u7cfb\u7edf\u8bed\u8a00\uff0c\u9009\u62e9Minimal Installation\u6700\u5c0f\u5b89\u88c5\uff0c\u57ce\u5e02\u9009\u9ed8\u8ba4\u7684New York\u7ebd\u7ea6\u3002<\/p>\n\n\n\n<p class=\"has-large-font-size wp-block-paragraph\">Ubuntu 22.04\u51c6\u5907\u5de5\u4f5c<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u542f\u7528root\u8d26\u6237<\/strong><br>Ubuntu\u9ed8\u8ba4\u6ca1\u6709\u542f\u7528root\u8d26\u6237\u3002\u5728\u751f\u4ea7\u73af\u5883\u4e2d\uff0c\u5f3a\u70c8\u5efa\u8bae\u975e\u5fc5\u8981\u4e0d\u8981\u542f\u7528root\u8d26\u6237\u3002\u672c\u6587\u4ec5\u4e3a\u65b9\u4fbf\u800c\u542f\u7528\u4e86root\u8d26\u6237\uff0c\u540e\u7eedShell\u547d\u4ee4\u9ed8\u8ba4\u5747\u4ee5root\u8d26\u53f7\u8fd0\u884c\u3002<br>\u5728Ubuntu\u4e2d\u542f\u7528root\u8d26\u6237\u975e\u5e38\u7b80\u5355\uff0c\u4e3a\u5176\u8bbe\u7f6e\u5bc6\u7801\u5373\u53ef\u3002<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>passwd root<\/code><\/mark><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>APT\u6362\u56fd\u5185\u6e90<\/strong><br>Ubuntu\u7684\u5305\u7ba1\u7406\u5668APT\u9ed8\u8ba4\u7684\u6e90\u5728\u56fd\u5916\uff0c\u4ece\u56fd\u5185\u8bbf\u95ee\u901f\u5ea6\u5f88\u6162\u3002\u4e3a\u65b9\u4fbf\u4f7f\u7528\uff0c\u6709\u5fc5\u8981\u4e3aAPT\u6362\u56fd\u5185\u6e90\u3002\u5e38\u7528\u7684\u6709\u963f\u91cc\u6e90\u3001\u6e05\u534e\u6e90\u3001\u4e2d\u79d1\u5927\u6e90\u3001\u7f51\u6613163\u6e90\u7b49\u3002<br>\/etc\/apt\/sources.list\u6587\u4ef6\u8bb0\u5f55\u7740APT\u7684\u6e90\uff0c\u7f16\u8f91\u6b64\u6587\u4ef6\u5373\u53ef\u4f7f\u7528\u4e0d\u540c\u7684\u6e90\u3002<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>mv \/etc\/apt\/sources.list \/etc\/apt\/source.list.original<\/code><\/mark>    # \u5907\u4efdsources.list<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>touch \/etc\/apt\/sources.list<\/code><\/mark>    # \u521b\u5efa\u7a7a\u6587\u4ef6sources.list<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>vi \/etc\/apt\/sources.list<\/code><\/mark>    # \u7f16\u8f91sources.list\uff0c\u5f55\u5165\u4ee5\u4e0b\u5185\u5bb9<br><code><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"># \u9ed8\u8ba4\u6ce8\u91ca\u4e86\u6e90\u7801\u955c\u50cf\u4ee5\u63d0\u9ad8 apt update \u901f\u5ea6\uff0c\u5982\u6709\u9700\u8981\u53ef\u81ea\u884c\u53d6\u6d88\u6ce8\u91ca<\/mark><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"># \u963f\u91cc\u6e90<br>deb https:\/\/mirrors.aliyun.com\/ubuntu\/ jammy main restricted universe multiverse<br># deb-src https:\/\/mirrors.aliyun.com\/ubuntu\/ jammy main restricted universe multiverse<br>deb https:\/\/mirrors.aliyun.com\/ubuntu\/ jammy-security main restricted universe multiverse<br># deb-src https:\/\/mirrors.aliyun.com\/ubuntu\/ jammy-security main restricted universe multiverse<br>deb https:\/\/mirrors.aliyun.com\/ubuntu\/ jammy-updates main restricted universe multiverse<br># deb-src https:\/\/mirrors.aliyun.com\/ubuntu\/ jammy-updates main restricted universe multiverse<br>deb https:\/\/mirrors.aliyun.com\/ubuntu\/ jammy-proposed main restricted universe multiverse<br># deb-src https:\/\/mirrors.aliyun.com\/ubuntu\/ jammy-proposed main restricted universe multiverse<br>deb https:\/\/mirrors.aliyun.com\/ubuntu\/ jammy-backports main restricted universe multiverse<br># deb-src https:\/\/mirrors.aliyun.com\/ubuntu\/ jammy-backports main restricted universe multiverse<\/mark><\/code><br>\u4e5f\u53ef\u4ee5\u4f7f\u7528\u6e05\u534e\u6e90\u3001\u4e2d\u79d1\u5927\u6e90\u3001\u7f51\u6613163\u6e90\u3002\u4ee5\u6e05\u534e\u6e90\u4e3a\u4f8b\uff0c\u5c06\/etc\/apt\/sources.list\u5185\u5bb9\u66ff\u6362\u4e3a\u4ee5\u4e0b\u5185\u5bb9\uff1a<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code># \u9ed8\u8ba4\u6ce8\u91ca\u4e86\u6e90\u7801\u955c\u50cf\u4ee5\u63d0\u9ad8 apt update \u901f\u5ea6\uff0c\u5982\u6709\u9700\u8981\u53ef\u81ea\u884c\u53d6\u6d88\u6ce8\u91ca<br>#\u6e05\u534e\u6e90<br>deb https:\/\/mirrors.tuna.tsinghua.edu.cn\/ubuntu\/ jammy main restricted universe multiverse<br># deb-src https:\/\/mirrors.tuna.tsinghua.edu.cn\/ubuntu\/ jammy main restricted universe multiverse<br>deb https:\/\/mirrors.tuna.tsinghua.edu.cn\/ubuntu\/ jammy-updates main restricted universe multiverse<br># deb-src https:\/\/mirrors.tuna.tsinghua.edu.cn\/ubuntu\/ jammy-updates main restricted universe multiverse<br>deb https:\/\/mirrors.tuna.tsinghua.edu.cn\/ubuntu\/ jammy-backports main restricted universe multiverse<br># deb-src https:\/\/mirrors.tuna.tsinghua.edu.cn\/ubuntu\/ jammy-backports main restricted universe multiverse<br># deb https:\/\/mirrors.tuna.tsinghua.edu.cn\/ubuntu\/ jammy-security main restricted universe multiverse<br># deb-src https:\/\/mirrors.tuna.tsinghua.edu.cn\/ubuntu\/ jammy-security main restricted universe multiverse<br>deb https:\/\/security.ubuntu.com\/ubuntu\/ jammy-security main restricted universe multiverse<br># deb-src https:\/\/security.ubuntu.com\/ubuntu\/ jammy-security main restricted universe multiverse<br>#<br># \u9884\u53d1\u5e03\u8f6f\u4ef6\u6e90\uff0c\u4e0d\u5efa\u8bae\u542f\u7528<br># deb https:\/\/mirrors.tuna.tsinghua.edu.cn\/ubuntu\/ jammy-proposed main restricted universe multiverse<br># deb-src https:\/\/mirrors.tuna.tsinghua.edu.cn\/ubuntu\/ jammy-proposed main restricted universe multiverse<\/code><\/mark><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u66f4\u65b0Ubuntu\u5305\u5217\u8868<\/strong><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>apt update<\/code><\/mark><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u66f4\u65b0Ubuntu\u8f6f\u4ef6<\/strong><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>apt upgrade<\/code><\/mark><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u67e5\u770bUbuntu\u7248\u672c<\/strong><br><code><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\">lsb_release -a<\/mark><br><mark style=\"background-color:#ffd700\" class=\"has-inline-color\">No LSB modules are available.<br>Distributor ID: Ubuntu<br>Description: Ubuntu 22.04.3 LTS<br>Release: 22.04<br>Codename: jammy<\/mark><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u5b89\u88c5Screen<\/strong><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>apt install screen<\/code><\/mark><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u67e5\u770bScreen\u7248\u672c<\/strong><br><code><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\">screen -v<\/mark><br><mark style=\"background-color:#ffd700\" class=\"has-inline-color\">Screen version 4.09.00 (GNU) 30-Jan-22<\/mark><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u5b89\u88c5Net-Tools<\/strong><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>apt install net-tools<\/code><\/mark><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u67e5\u770bIP\u914d\u7f6e<\/strong><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>ifconfig<\/code><\/mark><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u5b89\u88c5openssh-server<\/strong><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>apt install openssh-server<\/code><\/mark><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u67e5\u770bopenssh-server\u7248\u672c<br><code><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\">ssh -V<\/mark><br><mark style=\"background-color:#ffd700\" class=\"has-inline-color\">OpenSSH_8.9p1 Ubuntu-3ubuntu0.3, OpenSSL 3.0.2 15 Mar 2022<\/mark><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u5141\u8bb8root\u7528\u6237\u901a\u8fc7ssh\u8fdc\u7a0b\u767b\u5f55<\/strong><br>\u7f16\u8f91\/etc\/ssh\/sshd_config\u6587\u4ef6<mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>vi \/etc\/ssh\/sshd_config<\/code><\/mark><br>\u627e\u5230<mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>#PermitRootLogin prohibit-password<\/code><\/mark><br>\u6539\u6210<mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>PermitRootLogin yes<\/code><\/mark><br>\u91cd\u542fssh\u670d\u52a1<mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>systemctl restart sshd<\/code><\/mark><\/p>\n\n\n\n<p class=\"has-large-font-size wp-block-paragraph\">\u5b89\u88c5Nginx<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u5b89\u88c5Nginx<\/strong><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>apt install nginx<\/code><\/mark><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u67e5\u770bNginx\u7248\u672c<\/strong><br><code><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\">nginx -v<\/mark><br><mark style=\"background-color:#ffd700\" class=\"has-inline-color\">nginx version: nginx\/1.18.0 (Ubuntu)<\/mark><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u6d4f\u89c8\u5668\u5730\u5740\u680f\u8f93\u5165 <code>https:\/\/Ubuntu_IP\/<\/code><br>\u5982Nginx\u5de5\u4f5c\u6b63\u5e38\uff0c\u53ef\u4ee5\u770b\u5230\u5982\u4e0b\u56fe\u6240\u793a\u9875\u9762\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"496\" height=\"181\" src=\"https:\/\/techblog.hxdy2013.com\/wp-content\/uploads\/2023\/08\/1.png\" alt=\"\" class=\"wp-image-7\"\/><\/figure>\n\n\n\n<p class=\"has-large-font-size wp-block-paragraph\">\u5b89\u88c5php-fpm<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6ce8\u610f\uff0c\u6b64\u5904\u5b89\u88c5\u7684\u662fphp-fpm (FastCGI Process Manager)\uff0c\u800c\u4e0d\u662fphp\u3002\u5982apt install php\uff0c\u4f1a\u5c06apache2\u4e00\u5e76\u5b89\u88c5\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u5b89\u88c5php-fpm<\/strong><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>apt install php-fpm<\/code><\/mark><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u67e5\u770bphp\u7248\u672c<\/strong><br><code><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\">php -v<\/mark><br><mark style=\"background-color:#ffd700\" class=\"has-inline-color\">PHP 8.1.2-1ubuntu2.14 (cli) (built: Aug 18 2023 11:41:11) (NTS)<\/mark><\/code><\/p>\n\n\n\n<p class=\"has-large-font-size wp-block-paragraph\">\u5728Nginx\u4e2d\u542f\u7528php-fpm<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u51c6\u5907php\u6d4b\u8bd5\u811a\u672cphpinfo.php<\/strong><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>echo '&lt;?php phpinfo();' > \/var\/www\/html\/phpinfo.php<\/code><\/mark><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u6d4f\u89c8\u5668\u5730\u5740\u680f\u8f93\u5165 <code>https:\/\/Ubuntu_IP\/phpinfo.php<\/code><br>\u53d1\u73b0\u6ca1\u6709\u83b7\u5f97phpinfo()\u51fd\u6570\u7684\u8f93\u51fa\uff0c\u800c\u662f\u4e0b\u8f7d\u4e86phpinfo.php\u6587\u4ef6\u3002\u8fd9\u662f\u56e0\u4e3aNginx\u7684php-fpm\u6ca1\u6709\u6b63\u786e\u914d\u7f6e\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u7f16\u8f91Nginx\u914d\u7f6e\u6587\u4ef6<\/strong><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>vi \/etc\/nginx\/sites-enabled\/default<\/code><\/mark><br>\u627e\u5230<mark style=\"background-color:#F6F6F6\" class=\"has-inline-color\"><code>index index.html index.htm index.nginx-debian.html;<\/code><\/mark><br>\u6539\u6210<mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>index index.php index.html index.htm index.nginx-debian.html;<\/code><\/mark><br>\u5c06server{}\u6bb5\u4e2d\u7684location ~ \\.php$ {}\u6bb5\u4fee\u6539\u4e3a\u4ee5\u4e0b\u5185\u5bb9\uff1a<br><code><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\">location ~ .php$ {<br>    include snippets\/fastcgi-php.conf;<br>    # With php-fpm (or other unix sockets):<br>    fastcgi_pass unix:\/run\/php\/php-fpm.sock;<br>    # With php-cgi (or other tcp sockets):<br>    # fastcgi_pass 127.0.0.1:9000;<br>}<\/mark><br><\/code>\u5176\u4e2d<mark style=\"background-color:#F6F6F6\" class=\"has-inline-color\"><code>fastcgi_pass unix:\/run\/php\/php-fpm.sock;<\/code><\/mark>\u4e5f\u53ef\u4ee5\u6539\u6210<mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>fastcgi_pass unix:\/run\/php\/php8.1-fpm.sock<\/code>;<\/mark>\uff0c\u76ee\u7684\u90fd\u662f\u6539\u6b63<mark style=\"background-color:#F6F6F6\" class=\"has-inline-color\"><code>fastcgi_pass unix:\/run\/php\/php7.4-fpm.sock;<\/code><\/mark>\u4e2d\u9519\u8bef\u6307\u5b9a\u7684php-fpm\u7248\u672c\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u68c0\u67e5Nginx\u914d\u7f6e\u6587\u4ef6\u662f\u5426\u6b63\u786e<\/strong><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>nginx -t<\/code><\/mark><br>\u5982Nginx\u914d\u7f6e\u6587\u4ef6\u6b63\u786e\uff0c\u4f1a\u5f97\u5230\u4ee5\u4e0b\u63d0\u793a\uff1a<br><mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><code>nginx: the configuration file \/etc\/nginx\/nginx.conf syntax is ok<br>nginx: configuration file \/etc\/nginx\/nginx.conf test is successful<\/code><\/mark><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u91cd\u542fNginx<\/strong><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>systemctl restart nginx<\/code><\/mark><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u6d4f\u89c8\u5668\u5730\u5740\u680f\u8f93\u5165 <code>https:\/\/Ubuntu_IP\/phpinfo.php<\/code><br>\u5982Nginx\u548cphp-fpm\u5de5\u4f5c\u6b63\u5e38\uff0c\u53ef\u4ee5\u770b\u5230\u5982\u4e0b\u56fe\u6240\u793a\u9875\u9762\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"747\" src=\"https:\/\/techblog.hxdy2013.com\/wp-content\/uploads\/2023\/08\/2.png\" alt=\"\" class=\"wp-image-8\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u5220\u9664phpinfo.php\u4ee5\u514d\u670d\u52a1\u5668\u4fe1\u606f\u6cc4\u9732<\/strong><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>rm \/var\/www\/html\/phpinfo.php<\/code><\/mark><\/p>\n\n\n\n<p class=\"has-large-font-size wp-block-paragraph\">\u5b89\u88c5\u914d\u7f6eMariaDB\/MySQL\uff08\u4e8c\u9009\u4e00\uff0c\u9ed8\u8ba4\u4e0d\u5171\u5b58\uff09<\/p>\n\n\n\n<p class=\"has-large-font-size wp-block-paragraph\">\u5b89\u88c5\u914d\u7f6eMariaDB<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u5b89\u88c5MariaDB<\/strong><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>apt install mariadb-server<\/code><\/mark><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u67e5\u770bMariaDB\u7248\u672c<\/strong><br><code><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\">mariadb -V<\/mark><br><mark style=\"background-color:#ffd700\" class=\"has-inline-color\">mariadb Ver 15.1 Distrib 10.6.12-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper<\/mark><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u589e\u5f3aMariaDB\u5b89\u5168\u6027<\/strong><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>mariadb-secure-installation<\/code><\/mark>    # \u6ce8\u610f\u8fd9\u91cc\u662f\u8fde\u7ebf\u7b26-<br><mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><code>Enter current password for root (enter for none):<\/code><\/mark>    # MariaDB\u9ed8\u8ba4root\u5bc6\u7801\u4e3a\u7a7a<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><br><code>Switch to unix_socket authentication [Y\/n] <\/code><\/mark><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>Y<\/code><\/mark>    # \u5207\u6362\u5230unix_socket\u8ba4\u8bc1\u65b9\u5f0f<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><br><code>Change the root password? [Y\/n] <\/code><\/mark><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>n<\/code><\/mark>    # unix_socket\u8ba4\u8bc1\u901a\u8fc7\u7cfb\u7edf\u8d26\u6237\u8fdb\u884c\uff0c\u8fd9\u91cc\u53ef\u4ee5\u4fdd\u6301MariaDB\u7684root\u5bc6\u7801\u4e3a\u7a7a<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><br><code>Remove anonymous users? [Y\/n] <\/code><\/mark><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>Y<\/code><\/mark>    # \u79fb\u9664\u7cfb\u7edf\u5185\u7f6e\u7684\u533f\u540d\u7528\u6237<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><br><code>Disallow root login remotely? [Y\/n] <\/code><\/mark><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>Y<\/code><\/mark>    # \u7981\u6b62MariaDB\u7684root\u7528\u6237\u8fdc\u7a0b\u767b\u5f55<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><br><code>Remove test database and access to it? [Y\/n] <\/code><\/mark><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>Y<\/code><\/mark>    # \u79fb\u9664\u7cfb\u7edf\u5185\u7f6e\u7684\u6d4b\u8bd5\u6570\u636e\u5e93<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><br><code>Reload privilege tables now? [Y\/n] <\/code><\/mark><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>Y<\/code><\/mark>    # \u91cd\u65b0\u52a0\u8f7d\u6743\u9650\u8868<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\uff08\u53ef\u9009\u9879\uff09\u4fee\u6539MariaDB\u8ba4\u8bc1\u65b9\u5f0f<\/strong><br>MariaDB\u9ed8\u8ba4\u4f7f\u7528unix_socket\u8ba4\u8bc1\u65b9\u5f0f\uff0c\u5373\u4ee5OS\u7528\u6237\u8d26\u53f7\u767b\u5f55MariaDB\uff0c\u5b89\u5168\u6027\u7531OS\u4fdd\u8bc1\uff0c\u6570\u636e\u5e93\u7528\u6237\u9ed8\u8ba4\u7a7a\u5bc6\u7801\u3002\u8be6\u89c1MariaDB\u5b98\u7f51\u89e3\u91ca\uff1a<a href=\"https:\/\/mariadb.com\/kb\/en\/authentication-plugin-unix-socket\/\">Authentication Plugin &#8211; Unix Socket &#8211; MariaDB Knowledge Base<\/a><br>\u53ef\u4ee5\u4fee\u6539MariaDB\u8ba4\u8bc1\u65b9\u5f0f\u4e3aMySQL\u5bc6\u7801\u65b9\u5f0fmysql_native_password\u3002\u64cd\u4f5c\u6d41\u7a0b\u5982\u4e0b\uff1a<br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>mariadb<\/code><\/mark>\u6216<mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>mysql<\/code><\/mark><br><code>MariaDB [(none)]> <mark style=\"background-color:#9DFF20\" class=\"has-inline-color\">use mysql;<\/mark><br>MariaDB [mysql]> <mark style=\"background-color:#9DFF20\" class=\"has-inline-color\">select user, plugin from user where user='root';<\/mark><\/code><br>\u5982\u679cplugin\u662funix_socket\uff0c\u53c2\u8003MariaDB\u5b98\u7f51\uff0c\u7528\u4ee5\u4e0bSQL\u8bed\u53e5\u4fee\u6539\uff1a<br><code>MariaDB [mysql]> <mark style=\"background-color:#9DFF20\" class=\"has-inline-color\">alter user 'root'@'localhost' identified via mysql_native_password;<\/mark><\/code>    # \u4fee\u6539\u8ba4\u8bc1\u65b9\u5f0f<br><code>MariaDB [mysql]> <mark style=\"background-color:#9DFF20\" class=\"has-inline-color\">alter user 'root'@'localhost' identified by 'root_password';<\/mark><\/code>    # \u5fc5\u987b\u4fee\u6539\u5bc6\u7801\u624d\u80fd\u751f\u6548\u3002\u5426\u5219root\u7528\u6237\u4ecd\u53ef\u4ee5\u7528\u7a7a\u5bc6\u7801\u8fdb\u5165MariaDB\u3002<br><code>MariaDB [mysql]> <mark style=\"background-color:#9DFF20\" class=\"has-inline-color\">exit;<\/mark><\/code>    # \u9000\u51faMariaDB<\/p>\n\n\n\n<p class=\"has-large-font-size wp-block-paragraph\">\u5b89\u88c5\u914d\u7f6eMySQL<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u5b89\u88c5MySQL<\/strong><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>apt install mysql-server<\/code><\/mark><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u67e5\u770bMySQL\u7248\u672c<\/strong><br><code><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\">mysql -V<\/mark><br><mark style=\"background-color:#ffd700\" class=\"has-inline-color\">mysql Ver 8.0.34-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))<\/mark><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u589e\u5f3aMySQL\u5b89\u5168\u6027<\/strong><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>mysql_secure_installation<\/code><\/mark>    # \u6ce8\u610f\u8fd9\u91cc\u662f\u4e0b\u5212\u7ebf_<br><mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><code>Press y|Y for Yes, any other key for No: <\/code><\/mark><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>n<\/code><\/mark>    # \u8fd9\u91cc\u6572Y\u7684\u8bdd\u5219MySQL\u7528\u6237\u5bc6\u7801\u5fc5\u987b\u6ee1\u8db3\u590d\u6742\u5ea6\u8981\u6c42<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><br><code>Remove anonymous users? (Press y|Y for Yes, any other key for No) : <\/code><\/mark><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>Y<\/code><\/mark>    # \u79fb\u9664\u7cfb\u7edf\u5185\u7f6e\u7684\u533f\u540d\u7528\u6237<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><br><code>Disallow root login remotely? (Press y|Y for Yes, any other key for No) : <\/code><\/mark><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>Y<\/code><\/mark>    # \u7981\u6b62MySQL\u7684root\u7528\u6237\u8fdc\u7a0b\u767b\u5f55<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><br><code>Remove test database and access to it? (Press y|Y for Yes, any other key for No) : <\/code><\/mark><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>Y<\/code><\/mark>    # \u79fb\u9664\u7cfb\u7edf\u5185\u7f6e\u7684\u6d4b\u8bd5\u6570\u636e\u5e93<mark style=\"background-color:#ffd700\" class=\"has-inline-color\"><br><code>Reload privilege tables now? (Press y|Y for Yes, any other key for No) : <\/code><\/mark><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>Y<\/code><\/mark>    # \u91cd\u65b0\u52a0\u8f7d\u6743\u9650\u8868<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\uff08\u53ef\u9009\u9879\uff09\u4fee\u6539MySQL\u8ba4\u8bc1\u65b9\u5f0f<\/strong><br>MySQL 8 root\u8d26\u6237\u9ed8\u8ba4\u4f7f\u7528auth_socket\u8ba4\u8bc1\u65b9\u5f0f\uff0c\u5373\u4ee5OS\u7528\u6237\u8d26\u53f7\u767b\u5f55MariaDB\uff0c\u5b89\u5168\u6027\u7531OS\u4fdd\u8bc1\uff0c\u6570\u636e\u5e93root\u7528\u6237\u9ed8\u8ba4\u7a7a\u5bc6\u7801\uff1b\u5176\u4ed6MySQL 8\u8d26\u6237\u9ed8\u8ba4\u4f7f\u7528caching_sha2_password\u8ba4\u8bc1\u65b9\u5f0f\u3002\u8be6\u89c1MySQL\u5b98\u7f51\u89e3\u91ca\uff1a<a href=\"https:\/\/dev.mysql.com\/doc\/mysql-secure-deployment-guide\/8.0\/en\/secure-deployment-configure-authentication.html\">MySQL :: MySQL Secure Deployment Guide :: 11 Enabling Authentication<\/a><br>\u4fee\u6539MySQL\u8ba4\u8bc1\u65b9\u5f0f\u64cd\u4f5c\u6b65\u9aa4\u53c2\u8003\u4fee\u6539MariaDB\u8ba4\u8bc1\u65b9\u5f0f\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>PHP\u5b89\u88c5php-mysql PDO\u6a21\u5757\u4ee5\u8bbf\u95eeMariaDB\/MySQL<\/strong><br><mark style=\"background-color:#9DFF20\" class=\"has-inline-color\"><code>apt install php-mysql<\/code><\/mark><\/p>\n","protected":false},"excerpt":{"rendered":"<p>LNMP\u662fLinux+Nginx+MariaDB\/MySQL+PHP\u73af\u5883\u7684\u7f29\u5199\uff0c\u6309\u7167\u53d1\u97f3\uff0c\u4e5f\u5199\u4f5cLEMP\u73af\u5883\u3002\u672c\u6587\u8bb2\u8ff0\u5982\u4f55\u5728Ubuntu 22.04\u4e2d\u5b89\u88c5\u548c\u914d\u7f6eNginx+MariaDB\/MySQL+PHP\u3002 \u786c\u4ef6\u73af\u5883 Lenovo ThinkPad T14 Gen2 20W1S3H811: Intel i5-1145G7 + DDR4 16GB + NVMe 512GB \u8f6f\u4ef6\u73af\u5883 Win11 x64 Build 22621.2134 \u82f1\u6587\u4e13\u4e1a\u7248 + VirtualBox v7.0.8 r156879 VirtualBox\u5b89\u88c5Xubuntu 22.04 Xubuntu\u662f\u57fa\u4e8eUbuntu\u7684Linux\u53d1\u884c\u7248\uff0c\u91c7\u7528\u8f7b\u91cf\u7ea7\u7684XFce\u684c\u9762\u73af\u5883\uff0c\u5e76\u5bf9\u4f4e\u7aef\u8ba1\u7b97\u673a\u505a\u4e86\u4f18\u5316\u3002\u672c\u6587\u540e\u9762\u63d0\u5230Ubuntu\u65f6\uff0c\u9664\u975e\u660e\u786e\u6307\u51fa\uff0c\u5426\u5219\u5747\u9ed8\u8ba4\u662fXubuntu\u3002 \u4e3a\u51cf\u5c11\u5b89\u88c5\u65f6\u95f4\u548c\u907f\u514d\u9ebb\u70e6\uff0c\u5b89\u88c5\u65f6\u9009English\u4f5c\u4e3a\u7cfb\u7edf\u8bed\u8a00\uff0c\u9009\u62e9Minimal Installation\u6700\u5c0f\u5b89\u88c5\uff0c\u57ce\u5e02\u9009\u9ed8\u8ba4\u7684New York\u7ebd\u7ea6\u3002 Ubuntu 22.04\u51c6\u5907\u5de5\u4f5c \u542f\u7528root\u8d26\u6237Ubuntu\u9ed8\u8ba4\u6ca1\u6709\u542f\u7528root\u8d26\u6237\u3002\u5728\u751f\u4ea7\u73af\u5883\u4e2d\uff0c\u5f3a\u70c8\u5efa\u8bae\u975e\u5fc5\u8981\u4e0d\u8981\u542f\u7528root\u8d26\u6237\u3002\u672c\u6587\u4ec5\u4e3a\u65b9\u4fbf\u800c\u542f\u7528\u4e86root\u8d26\u6237\uff0c\u540e\u7eedShell\u547d\u4ee4\u9ed8\u8ba4\u5747\u4ee5root\u8d26\u53f7\u8fd0\u884c\u3002\u5728Ubuntu\u4e2d\u542f\u7528root\u8d26\u6237\u975e\u5e38\u7b80\u5355\uff0c\u4e3a\u5176\u8bbe\u7f6e\u5bc6\u7801\u5373\u53ef\u3002passwd root APT\u6362\u56fd\u5185\u6e90Ubuntu\u7684\u5305\u7ba1\u7406\u5668APT\u9ed8\u8ba4\u7684\u6e90\u5728\u56fd\u5916\uff0c\u4ece\u56fd\u5185\u8bbf\u95ee\u901f\u5ea6\u5f88\u6162\u3002\u4e3a\u65b9\u4fbf\u4f7f\u7528\uff0c\u6709\u5fc5\u8981\u4e3aAPT\u6362\u56fd\u5185\u6e90\u3002\u5e38\u7528\u7684\u6709\u963f\u91cc\u6e90\u3001\u6e05\u534e\u6e90\u3001\u4e2d\u79d1\u5927\u6e90\u3001\u7f51\u6613163\u6e90\u7b49\u3002\/etc\/apt\/sources.list\u6587\u4ef6\u8bb0\u5f55\u7740APT\u7684\u6e90\uff0c\u7f16\u8f91\u6b64\u6587\u4ef6\u5373\u53ef\u4f7f\u7528\u4e0d\u540c\u7684\u6e90\u3002mv \/etc\/apt\/sources.list \/etc\/apt\/source.list.original # \u5907\u4efdsources.listtouch \/etc\/apt\/sources.list # \u521b\u5efa\u7a7a\u6587\u4ef6sources.listvi \/etc\/apt\/sources.list # \u7f16\u8f91sources.list\uff0c\u5f55\u5165\u4ee5\u4e0b\u5185\u5bb9# \u9ed8\u8ba4\u6ce8\u91ca\u4e86\u6e90\u7801\u955c\u50cf\u4ee5\u63d0\u9ad8 apt update \u901f\u5ea6\uff0c\u5982\u6709\u9700\u8981\u53ef\u81ea\u884c\u53d6\u6d88\u6ce8\u91ca# \u963f\u91cc\u6e90deb https:\/\/mirrors.aliyun.com\/ubuntu\/ jammy main [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=\/wp\/v2\/posts\/5","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5"}],"version-history":[{"count":7,"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=\/wp\/v2\/posts\/5\/revisions"}],"predecessor-version":[{"id":178,"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=\/wp\/v2\/posts\/5\/revisions\/178"}],"wp:attachment":[{"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techblog.hxdy2013.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}