2019年12月26日 星期四

Ubuntu 18.04 apache2+mysql+php-fpm

hdd
/                16G
/var/www   60G
/Mysql       40G

sudo apt update
sudo apt upgrade

sudo apt install htop iotop iftop mytop
sudo apt install samba

sudo vim /etc/samba/smb.conf
[TMP]
        path = /tmp
        read only = no
        guest ok = yes
sudo service smbd restart

sudo tzselect
sudo cp /usr/share/zoneinfo/Asia/Taipei  /etc/localtime

sudo apt install mysql-server
sudo mysql_secure_installation

In Ubuntu systems running MySQL 5.7 (and later versions), the root MySQL user is set to authenticate using the auth_socket plugin by default rather than with a password.

sudo mysql -u root -p
mysql> SELECT user,authentication_string,plugin,host FROM mysql.user;

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

mysql> FLUSH PRIVILEGES;

mysql> SELECT user,authentication_string,plugin,host FROM mysql.user;

新增使用者
mysql>create user 'demo'@'%' identified by '1qaz2wsx';
mysql>grant all privileges on *.* to 'demo'@'%' with grant option;

sudo apt install apache2 libapache2-mod-fcgid
sudo apt install php7.2-fpm
sudo a2enmod proxy_fcgi
sudo a2enconf php7.2-fpm
sudo apt install phpmyadmin
編輯apache 站台定檔,在
<VirtualHost *:80>
.........
</VirtualHost>
內加上以下這段
<FilesMatch \.php$>
        SetHandler "proxy:unix:/var/run/php/php7.2-fpm.sock|fcgi://localhost"
</FilesMatch>
存檔離開後重新啟動apache2
sudo service apache2 restart

php-fpm開機自動啟動
systemctl enable php7.2-fpm