linux下安装mysql8.0

1.下载mysql8.0

1.下载地址：https://www.percona.com/downloads/Percona-Server-LATEST

我选择percona公司出品的mysql8.0，高性能且稳定

2.离线安装

1.下载安装包 wget https://www.percona.com/downloads/Percona-Server-LATEST/Percona-Server-8.0.15-6/binary/redhat/7/x86_64/Percona-Server-8.0.15-6-r63abd08-el7-x86_64-bundle.tar

2.解压安装包 tar -xvf Percona-Server-8.0.15-6-r63abd08-el7-x86_64-bundle.tar -C /usr/local/src/percona-server

3.安装数据库 cd /usr/local/src/percona-server && yum localinstall *.rpm

3.在线安装

1.安装yum源 yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm

2.执行 percona-release setup ps80

3.安装数据库 yum install percona-server-server

4.启动数据库

启动数据库：systemctl start mysqld
关闭数据：systemctl stop mysqld
重启数据库：systemctl restart mysqld 
开机自启动：systemctl enable mysqld 
关闭自启动：systemctl disable mysqld 

4.配置数据库用户密码

1.执行cat /var/log/mysqld.log | grep "temporary password"获取root用户初始密码

2.执行mysql_secure_installation设置root新密码，其他选项均选y

3.root用户不能用于远程登录，创建远程登录用户

进入mysql命令行：mysql -uroot -p密码

CREATE USER 'admin'@'%' IDENTIFIED BY 'Cxf_157321';

grant all privileges on *.* to 'admin'@'%';

FLUSH PRIVILEGES;

5.设置mysql参数

请自行百度mysql参数优化，建议不要随便改以免负优化

#字符集
character_set_server = utf8
bind-address = 0.0.0.0
#跳过DNS解析
skip-name-resolve
#忽略大小写
lower_case_table_names=1

6.问题处理

navcat连接不上报client does no support authentic

执行命令修改密码 ALTER USER 'admin'@'%' IDENTIFIED WITH mysql_native_password BY 'Cxf_157321';