Liunx PRM 方式安装MYSQL8 图文介绍

1.下载MYSQL8

MySQL :: Download MySQL Community Serverhttps://dev.mysql.com/downloads/mysql/如下图

2.解压MYSQL安装包

解压到自己想存放mysql的文件夹位置例如我存放在/usr/mysql

tar xvf mysql-8.2.0-1.el7.x86_64.rpm-bundle.tar -C /usr/mysql

3.运行安装MYSQL

解压后如图:

yum remove postfix //卸载

rpm -q mariadb-libs //检查 存在则卸载

yum install openssl-devel -y //安装

yum install net-tools //安装

开始安装mysql，安装顺序不可以乱，一定按照下面顺序安装

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

rpm -ivh mysql-community-client-plugins-8.2.0-1.el7.x86_64.rpm //执行次命令报错 看解1
rpm -ivh mysql-community-libs-8.2.0-1.el7.x86_64.rpm   //执行次命令可能会报错 看解2

rpm -ivh mysql-community-client-8.2.0-1.el7.x86_64.rpm //执行此次命令报错 看解3

rpm -ivh mysql-community-icu-data-files-8.2.0-1.el7.x86_64.rpm

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

解1:

执行

yum install compat-openssl10

继续执行 rpm -ivh mysql-community-client-plugins-8.2.0-1.el7.x86_64.rpm

解2:

执行 rpm -ivh mysql-community-libs-8.2.0-1.el7.x86_64.rpm命令报错:

报错执行以下命令:

yum remove mysql-libs  //此命令执行后重新执行 

继续执行 rpm -ivh mysql-community-libs-8.2.0-1.el7.x86_64.rpm

解3:

执行

yum install libncurses*

4.检查MYSQL版本

mysql --version

5.设置MYSQL忽略大小写

进入mysql配置文件

vim /etc/my.cnf

在[mysqld]下添加如下

lower_case_table_names=1

mq: 报错配置文件

6.初始化MYSQL

mysqld --initialize --console

7.给文件赋权

chown -R mysql:mysql /var/lib/mysql/

8.查询初始密码

cat /var/log/mysqld.log

9.启动MYSQL

systemctl status mysqld        //查询是否启动mysql

systemctl start mysqld        //启动mysql

systemctl restart mysql        //重庆mysql

systemctl stop mysqld        //关闭mysql

10.MYSQL首次登录

mysql -uroot  -p

11.修改初始密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '自己常用密码';

12.配置MYSQL远程连接

使用新密码登录mysql

use mysql; //选择库

select 'host' from user where user='root';  //查询

update user set host = '%' where user ='root'; //修改

flush privileges;  刷新

13.防火墙放开MYSQL端口

firewall-cmd --add-service=http --permanent

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

//重启防火墙

firewall-cmd --reload

14.结束

记录自己liunx 安装mysql8 以免忘记 可以后查