CentOS7安装Mysql8以及Navicat远程连接错误解决

1、查看安装源

yum search mysql-community

2、下载安装源

cd /usr/local/
mkdir mysql
cd mysql
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

3、安装mysql安装源

yum install -y mysql-community-server

4、启动、查看、与设置自启动服务

# 启动服务
systemctl start mysqld

# 监听端口
netstat -tulpn

# 查看服务状态
systemctl status mysqld

# 开机自启动
systemctl enable mysqld

5、查看mysql生成的随机密码

cd /var/cache/yum/x86_64/7/mysql80-community/packages/
vi /var/log/mysqld.log

6、修改root密码

alter user 'root'@'localhost' identified with mysql_native_password by 'password';

7、设置root可远程登录

use mysql;
select host, user from user;
update user set