RedHat 7.4安装MySQL 8.0.doc

Jun

8页

0次

2023-11-15

50墨值下载

RedHat 7.4
安装
MySQL 8.0
目录
一、安装单实例
.................................................................................................................................2
1. 
安装环境
.................................................................................................................................2
2. 
删除
mariadb-libs....................................................................................................................2
3. 
配置环境变量
.........................................................................................................................2
4. 
创建组和用户
.........................................................................................................................2
5. 
关闭
selinux(
修改
SELINUX=disabled)................................................................................2
6. 
解压二进制安装包
.................................................................................................................3
7. 
创建数据目录
.........................................................................................................................3
8. 
配置
my.cnf.............................................................................................................................3
9. 
初始化
mysql..........................................................................................................................4
10. 
查看初始密码
.......................................................................................................................4
11. 
配置开机自启动脚本
...........................................................................................................4
12. 
启动服务
...............................................................................................................................4
13. 
登录并修改初始密码
...........................................................................................................4
14. 
创建数据库及用户
...............................................................................................................5
二、配置主从同步
.............................................................................................................................6
1. 
主库修改
my.cnf.....................................................................................................................6
2. 
从库修改
my.cnf.....................................................................................................................6
3. 
在主库上创建备份专用账号
.................................................................................................7
4. 
在主库执行
mysqldump
备份
................................................................................................7
5. 
在从库执行导入
.....................................................................................................................7
6. 
在从库启动
slave....................................................................................................................7

一、安装单实例

安装环境

操作系统：

RedHat 7.4

数据库版本：

mysql-8.0.26-el7-x86_64.tar

删除

mariadb-libs

# rpm -qa | grep mariadb-libs

mariadb-libs-5.5.68-1.el7.x86_64

# rpm -e mariadb-libs --nodeps

# rpm -qa | grep mariadb-libs

配置环境变量

# echo "export PATH=$PATH:/app/mysql-8.0.26/bin" >> /etc/profile

# source /etc/profile

创建组和用户

# groupadd -r mysql

# useradd -r -g mysql -s /sbin/nologin -M mysql

关闭

selinux(

修改

SELINUX=disabled)

# vi /etc/selinux/config

# This file controls the state of SELinux on the system.

# SELINUX= can take one of these three values:

# enforcing - SELinux security policy is enforced.

# permissive - SELinux prints warnings instead of enforcing.

# disabled - No SELinux policy is loaded.

SELINUX=disabled

# SELINUXTYPE= can take one of three two values:

# targeted - Targeted processes are protected,

# minimum - Modification of targeted policy. Only selected processes are protected.

# mls - Multi Level Security protection.

SELINUXTYPE=targeted

注：

不重启服务器临时关闭

# setenforce 0

解压二进制安装包

# cd /app/

# tar -xvf mysql-8.0.26-el7-x86_64.tar

# tar -xzvf mysql-8.0.26-el7-x86_64.tar.gz

# mv mysql-8.0.26-el7-x86_64 mysql-8.0.26

创建数据目录

# cd /app/mysql-8.0.26/

# mkdir data

# cd ..

# chown -R mysql:mysql mysql-8.0.26

配置

my.cnf

# cat > /etc/my.cnf << EOF

[mysql]

no-auto-rehash

[mysqld]

of 8

50墨值下载

mysql 8.0

相关文档

评论