/usr/sbin/mysqld error on realpath() on '/var/lib/mysql-files' (error 2)

登录网站出现:
Unable to connect to database: mysql_connect(): No such file or directory /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
查看服务器日志出现:


# /usr/sbin/mysqld stop
161215 17:21:29 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
/usr/sbin/mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2)
161215 17:21:29 [ERROR] Failed to access directory for --secure-file-priv. Please make sure that directory exists and is accessible by MySQL Server. Supplied value : /var/lib/mysql-files
161215 17:21:29 [ERROR] Aborting


导致原因:

/var/lib/mysql-files目录丢失,linux下自动更新mysql导致的问题:https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/1637280

解决办法:

# sudo mkdir /var/lib/mysql-files
# sudo chown -R mysql:mysql /var/lib/mysql-files/
# sudo chmod 700 /var/lib/mysql-files/