{"id":2290,"date":"2017-10-26T14:03:28","date_gmt":"2017-10-26T06:03:28","guid":{"rendered":"http:\/\/learn-house.idv.tw\/?p=2290"},"modified":"2017-10-27T18:29:02","modified_gmt":"2017-10-27T10:29:02","slug":"raspberry-pi-3-ubuntu-mate-16-04-apache-php-7-and-mysql%e5%ae%89%e8%a3%9d","status":"publish","type":"post","link":"https:\/\/learn-house.idv.tw\/?p=2290","title":{"rendered":"[Raspberry Pi 3] Ubuntu-mate 16.04 Apache, PHP 7\u548cMySQL\u5b89\u88dd"},"content":{"rendered":"

\u7576\u521d\u8cb7\u6a39\u6885\u6d3e\u5c31\u662f\u60f3\u8981\u67b6\u4e00\u53f0\u5c0f\u578b\u4e0d\u5360\u7a7a\u9593\uff0c\u53c8\u7701\u96fb\u7684\u4e00\u53f0Server
\n\u9996\u8981\u5de5\u4f5c\u5c31\u662f\u628a\u6211\u7684Blog\u79fb\u56de\u4f86\u81ea\u5df1\u7ba1\u7406\uff0c\u6240\u4ee5LAMP(Linux, Apache, MySQL, PHP)\u662f\u5fc5\u8981\u7684<\/p>\n

\u5b89\u88ddMySQL<\/h2>\n\n\n\n
\n
#apt-get -y install mysql-server mysql-client<\/div>\n
\u4e0b\u5217\u7684\u984d\u5916\u5957\u4ef6\u5c07\u88ab\u5b89\u88dd\uff1a
\nlibaio1 libcgi-fast-perl libcgi-pm-perl libevent-core-2.0-5 libfcgi-perl libhtml-template-perl linux-firmware mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server-5.7
\nmysql-server-core-5.7
\n\u5efa\u8b70\u5957\u4ef6\uff1a
\nlibipc-sharedcache-perl mailx tinyca
\n\u4e0b\u5217\u3010\u65b0\u3011\u5957\u4ef6\u5c07\u6703\u88ab\u5b89\u88dd\uff1a
\nlibaio1 libcgi-fast-perl libcgi-pm-perl libevent-core-2.0-5 libfcgi-perl libhtml-template-perl mysql-client mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server
\nmysql-server-5.7 mysql-server-core-5.7
\n\u4e0b\u5217\u5957\u4ef6\u5c07\u6703\u88ab\u5347\u7d1a\uff1a
\nlinux-firmware<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n


\nMySQL\u7684\u5b89\u5168\u6027\u8a2d\u5b9a\uff0c\u53ef\u4ee5\u53c3\u8003\u6211\u6a19\u8a3b\u70ba\u7d05\u8272<\/span>\u7684\u8a2d\u5b9a<\/p>\n\n\n\n
\n
\n

#mysql_secure_installation<\/p>\n

Securing the MySQL server deployment.<\/p>\n

Enter password for user root:<\/p>\n

VALIDATE PASSWORD PLUGIN can be used to test passwords
\nand improve security. It checks the strength of password
\nand allows the users to set only those passwords which are
\nsecure enough. Would you like to setup VALIDATE PASSWORD plugin?<\/p>\n

Press y|Y for Yes, any other key for No: n<\/strong><\/span>
\nUsing existing password for root.
\nChange the password for root ? ((Press y|Y for Yes, any other key for No) : n<\/strong><\/span><\/p>\n

… skipping.
\nBy default, a MySQL installation has an anonymous user,
\nallowing anyone to log into MySQL without having to have
\na user account created for them. This is intended only for
\ntesting, and to make the installation go a bit smoother.
\nYou should remove them before moving into a production
\nenvironment.<\/p>\n

Remove anonymous users? (Press y|Y for Yes, any other key for No) : y<\/strong><\/span>
\nSuccess.<\/p>\n

Normally, root should only be allowed to connect from
\n‘localhost’. This ensures that someone cannot guess at
\nthe root password from the network.<\/p>\n

Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y<\/strong><\/span>
\nSuccess.<\/p>\n

By default, MySQL comes with a database named ‘test’ that
\nanyone can access. This is also intended only for testing,
\nand should be removed before moving into a production
\nenvironment.<\/p>\n

Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y<\/strong><\/span>
\n– Dropping test database…
\nSuccess.<\/p>\n

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

Reloading the privilege tables will ensure that all changes
\nmade so far will take effect immediately.<\/p>\n

Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y<\/strong><\/span>
\nSuccess.<\/p>\n

All done!<\/p>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u5b89\u88ddApache<\/h2>\n\n\n\n
\n
#apt-get -y install apache2<\/div>\n
\u4e0b\u5217\u7684\u984d\u5916\u5957\u4ef6\u5c07\u88ab\u5b89\u88dd\uff1a
\napache2-bin apache2-data apache2-utils libapr1 libaprutil1 libaprutil1-dbd-sqlite3 libaprutil1-ldap liblua5.1-0
\n\u5efa\u8b70\u5957\u4ef6\uff1a
\napache2-doc apache2-suexec-pristine | apache2-suexec-custom
\n\u4e0b\u5217\u3010\u65b0\u3011\u5957\u4ef6\u5c07\u6703\u88ab\u5b89\u88dd\uff1a
\napache2 apache2-bin apache2-data apache2-utils libapr1 libaprutil1 libaprutil1-dbd-sqlite3 libaprutil1-ldap liblua5.1-0<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u5b89\u88ddPHP 7<\/h2>\n\n\n\n
\n
#apt-get -y install php7.0 libapache2-mod-php7.0<\/div>\n
\u4e0b\u5217\u7684\u984d\u5916\u5957\u4ef6\u5c07\u88ab\u5b89\u88dd\uff1a
\nphp-common php7.0-cli php7.0-common php7.0-json php7.0-opcache php7.0-readline
\n\u5efa\u8b70\u5957\u4ef6\uff1a
\nphp-pear
\n\u4e0b\u5217\u3010\u65b0\u3011\u5957\u4ef6\u5c07\u6703\u88ab\u5b89\u88dd\uff1a
\nlibapache2-mod-php7.0 php-common php7.0 php7.0-cli php7.0-common php7.0-json php7.0-opcache php7.0-readline<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u4f7fMySQL\u652f\u63f4PHP<\/h2>\n\n\n\n
\n
#apt-get -y install php7.0-mysql php7.0-curl php7.0-gd php7.0-intl php-pear php-imagick php7.0-imap php7.0-mcrypt php-memcache php7.0-pspell php7.0-recode php7.0-sqlite3 php7.0-tidy php7.0-xmlrpc php7.0-xsl php7.0-mbstring php-gettext<\/div>\n
\u4e0b\u5217\u7684\u984d\u5916\u5957\u4ef6\u5c07\u88ab\u5b89\u88dd\uff1a
\nlibc-client2007e libmcrypt4 librecode0 libtidy-0.99-0 libxmlrpc-epi0 mlock php-xml php7.0-xml ttf-dejavu-core
\n\u5efa\u8b70\u5957\u4ef6\uff1a
\nuw-mailutils libmcrypt-dev mcrypt memcached
\n\u4e0b\u5217\u3010\u65b0\u3011\u5957\u4ef6\u5c07\u6703\u88ab\u5b89\u88dd\uff1a
\nlibc-client2007e libmcrypt4 librecode0 libtidy-0.99-0 libxmlrpc-epi0 mlock php-gettext php-imagick php-memcache php-pear php-xml php7.0-curl php7.0-gd
\nphp7.0-imap php7.0-intl php7.0-mbstring php7.0-mcrypt php7.0-mysql php7.0-pspell php7.0-recode php7.0-sqlite3 php7.0-tidy php7.0-xml php7.0-xmlrpc php7.0-xsl ttf-dejavu-core<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u5b89\u88ddphpMyAdmin<\/h2>\n\n\n\n
\n
#apt-get -y install phpmyadmin<\/div>\n
\u4e0b\u5217\u7684\u984d\u5916\u5957\u4ef6\u5c07\u88ab\u5b89\u88dd\uff1a
\ndbconfig-common dbconfig-mysql libjs-sphinxdoc libjs-underscore php-phpseclib php-tcpdf
\n\u5efa\u8b70\u5957\u4ef6\uff1a
\nphp-libsodium php-gmp
\n\u4e0b\u5217\u3010\u65b0\u3011\u5957\u4ef6\u5c07\u6703\u88ab\u5b89\u88dd\uff1a
\ndbconfig-common dbconfig-mysql libjs-sphinxdoc libjs-underscore php-phpseclib php-tcpdf phpmyadmin<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u5b89\u88dd\u904e\u7a0b\u81ea\u52d5\u5e36\u51fa\u8a2d\u5b9a\uff0c\u4e00\u6a23\u53ef\u4ee5\u53c3\u8003\u6211\u6a19\u8a3b\u70ba\u7d05\u8272<\/span>\u7684\u8a2d\u5b9a<\/p>\n\n\n\n
\n
Please choose the web server that should be automatically configured to run phpMyAdmin.
\nWeb server to reconfigure automatically: apache2<\/strong><\/span><\/div>\n
The phpmyadmin package must have a database installed and configured before it can be used. This can be optionally handled with dbconfig-common.
\nIf you are an advanced database administrator and know that you want to perform this configuration manually, or if your database has already been
\ninstalled and configured, you should refuse this option. Details on what needs to be done should most likely be provided in \/usr\/share\/doc\/phpmyadmin.
\nOtherwise, you should probably choose this option.
\nConfigure database for phpmyadmin with dbconfig-common? Yes<\/strong><\/span><\/div>\n
Please provide a password for phpmyadmin to register with the database server. If left blank, a random password will be generated.
\nMySQL application password for phpmyadmin: ********<\/strong><\/span><\/div>\n
Password confirmation: ********<\/strong><\/span><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u91cd\u555fApache<\/p>\n\n\n\n
\n
#systemctl restart apache2<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u7ba1\u7406\u7db2\u5740
\nhttp:\/\/10.0.0.49\/phpmyadmin<\/p>\n

\u53e6\u5916\u5b89\u88dd<\/h2>\n

\u5b89\u88ddOpcache + APCu PHP cache\u4f86\u52a0\u901fPHP
\napt-get -y install php7.0-opcache php-apcu<\/p>\n

\u555f\u52d5SSL
\na2enmod ssl
\na2ensite default-ssl<\/p>\n","protected":false},"excerpt":{"rendered":"

\u7576\u521d\u8cb7\u6a39\u6885\u6d3e\u5c31\u662f\u60f3\u8981\u67b6\u4e00\u53f0\u5c0f\u578b\u4e0d\u5360\u7a7a\u9593\uff0c\u53c8\u7701\u96fb\u7684\u4e00\u53f0Server \u9996\u8981\u5de5\u4f5c\u5c31\u662f\u628a\u6211\u7684Blog\u79fb\u56de\u4f86\u81ea\u5df1\u7ba1\u7406\uff0c\u6240…<\/span><\/p>\n

Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-2290","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/learn-house.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/2290","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learn-house.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learn-house.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learn-house.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learn-house.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2290"}],"version-history":[{"count":0,"href":"https:\/\/learn-house.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/2290\/revisions"}],"wp:attachment":[{"href":"https:\/\/learn-house.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learn-house.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2290"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learn-house.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}