CentOS 7 安装MySQL5.7 踩坑集合

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
解决方案：在/etc/my.cnf的[mysqld]配置文件添加：explicit_defaults_for_timestamp=true

/usr/local/mysql/bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
解决方案：yum install libaio

启动mysql报错mysqld_safe error: log-error set to '/var/log/mariadb/mariadb.log’
解决方案：

mkdir /var/log/mariadb
touch /var/log/mariadb/mariadb.log
chown<