linux LNMP快速安装

check list:

1. lnmp: config nginx for rewrite:

wget -c http://soft.vpser.net/lnmp/lnmp1.4.tar.gz && tar zxf lnmp1.4.tar.gz && cd lnmp1.4 && ./install.sh lnmp
 (mysql: 5.7.18, pwd:ygmlxomlg php:7.0.21)

2. create database & user, import data

CREATE DATABASE 1052club CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE USER '1052club_root'@'localhost' IDENTIFIED BY '1052club@123';

GRANT ALL PRIVILEGES ON *.* TO '1052club_root'@'localhost';
GRANT ALL PRIVILEGES ON *.* TO '1052club_root'@'localhost' IDENTIFIED BY '1052club@123' WITH GRANT OPTION

安全组开启3306

NAVICAT连不上：
 
查看ssh连接报错 journalctl --unit sshd --no-pager
如果：error: kex protocol error: type 30 seq 1 [preauth]
cd /ect/ssh
vim ssh_config  
添加一行：
KexAlgorithms curve25519-sha256@libssh.org,ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group14-sha1
重启ssh：
systemctl restart sshd