mysql percona yum_安装percona mysql 5.7（单机_yum方式）

基础环境：

OS：Red Hat Enterprise Linux Server release 7.6 (Maipo)

mysql：Percona版(5.7最新，可选mysql8)

操作步骤：

1、关闭防火墙

修改/etc/sysconfig/selinux的配置，命令如下

# sed -i 's#SELINUX=enforcing#SELINUX=disabled#g' /etc/sysconfig/selinux

关闭Selinux(强烈建议关闭)

# setenforce 0

关闭防火墙

# systemctl stop firewalld

去除开机启动

# systemctl disable firewalld

2、安装Percona 的yum信息库到本机上

# yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm

3、检查本机是否有mysql或者mariadb

# rpm -qa | grep mysql

# rpm -qa | grep mariadb

发现有一个库文件mariadb-libs-5.5.41-2.el7_0.x86_64，强制删除掉

# rpm -e --nodeps mariadb-libs

4、安装percona server

# yum install Percona-Server-server-57

漫长的等待之后发现有个报错：

GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Percona

可能是刚刚安装的信息库有问题，不是最新，更新之

# yum update percona-release

然后再次执行安装即可

5、创建目录及权限修改

# mkdir -p /opt/mysql/{mysql_data,mysql_log}

# chown -R mysql:mysql /opt/mysql

# usermod -d /opt/mysql mysql

6、创建配置文件

从网络下载一个文件my.cnf，注意修改对应的目录为我们刚刚创建的目录

7、修改启动文件/etc/systemd/system/mysql.service

# sed -i 's#/var/run/mysqld/mysqld.pid#/opt/mysql/mysql_log/mysqld.pid#g' /etc/systemd/system/mysql.service

# sed -i 's#/var/run/mysqld/mysqld.pid#/opt/mysql/mysql_log/mysqld.pid#g' /usr/lib/systemd/system/mysqld.service

# sed -i 's#LimitNOFILE = 5000#LimitNOFILE = 100000#g' /etc/systemd/system/mysql.service

# sed -i 's#LimitNOFILE = 5000#LimitNOFILE = 100000#g' /usr/lib/systemd/system/mysqld.service

重新加载配置

# systemctl daemon-reload

8、启动服务

# service mysqld restart

9、修改root密码

获取mysql初始密码

# grep -i 'password' /opt/mysql/mysql_log/error.log

2020-03-18T04:07:12.534522Z 1 [Note] A temporary password is generated for root@localhost: ws+Pezm/r31i

# mysql -u root -p' ws+Pezm/r31i'

sql> SET PASSWORD FOR root@'localhost' = '****'; #更改root密码

10、权限赋值(运行任何IP可以root访问DB)

sql> grant all on *.* to root@'%' identified by 'your_password';

sql> flush privileges;