max_connections in mysqld.cnf not change from 214 in ubuntu 16.04 mysql 5.7

[golfreeze]

วันนี้เจอเคส เมื่อ
max_connections in mysqld.cnf not change from 214 in ubuntu 16.04 mysql 5.7

#### Begin Fixed max_connections =5120 in /etc/mysql/mysql.conf.d/mysqld.cnf ####
Follow the following steps:

cp /lib/systemd/system/mysql.service /etc/systemd/system/
echo -e "\r\nLimitNOFILE=infinity" >> /etc/systemd/system/mysql.service
echo "LimitMEMLOCK=infinity" >> /etc/systemd/system/mysql.service
sudo systemctl daemon-reload
sudo service mysql restart
And change or add he following line into file /etc/mysql/mysql.conf.d/mysqld.cnf :

[mysqld]
max_connections=110
#### Finish Fixed max_connections =5120 in /etc/mysql/mysql.conf.d/mysqld.cnf ####