Centos 7 部署Mysql8.0全过程，二进制包安装

Centos 7 部署Mysql8.0全过程，二进制包安装

官网下载地址：
https://dev.mysql.com/downloads/mysql/ 下载 Community(社区版) 的 generic(通用版) 二进制包文件。

本次安装版本为：8.0.35，具体如下图所示：

rpm -qa | grep mariadb                  #查看是否存在mariadb安装
rpm -e  --nodeps  mariadb-libs          #卸载包。 --nodeps 不检验依赖

#查看当前系统文件库版本：
ldd --version

解压并移动安装包

# 解压 tar -zxvf 待解压目录
[root@localhost ~]# tar -xf mysql-8.0.35-linux-glibc2.17-x86_64.tar.xz

# 移动 mv 移动目录 移动后的目录
[root@localhost ~]# mv mysql-8.0.35-linux-glibc2.17-x86_64 /usr/local/mysql

创建数据目录

# 进入MySQL目录
[root@localhost ~]# cd /usr/local/mysql

# 创建data文件夹(也可以根据那个磁盘大而定--df -Th查看)
[root@localhost mysql]# mkdir data

创建mysql用户权限

# 创建mysql用户并添加到mysql组中,系统用户无登陆模式
[root@localhost mysql]# useradd -s /sbin/nologin mysql

# 修改mysql目录的组以及权限
[root@localhost mysql]# chown mysql:mysql -R /usr/local/mysql

修改MySQL配置文件

vim /etc/my.cnf

[mysqld]
character_set_server=utf8     #设置mysql字符集

user = mysql
port = 3306
basedir = /usr/local/mysql    # mysql解压目录
datadir = /opt/mysql/data     # 数据存放目录
socket = /tmp/mysql.sock      # socker文件存放目录

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mariadb/mysql.log    # 错误日志
pid-file=/var/run/mysql/mysql.pid         # mysql进程号

# 日志记录慢查询SQL
slow_query_log = true
slow_query_log_file = /usr/local/mysql/data/mysql_slow_query.log
long_query_time = 1

# 记录没有使用index的查询记录
log-queries-not-using-indexes

# 配置mysqlbinlog
server-id = 1
log-bin = mysql-bin
binlog_format = MIXED
gtid-mode = on
enforce-gtid-consistency = true
master-info-repository = TABLE
relay-log-info-repository = TABLE
# 并行复制工作线程数
slave-parallel-workers = 4

# 设置sql_mode行为规则
sql_mode = 'NO_ENGINE_SUBSTITUTION'

# 设置binlog过期时间，过期自动删除 binlog_expire_logs_seconds单位是秒
binlog_expire_logs_seconds = 604800
max_binlog_size = 100M
log_bin_trust_function_creators = 1

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

初始化MySQL

# 初始化  --defaults-file为配置文件所在 ,--basedir为解压路径,--datadir为数据保存路径 --user表示MySQL所属用户
[root@localhost mysql]# ./bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/opt/mysql/data --user=mysql --initialize

初始化后会有密码产生，记录最后一行密码oK)CZs*bg9zw

设置systemd启动文件

vim /usr/lib/systemd/system/mysql.service

[Unit]
Description=MySQL Server
Documentation=man:mysqld()
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target

[Install]
WantedBy=multi-user.target

[Service]
User=mysql
Group=mysql
PIDFile=/usr/local/mysql/data/mysqld.pid

# Disable service start and stop timeout logic of systemd for mysqld service.
TimeoutSec=

# Execute pre and post scripts as root
PermissionsStartOnly=true
# Needed to create system tables
#ExecStartPre=/usr/bin/mysqld_pre_systemd

# Start main service
ExecStart=/usr/local/mysql/bin/mysqld --daemonize --pid-file=/usr/local/mysql/data/mysqld.pid
#注意这里要加上 --daemonize
# Use this to switch malloc implementation
#EnvironmentFile=-/etc/sysconfig/mysql

# Sets open_files_limit
LimitNOFILE =
Restart=on-failure
RestartPreventExitStatus=
PrivateTmp=false

启动服务

# 开机自启动
[root@localhost mysql]# systemctl enable  mysql.service
[root@localhost mysql]# systemctl start mysql.service
设置环境变量
[root@localhost mysql]# vim /etc/profile
export PATH=$PATH:/usr/local/mysql/bin		## 最后一行添加
[root@localhost mysql]# source /etc/profile

修改密码

## 登入MySQL
[root@localhost mysql]# mysql -uroot -p'oK)CZs*bg9zw'   #初始化密码

## 修改密码
mysql> alter user 'root'@'localhost' identified by '123456';
mysql> set password for root@localhost = '123456';

## 设置MySQL远程登入
mysql> use mysql;
msyql> update user set user.Host='%' where user.User='root';
mysql> flush privileges;
mysql> exit

[root@localhost mysql]# mysql -uroot -p123456
mysql>

撒花