apt-get install bison flex texinfo
sudo apt-get install libgmp-dev
CREATE USER 'username'@'192.168.0.5' IDENTIFIED BY 'password'
username 你要創建的帳號 password 密碼 192.168.0.5 改成本機ip
GRANT ALL PRIVILEGES ON db_name.* TO 'username'@'192.168.0.%';
db_name 你要連的db
192.168.0.5 ifconfig cmd
nano /etc/mysql/mysql.conf.d/mysqld.cnf
bind-address = 127.0.0.1
修改成你的主機ip
bind-address = 192.168.1.20
重啟mysql service mysql restart
mysql -h 192.168.1.20 -u account -p
本機連線成功即可再試遠端主機 account是你剛剛創建的帳號
; Enable Zend OPcache extension module zend_extension=/usr/lib64/php/modules/opcache.so opcache.enable=1 opcache.enable_cli=1 opcache.memory_consumption=128 opcache.interned_strings_buffer=8 opcache.max_accelerated_files=4000 opcache.revalidate_freq=60 opcache.fast_shutdown=1opcache.so