mysql5.7 安装错误解决

1、5.7初始化报错

2019-04-29 21:40:34 [ERROR]   Child process: /home/work/mysql/bin/mysqldterminated prematurely with errno= 32
2019-04-29 21:40:34 [ERROR]   Failed to execute /home/work/mysql/bin/mysqld --defaults-file=/home/work/mysql/etc/my.cnf --bootstrap --

 解决方法: /home/work/mysql/bin/mysqld --defaults-file=/home/work/mysql/etc/my.cnf --basedir=/home/work/mysql --datadir=/home/work/mysql/data --user=root --initialize

2、缺模块报错

/home/work/mysql/bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

 解决方法:yum install libaio -y

3、主机禁止链接问题: 

use mysql
update user set host = '%' where user = 'root';

flush privileges;

  

原文地址:https://www.cnblogs.com/tengfei520/p/10793126.html