{"id":474,"date":"2025-02-24T21:54:05","date_gmt":"2025-02-24T13:54:05","guid":{"rendered":"http:\/\/113.45.254.23\/?p=474"},"modified":"2025-02-24T21:54:05","modified_gmt":"2025-02-24T13:54:05","slug":"ubuntu%e4%b8%8b%e5%ae%89%e8%a3%85lamp-linux-apache-mariadb-php","status":"publish","type":"post","link":"http:\/\/113.45.254.23\/?p=474","title":{"rendered":"Ubuntu\u4e0b\u5b89\u88c5LAMP Linux Apache Mariadb PHP"},"content":{"rendered":"\n

Linux<\/p>\n\n\n\n

Apache \u7f51\u7ad9<\/p>\n\n\n\n

Mariadb \u6570\u636e\u5e93<\/p>\n\n\n\n

PHP \u5f00\u53d1\u8bed\u8a00<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

root@server100:~# apt update \u66f4\u65b0\u7cfb\u7edf<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

root@server100:~# apt install apache2 \u5b89\u88c5\u963f\u5e15\u59472<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n

root@server100:~# systemctl is-enabled apache2 \u542f\u52a8\u963f\u5e15\u59472\uff0c\u5e76\u8bbe\u7f6e\u5f00\u673a\u542f\u52a8<\/p>\n\n\n\n

enabled<\/p>\n\n\n\n

root@server100:~# systemctl status apache2 \u67e5\u770b\u963f\u5e15\u59472\u7684\u72b6\u6001<\/p>\n\n\n\n

\u25cf apache2.service – The Apache HTTP Server<\/p>\n\n\n\n

     Loaded: loaded (\/usr\/lib\/systemd\/system\/apache2.service; enabled; preset: enabled)<\/p>\n\n\n\n

     Active: active (running) since Fri 2025-02-07 08:51:49 CST; 1min 26s ago           active \u6d3b\u52a8\u7684(running) \u6b63\u5728\u8fd0\u884c<\/p>\n\n\n\n

root@server100:~# ufw allow ‘Apache Full’  \u9632\u706b\u5899\u5141\u8bb8\u963f\u5e15\u5947\u901a\u8fc7<\/p>\n\n\n\n

Rules updated<\/p>\n\n\n\n

Rules updated (v6)<\/p>\n\n\n\n

root@server100:~# ufw status   \u67e5\u770b\u9632\u706b\u5899\u7684\u72b6\u6001<\/p>\n\n\n\n

Status: inactive      \u72b6\u6001\u662f\u4e0d\u6d3b\u8dc3\u7684\uff08\u5173\u95ed\uff09<\/p>\n\n\n\n

root@server100:~# ufw enable \u5f00\u542f\u9632\u706b\u5899<\/p>\n\n\n\n

Command may disrupt existing ssh connections. Proceed with operation (y|n)? y       \u547d\u4ee4\u6709\u53ef\u80fd\u4f1a\u4e2d\u65ad\u672c\u6b21ssh\u7684\u8fde\u63a5\uff0c\u662f\u5426\u7ee7\u7eed<\/p>\n\n\n\n

Firewall is active and enabled on system startup<\/p>\n\n\n\n

root@server100:~#<\/p>\n\n\n\n

root@server100:~# ufw status <\/p>\n\n\n\n

Status: active<\/p>\n\n\n\n

To                         Action      From<\/p>\n\n\n\n

—                         ——      —-<\/p>\n\n\n\n

Apache Full                ALLOW       Anywhere                  <\/p>\n\n\n\n

Apache Full (v6)           ALLOW       Anywhere (v6)             <\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

root@server100:~# ufw allow ssh \u9632\u706b\u5899\u5141\u8bb8ssh\u8fdc\u7a0b\u8bbf\u95ee<\/p>\n\n\n\n

Rule added<\/p>\n\n\n\n

Rule added (v6)<\/p>\n\n\n\n

root@server100:~# ufw status<\/p>\n\n\n\n

Status: active<\/p>\n\n\n\n

To                         Action      From<\/p>\n\n\n\n

—                         ——      —-<\/p>\n\n\n\n

Apache Full                ALLOW       Anywhere         ipv4\u7684\u653e\u884c         <\/p>\n\n\n\n

22\/tcp                     ALLOW       Anywhere                  <\/p>\n\n\n\n

Apache Full (v6)           ALLOW       Anywhere (v6)        ipv6\u7684\u653e\u884c     <\/p>\n\n\n\n

22\/tcp (v6)                ALLOW       Anywhere (v6)       <\/p>\n\n\n\n

root@server100:~# apt install mariadb-server \u5b89\u88c5\u6570\u636e\u5e93\u7684\u670d\u52a1\u7aef<\/p>\n\n\n\n

root@server100:~# systemctl is-enabled mariadb \u542f\u52a8\u6570\u636e\u5e93\uff0c\u5e76\u8bbe\u7f6e\u5f00\u673a\u542f\u52a8<\/p>\n\n\n\n

enabled<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

root@server100:~# systemctl status mariadb  \u67e5\u770b\u6570\u636e\u5e93\u7684\u72b6\u6001<\/p>\n\n\n\n

\u25cf mariadb.service – MariaDB 10.11.8 database server<\/p>\n\n\n\n

     Loaded: loaded (\/usr\/lib\/systemd\/system\/mariadb.service; enabled; preset: enabled)<\/p>\n\n\n\n

     Active: active (running) since Fri 2025-02-07 09:13:22 CST; 1min 11s ago<\/p>\n\n\n\n

root@server100:~# mysql_secure_installation  \u6570\u636e\u5e93\u7684\u5b89\u5168\u8bbe\u7f6e<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB<\/p>\n\n\n\n

      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!<\/p>\n\n\n\n

In order to log into MariaDB to secure it, we’ll need the current<\/p>\n\n\n\n

password for the root user. If you’ve just installed MariaDB, and<\/p>\n\n\n\n

haven’t set the root password yet, you should just press enter here.<\/p>\n\n\n\n

Enter current password for root (enter for none):<\/p>\n\n\n\n

OK, successfully used password, moving on…<\/p>\n\n\n\n

Setting the root password or using the unix_socket ensures that nobody<\/p>\n\n\n\n

can log into the MariaDB root user without the proper authorisation.<\/p>\n\n\n\n

You already have your root account protected, so you can safely answer ‘n’.<\/p>\n\n\n\n

Switch to unix_socket authentication [Y\/n] n  \u4ea4\u6362\u673a\u5207\u6362\u5230\u63a5\u53e3\u8ba4\u8bc1\u5417\uff1fn<\/p>\n\n\n\n

 … skipping.<\/p>\n\n\n\n

You already have your root account protected, so you can safely answer ‘n’.<\/p>\n\n\n\n

Change the root password? [Y\/n] y    \u66f4\u6539root\u5bc6\u7801\u5417\uff1f<\/p>\n\n\n\n

New password:         \u89c4\u5219\uff1a\u6700\u4f4e8\u4f4d\uff0c\u5e26\u6570\u5b57\uff0c\u5b57\u6bcd\u5927\u5c0f\u5199\uff0c\u7279\u6b8a\u7b26\u53f7<\/p>\n\n\n\n

Re-enter new password:<\/p>\n\n\n\n

Password updated successfully!<\/p>\n\n\n\n

Reloading privilege tables..<\/p>\n\n\n\n

 … Success!<\/p>\n\n\n\n

By default, a MariaDB installation has an anonymous user, allowing anyone<\/p>\n\n\n\n

to log into MariaDB without having to have a user account created for<\/p>\n\n\n\n

them.  This is intended only for testing, and to make the installation<\/p>\n\n\n\n

go a bit smoother.  You should remove them before moving into a<\/p>\n\n\n\n

production environment.<\/p>\n\n\n\n

Remove anonymous users? [Y\/n] y    \u79fb\u9664\u533f\u540d\u7528\u6237\u5417\uff1f<\/p>\n\n\n\n

 … Success!<\/p>\n\n\n\n

Normally, root should only be allowed to connect from ‘localhost’.  This<\/p>\n\n\n\n

ensures that someone cannot guess at the root password from the network.<\/p>\n\n\n\n

Disallow root login remotely? [Y\/n] y    \u7981\u6b62root\u8fdc\u7a0b\u767b\u5f55\u5417\uff1f<\/p>\n\n\n\n

 … Success!<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

By default, MariaDB comes with a database named ‘test’ that anyone can<\/p>\n\n\n\n

access.  This is also intended only for testing, and should be removed<\/p>\n\n\n\n

before moving into a production environment.<\/p>\n\n\n\n

Remove test database and access to it? [Y\/n] y \u79fb\u9664\u6d4b\u8bd5\u6570\u636e\u5e93\u5417\uff1f\uff08\u539f\u56e0\uff1a\u6d4b\u8bd5\u6570\u636e\u5e93\u6cc4\u9732\u4fe1\u606f\uff09<\/p>\n\n\n\n

 – Dropping test database…<\/p>\n\n\n\n

 … Success!<\/p>\n\n\n\n

 – Removing privileges on test database…<\/p>\n\n\n\n

 … Success!<\/p>\n\n\n\n

Reloading the privilege tables will ensure that all changes made so far<\/p>\n\n\n\n

will take effect immediately.<\/p>\n\n\n\n

Reload privilege tables now? [Y\/n] y    \u79fb\u9664\u6d4b\u8bd5\u6570\u636e\u8868\u5417<\/p>\n\n\n\n

 … Success!<\/p>\n\n\n\n

Cleaning up…<\/p>\n\n\n\n

All done!  If you’ve completed all of the above steps, your MariaDB<\/p>\n\n\n\n

installation should now be secure.<\/p>\n\n\n\n

Thanks for using MariaDB!<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

root@server100:~# ufw allow mysql   \u9632\u706b\u5899\u5141\u8bb8\u6570\u636e\u5e93\u901a\u8fc7<\/p>\n\n\n\n

Rule added<\/p>\n\n\n\n

Rule added (v6)<\/p>\n\n\n\n

root@server100:~# ufw status     \u67e5\u770b\u9632\u706b\u5899\u72b6\u6001<\/p>\n\n\n\n

Status: active<\/p>\n\n\n\n

To                         Action      From<\/p>\n\n\n\n

—                         ——      —-<\/p>\n\n\n\n

Apache Full                ALLOW       Anywhere                  <\/p>\n\n\n\n

22\/tcp                     ALLOW       Anywhere                  <\/p>\n\n\n\n

3306\/tcp                   ALLOW       Anywhere               3306\u6570\u636e\u5e93\u7aef\u53e3\u53f7      <\/p>\n\n\n\n

Apache Full (v6)           ALLOW       Anywhere (v6)             <\/p>\n\n\n\n

22\/tcp (v6)                ALLOW       Anywhere (v6)             <\/p>\n\n\n\n

3306\/tcp (v6)              ALLOW       Anywhere (v6)             <\/p>\n\n\n\n

root@server100:~# mysql -u root -p    \u6570\u636e\u5e93\u7ba1\u7406\u5458\u767b\u9646<\/p>\n\n\n\n

Enter password:         \u5bc6\u7801\uff1a1234.comC#<\/p>\n\n\n\n

Welcome to the MariaDB monitor.  Commands end with ; or \\g.<\/p>\n\n\n\n

Your MariaDB connection id is 39<\/p>\n\n\n\n

Server version: 10.11.8-MariaDB-0ubuntu0.24.04.1 Ubuntu 24.04<\/p>\n\n\n\n

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.<\/p>\n\n\n\n

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

MariaDB [(none)]> exit          \u9000\u51fa<\/p>\n\n\n\n

Bye<\/p>\n\n\n\n

root@server100:~# mysql      \u672c\u5730linux\u7cfb\u7edf\u7ba1\u7406\u5458\u767b\u5f55\u6570\u636e\u5e93<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

MariaDB [(none)]> exit       \u9000\u51fa<\/p>\n\n\n\n

Bye<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

root@server100:~# sudo apt install php libapache2-mod-php php-mysql php-curl php-gd php-json php-intl php-bcmath php-opcache php-apcu php-mbstring php-fileinfo php-xml php-soap php-tokenizer php-zip   \u5b89\u88c5php\u7f16\u7a0b\u8bed\u8a00\u53ca\u5176\u63d2\u4ef6<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

root@server100:~# apt install vim    \u5b89\u88c5vim\u7f16\u8f91\u5668<\/p>\n\n\n\n

root@server100:~# vim \/etc\/php\/8.3\/apache2\/php.ini       \u7f16\u8f91php\u7684\u914d\u7f6e\u6587\u4ef6<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

989 date.timezone = Asia\/Shanghai          \u65f6\u533a\uff1a\u4e9a\u6d32\u4e0a\u6d77<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

445 memory_limit = 256M            \u5185\u5b58\u9650\u5236<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

419 max_execution_time = 300           \u6700\u5927\u6267\u884c\u65f6\u95f4 <\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

865 upload_max_filesize = 64M           \u4e0a\u4f20\u6587\u4ef6\u7684\u6700\u5927\u5bb9\u91cf<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

root@server100:~# vim \/var\/www\/html\/info.php       \u7f16\u8f91php\u6d4b\u8bd5\u9875\u9762<\/p>\n\n\n\n

<?php       <\/p>\n\n\n\n

phpinfo();<\/p>\n\n\n\n

?>             \u4e3a\u7f16\u8f91\u6d4b\u8bd5\u9875\u9762\u91cc\u7684\u5185\u5bb9<\/p>\n\n\n\n

root@server100:~# systemctl restart apache2        \u91cd\u542f\u963f\u5e15\u59472<\/p>\n\n\n\n

root@server100:~# cd \/var\/www\/html\/         \u8fdb\u5165\u963f\u5e15\u59472\u7684\u7f51\u7ad9\u76ee\u5f55<\/p>\n\n\n\n

root@server100:\/var\/www\/html# ls          \u67e5\u770b  <\/p>\n\n\n\n

index.html  info.php<\/p>\n\n\n\n

root@server100:\/var\/www\/html# rm -rf info.php        \u5220\u9664php\u7684\u6d4b\u8bd5\u9875\u9762<\/p>\n","protected":false},"excerpt":{"rendered":"

Linux Apache \u7f51\u7ad9 Mariadb \u6570\u636e\u5e93 PHP \u5f00\u53d1\u8bed\u8a00 root@server100:~# […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[30,29,4,31,28],"class_list":["post-474","post","type-post","status-publish","format-standard","hentry","category-linux","tag-apache","tag-lamp","tag-linux","tag-mariadb","tag-ubuntu"],"_links":{"self":[{"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/posts\/474","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/113.45.254.23\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=474"}],"version-history":[{"count":1,"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/posts\/474\/revisions"}],"predecessor-version":[{"id":493,"href":"http:\/\/113.45.254.23\/index.php?rest_route=\/wp\/v2\/posts\/474\/revisions\/493"}],"wp:attachment":[{"href":"http:\/\/113.45.254.23\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=474"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/113.45.254.23\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=474"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/113.45.254.23\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}