目的
本文主要介绍以下两点:
一. 如何安装 MySQL 8.0
二. Navicat 连接 MySQL
一. 如何安装 MySQL 8.0
安装 MySQL 有两种方式:
直接下载官方的源 (比较慢)
- https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm # 下载 rpm 包
- yum localinstall mysql80-community-release-el7-1.noarch.rpm # 处理相关依赖
- yum install MySQL-community-server # 安装
用 163 的源, 分开安装
- wget https://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-community-common-8.0.18-1.el7.x86_64.rpm
- wget https://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-community-libs-8.0.18-1.el7.x86_64.rpm
- wget https://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-community-client-8.0.18-1.el7.x86_64.rpm
- wget https://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-community-server-8.0.18-1.el7.x86_64.rpm
- rpm -ivh MySQL-community-common-8.0.18-1.el7.x86_64.rpm # rpm 下载
- rpm -ivh MySQL-community-libs-8.0.18-1.el7.x86_64.rpm
- rpm -ivh MySQL-community-client-8.0.18-1.el7.x86_64.rpm
- rpm -ivh MySQL-community-server-8.0.18-1.el7.x86_64.rpm
重启 MySQL
service mysqld start
查看 MySQL 默认密码
cat /var/log/mysqld.log | grep password
登录
MySQL -uroot -p # 回车, 复制上面的密码即可
二. Navicat 连接 MySQL
连接 MySQL 之前, 先修改下 root 的密码
- set global validate_password.policy=0; #修改策略
- set global validate_password.length=1;
- alter user 'root'@'localhost' identified with mysql_native_password by '12345678'; # 测试环境, 密码可以简单点, Mysql8.0 必须用 mysql_native_password 给账号加密
可以 exit 退出, 重新登录看看.
修改 root 账号的 Host, 便于 IP 连接
- use MySQL; #MySQL 的基础表
- update user set Host = '%' where User='root'; # 正式环境, 可以创建新的 MySQL 账号, 设置成具体的 ip
开放 3306 端口
- firewall-cmd --add-port=3306/tcp --permanent
- firewall-cmd --reload
下面用 Navicat 新建连接, 即可
来源: http://www.linuxidc.com/Linux/2019-11/161599.htm