Linux安装Mysql

1.首先添加MySQL的Yum资源

   

wget https://repo.mysql.com/mysql80-community-release-el7-5.noarch.rpm

 2.加载MySQL8.0的rpm资源

rpm -Uvh mysql80-community-release-el7-5.noarch.rpm

 3.安装MySQL

yum install mysql-community-server -y

 

 

4. 启动Mysql并且设置开机自启

systemctl start mysqld && systemctl enable mysqld

 5.查看MYsql的默认密码

 grep 'temporary password' /var/log/mysqld.log

 红框位置内为默认密码

6.使用Mysql指令 mysql-u root -p登陆

 7.更改密码，先设置一个复杂的密码
 

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Left@zuo123.';

 单引号内为新密码

8.修改密码规范

 set global validate_password.policy=0;
 set global validate_password.length=1;

 9.重新设置密码，此时可以设置为简单密码

 ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

10.设置远程登陆 

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

11.刷新权限

flush privileges;

 

 12.然后就可以用Navicat远程连接了

13.tip 如果连接出现2059错误，可以参考

远程连接2059