zheng安装 mysql8.04安装

相关参考资料网址：

https://downloads.mysql.com/archives/community/

https://dev.mysql.com/downloads/mysql/

https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html#sysvar_validate_password.policy

一、卸载mysql旧版本

 rpm -qa |grep mysql
 rpm -e --nodeps mysql-devel-5.1.73-8.el6_8.x86_64 mysql-5.1.73-8.el6_8.x86_64 mysql-libs-5.1.73-8.el6_8.x86_64

 

二、安装mysql8.04

 

yum localinstall https://dev.mysql.com/get/mysql57-community-release-el6-11.noarch.rpm
yum --enablerepo=mysql80-community install mysql-community-server -y

三、编辑mysql配置文件

vim /etc/my.cnf

添加如下一行：

<span style="color:#3333ff">default_authentication_plugin=mysql_native_password</span>

四、启动mysql

service mysqld start

五、设置开机启动

chkconfig --levels 235 mysqld on

六、查看生成的随机mysqld数据库密码

grep 'A temporary password is generated for root@localhost' /var/log/mysqld.log |tail -1

输出如下：

<span style="color:#3366ff">2018-02-12T02:52:37.275897Z 5 [Note] [MY-010454] A temporary password is generated for root@localhost: HAtsCZgdt5<A</span>

七、用刚才生成的密码登陆mysql

mysql -uroot -p

八、修改密码策略

set global validate_password.policy=0;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'zsl@123456';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'zsl@123456' WITH GRANT OPTION;
FLUSH PRIVILEGES

 

九、使用MySQL Workbench软件将uac数据导入到mysql数据库中。