linux CentOS 7 安装mysql5.7 遇到的问题
mysql 5.7.19;官网下载地址:http://dev.mysql.com/downloads/mysql/
安装过程参考:http://blog.****.net/shuai825644975/article/details/54315424
安装问题:
1、执行 sudo rpm -ivh --force mysql-xxxx 命令
报错:error: Failed dependencies: xxx
在命令后加:--nodeps --force;如:sudo rpm -ivh --force mysql-community-libs-5.7.19-1.el6.x86_64.rpm --nodeps --force
2、启动、停止、重启命令
systemctl start mysqld
systemctl stop mysqld
systemctl restart mysqld
-----------------------------------------------------------------------------------------------------
启动问题:
启动可能会提示:Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
可执行systemctl status mysqld.servic 或journalctl -xe 查看详情
1、没有libaio.so.1包
/usr/sbin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
64位系统安装:
wget http://mirror.centos.org/centos/6/os/x86_64/Packages/libaio-0.3.107-10.el6.x86_64.rpm
rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm
32位系统安装(yum默认安装32位):
yum install libaio.so.1
2、explicit_defaults_for_timestamp
TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp serve
修改my.conf文件
路径:/etc/my.conf
增加一句:explicit_defaults_for_timestamp=true
3、数据空间已有东西存在
--initialize specified but the data directory has files in it. Aborting.
查看并进入/etc/my.cnf文件的datadir配置路径
我是新装mysql,所以直接删除全部;如果你已有数据存在,请做好备份
以上异常、警告解决后,mysql可以正常启动