Centos7安装mysql-8.0.26教程

一、Linux版本

CentOS-7-x86_64-Minimal-1810.iso

二、先下载Linux下的Mysql包，打开Mysql官网

　　https://www.mysql.com/

2.1 选择DOWNLOADS进入下载界面
2.2 选择 MySQL Community (GPL) Downloads

2.3 选择MySQL Community Server

 

2.4  选择Select Operating System
2.5  选择Select OS Version
2.6  选择RPM Bundle版本后点击download

 三、mysql安装

解压mysql-8.0.26-1.el7.x86_64.rpm-bundle.tar压缩包，将压缩包文件上传到centos系统，文件安装顺序如下：

3.1  卸载系统自带的mariadb-lib

3.1.1 查看mariadb版本

rpm -qa | grep mariadb

3.1.2 卸载mariadb

rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps

3.1.3 再次执行查看，如果没有显示说明已卸载

rpm -qa | grep mariadb

3.2  安装mysql-community-common-8.0.26-1.el7.x86_64.rpm

rpm -ivh mysql-community-common-8.0.26-1.el7.x86_64.rpm

3.3  安装mysql-community-client-plugins-8.0.26-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-plugins-8.0.26-1.el7.x86_64.rpm

3.4  安装mysql-community-libs-8.0.26-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-8.0.26-1.el7.x86_64.rpm

3.5  安装mysql-community-client-8.0.26-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-8.0.26-1.el7.x86_64.rpm

3.6  安装perl(server安装需要依赖perl)

yum -y install perl.x86_64

3.7  安装net-tools(server安装需要依赖net-tools)

yum -y install net-tools

3.8  安装mysql-community-server-8.0.26-1.el7.x86_64.rpm

 rpm -ivh mysql-community-server-8.0.26-1.el7.x86_64.rpm

 

四、mysql启动

4.1  mysql初始化

mysqld --initialize --user=mysql

4.2 查看初始密码

cat /var/log/mysqld.log

4.3  启动mysql

service mysqld start

4.4  查看服务状态

service mysqld status

 4.5  使用初始密码登录

mysql -uroot -p&lR%nm:Br2+4

4.6  修改密码

alter user 'root'@'localhost' identified by '自定义密码';

4.7 mysql开启远程连接(其它机器可以访问)

use mysql;

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

flush privileges;

 至此mysql8安装配置完成

 

五、通过navicate连接mysql

 

如果出现连接不上，可能是因为centos系统防火墙打开了，关闭防火墙就可以

systemctl start firewalld 启动
systemctl stop firewalld 停止
systemctl status firewalld 查看状态
systemctl disable firewalld 禁用