$ vim /etc/systemd/system/mysql.service

[Service]
LimitNOFILE  = infinity
LimitCore    = infinity
LimitMEMLOCK = infinity

$ systemctl daemon-reload
$ service mysql restart
$ ps -ef | grep mysql | awk '{print $2}' | head -n1 | xargs -I{} cat /proc/{}/limits