Ubuntu 16.04 Update Problems: MySQL, Redis Server

[morris821028]

Redis Server

You may got the error message when you start with redis server. Please check the port 6379 usage first, and then check redis setting in host OS.

https://bugs.launchpad.net/ubuntu/+source/redis/+bug/1663911

    $ sudo su
    $ mkdir /etc/systemd/system/redis-server.service.d/
    $ cd /etc/systemd/system/redis-server.service.d/
    $ echo '[Service]' > redis.override.conf
    $ echo 'PrivateDevices=no' >> redis.override.conf

MySQL grouping

Please degrade your MySQL version into 5.6. There are some SQL query sentences written by me as web beginner. If you don't want to change MySQL server, remove group feature from MySQL configuration.

https://stackoverflow.com/questions/23921117/disable-only-full-group-by

https://blog.csdn.net/helloxiaozhe/article/details/78570016

https://blog.csdn.net/u283056051/article/details/52463948