［玩转Firefly-RK3399］搭建LNMP服务环境

追求

debian系统中可能不支持apt-add-repository命令，添加系统源需要直接修改sources.list文件或者在sources.list.d/目录下新建文件；

执行如下两命令后：
sudo apt-add-repository ppa:nginx/stable
sudo apt-add-repository ppa:ondrej/php
会在/etc/apt/sources.list.d$目录下生成三个文件：
nginx-ubuntu-stable-xenial.list      
ondrej-ubuntu-php-xenial.list
nginx-ubuntu-stable-xenial.list.save
这几个文件中的内容分别为：
nginx-ubuntu-stable-xenial.list ：
deb http://ppa.launchpad.net/nginx/stable/ubuntu xenial main
# deb-src http://ppa.launchpad.net/nginx/stable/ubuntu xenial main


ondrej-ubuntu-php-xenial.list：
deb http://ppa.launchpad.net/ondrej/php/ubuntu xenial main
# deb-src http://ppa.launchpad.net/ondrej/php/ubuntu xenial main

nginx-ubuntu-stable-xenial.list.save：
deb http://ppa.launchpad.net/nginx/stable/ubuntu xenial main
# deb-src http://ppa.launchpad.net/nginx/stable/ubuntu xenial main

合作可以共同壮大市场，轻松生活；封闭即便不能累死人也能饿死人

追求

不能通过局域网连接mysql呢？

Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:590)
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:57)
        at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1606)
        at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:633)
        at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:347)
        at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:219)
        at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:38)
        ... 29 more
Caused by: com.mysql.cj.core.exceptions.CJCommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54)
        at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:93)
        at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:133)
        at com.mysql.cj.core.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:149)
        at com.mysql.cj.mysqla.io.MysqlaSocketConnection.connect(MysqlaSocketConnection.java:83)
        at com.mysql.cj.mysqla.MysqlaSession.connect(MysqlaSession.java:122)
        at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:1726)
        at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1596)
        ... 33 more
Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.DualStackPlainSocketImpl.connect0(Native Method)
        at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
        at java.net.Socket.connect(Socket.java:589)
        at com.mysql.cj.core.io.StandardSocketFactory.connect(StandardSocketFactory.java:202)
        at com.mysql.cj.mysqla.io.MysqlaSocketConnection.connect(MysqlaSocketConnection.java:57)
        ... 36 more

追求

已经尝试过各种权限设置：
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'myPassword' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.107' IDENTIFIED BY 'myPassword' WITH GRANT OPTION;
CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password AS '***';
GRANT USAGE ON *.* TO 'root'@'%' REQUIRE NONE;

追求

问题找到了，要远程连接mysql，不管要用sql语句赋权，而且要修改配置文件：
sudo /etc/mysql/mysql.conf.d/mysqld.cnf (mysql)
sudo vi /etc/mysql/my.cnf (mariadb)
注释掉下面一行（开头加"#"）
bind-address = 127.0.0.1
修改后变为：
#bind-address = 127.0.0.1

然后重启系统，再次远程连接应该可以成功