mysql常见启动错误

1、[ERROR] --initialize specified but the data directory has files in it. Aborting.
======》初始化数据库目录存在
解决：rm -rf /var/lib/mysql/*
2、 Failed to get stat for directory pointed out by --secure-file-priv
=======>mysql导出数据时出现–secure-file-priv
解决：vim /etc/my.cnf (数据库配置文件)
secure-file-priv="/" (即可将数据导出到任意目录)
3、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 ===》/var/lib/mysql-files 文件是否存在或者权限问题
解决：touch /var/lib/mysql-files
chown mysql.mysql /var/lib/mysql-files