red6.4 mysql_Red Hat 6.4下安装mysql5.7.23

linux版本为：Red Hat Enterprise Linux Server release 6.4

wget https://repo.mysql.com//mysql57-community-release-el6-10.noarch.rpm

rpm -ivh mysql57-community-release-el6-10.noarch.rpm

yum install -y mysql-community-server

Dependencies Resolved

==================================================================================================================

Package Arch Version Repository Size

==================================================================================================================

Installing:

mysql-community-server x86_64 5.7.23-1.el6 mysql57-community 153 M

Installing for dependencies:

mysql-community-client x86_64 5.7.23-1.el6 mysql57-community 23 M

mysql-community-common x86_64 5.7.23-1.el6 mysql57-community 332 k

mysql-community-libs x86_64 5.7.23-1.el6 mysql57-community 2.1 M

Transaction Summary

==================================================================================================================

Install 4 Package(s)

Total download size: 178 M

启动时显示初始化失败：

[root@redhat2 ~]# service mysqld start

初始化 MySQL 数据库：                                      [失败]

mysql版本为：5.7.23

查看报错日志：

2018-09-02T04:16:07.681689Z 1 [ERROR] Failed to open the bootstrap file /var/lib/mysql-files/install-validate-password-plugin.Gkohex.sql

2018-09-02T04:16:07.681704Z 1 [ERROR] 1105  Bootstrap file error, return code (0). Nearest query: 'LSE SET @sys.tmp.table_exists.SQL = CONCAT('SELECT COUNT(*) FROM `', in_db, '`.`', in_table, '`'); PREPARE stmt_select FROM @sys.tmp.table_exists.SQL; IF (NOT v_error) THEN DEALLOCATE PREPARE stmt_select; SET out_exists = 'TEMPORARY'; END IF; END IF; END;

'

2018-09-02T04:16:07.681866Z 0 [ERROR] Aborting

################################

两种解决方式：

方法1.vi /tmp/mysql-init.txt

UPDATE mysql.user SET authentication_string = PASSWORD('p@ssw0rd')

WHERE User = 'root' AND Host = 'localhost';

FLUSH PRIVILEGES;

通过 mysqld_safe启动:

mysqld_safe --init-file=/tmp/mysql-init.txt

重启检查密码设置是否生效:

service mysqld stop

service mysqld start

chkconfig mysqld on

Test root's password with mysql CLI:

mysql -u root -p

方法2：mysql安全模式 通过skip-grant-tables跳过设置，启动后再设置密码：

killall -TERM mysqld

mysqld_safe--skip-grant-tables &

mysql> use mysql

update user set authentication_string=PASSWORD('123456') where user='root';

mysql> FLUSH PRIVILEGES;