Centos7 安装Mysql8.0

1.wget下载mysql文件.tar.gz

    wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.13-el7-x86_64.tar.gz

2.卸载系统中mariadb，解压下载的源文件

    //检查是否存在

    yum list installed | grep mariadb

    //卸载 yum -y remove mariadb-libs.x86_64

    解压mysql

    tar -xzvf mysql-8.0.11-el7-x86_64.tar.gz -C /usr/local/mysql

3.添加组和用户

groupadd mysql

useradd -g mysql mysql

4.安装

//安装，在/usr/local/mysql/bin目录下操作

./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql

记住出现的密码

5.修改密码及远程访问

切换到/usr/local/mysql/bin目录下

./mysql_ssl_rsa_setup --datadir=/usr/local/mysql/data

chown -R mysql: mysql /usr/local/mysql

./mysqld_safe &

./mysql -uroot -p

`输入刚才密码即可以登录，默认不能远程`

//修改root密码

alter user 'root'@'localhost' identified by '123456';

use mysql;

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

注：Navicat远程连接过程中，如果出现Authentication plugin 'caching_sha2_password' cannot be loaded，是由于验证方式发生改变，

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

6.开放centos7防火墙端口

1.查看防火墙状态

firewall-cmd --state ## 结果显示为running或not running

2.关闭防火墙firewall

systemctl stop firewalld.service

systemctl disable firewalld.service

3.关闭防火墙后开启

systemctl start firewalld.service

4.开启端口

## zone -- 作用域

## add-port=80/tcp -- 添加端口，格式为：端口/通讯协议

## permanent -- 永久生效，没有此参数重启后失效

firewall-cmd --zone=public --add-port=3306/tcp --permanent

## 开启3306端口后，workbench或naivcat 就能连接到MySQL数据库了

5.重启防火墙

firewall-cmd --reload

转载于:https://my.oschina.net/u/3890788/blog/3059671