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;

  

posted @ 2019-04-29 21:52  tengfei520  阅读(2153)  评论(0编辑  收藏  举报