Installing MySQL on Linux Using the MySQL Yum Repository
1.下载yum Repository
MySQL Yum Repository
选择和下载release package
2.下载的是基于EL7-based 系统
yum localinstall mysql80-community-release-el7-2.noarch.rpm
3.查询enabled 的仓库
yum repolist enabled | grep "mysql.-community."
4.通过下面命令安装mysql
yum install mysql-community-server
5.通过命令启动mysql
systemctl start mysqld
6.通过命令查询初始密码
grep 'temporary password' /var/log/mysqld.log
7.通过命令就可以进入
mysql -uroot -ppassword
8.修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
9.mysql 远程登录
use mysql;
update user set host = '%' where user = 'root';
可以通过如下命令降低密码强度
SET GLOBAL validate_password.policy=LOW;
SET GLOBAL validate_password.length=4;
mysql8 之前的版本中加密规则是mysql_native_password,而在mysql8之后,加密规则是caching_sha2_password,
解决问题方法有两种,一种是升级navicat驱动,一种是把mysql用户登录密码加密规则还原成mysql_native_password.
ALTER USER 'root'@'%' IDENTIFIED BY 'root123' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root123';
flush privileges;
完成以上操作，则可以远程连接上。
set sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';
或者/etc/my.cnf文件最后加上
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
