mysql8安装

安装依赖

yum install libaio wget -y

查看是否已经安装mysql,若已安装先卸载

yum list installed |grep mysql

下载

wget http://repo.mysql.com/mysql80-community-release-el7-1.noarch.rpm

yum localinstall mysql80-community-release-el7-1.noarch.rpm

查看是否下载成功

yum repolist enabled |grep "mysql.*-community.*"

安装

yum install mysql-community-server -y

提示Complete!后安装成功

查看安装目录

whereis mysql

启动服务

systemctl start mysqld

查看mysql进程

ps -ef | grep mysql

也可以查询mysql状态

systemctl status mysqld

设置开机启动项

systemctl enable mysqld

查看初始密码

/cat/var/log/mysqld.log |grep password

进入mysql

mysql -u root -p

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY'12345678‘;

这时会报错，是因为mysql密码安全策略问题

解决办法:

先把密码修改为复杂密码，如ALTER USER 'root'@'localhost' IDENTIFIED BY'mysql_123MYSQL';

set global validate_password.policy=0;

修改成功后，再把密码修改为想要的简单密码ALTER USER 'root'@'localhost' IDENTIFIED BY'12345678';

刷新权限表

flush privileges;

navicat可能还连接失败

use mysql;

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

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123';

flush privileges;