CentOS 7 install MySQL8

安装采用二进制包方式安装，此种方式安装方便快捷，采用编译方式时间太长。

1.下载安装包

下载地址
国内下载地址，使用163的资源，此外还有sohu资源可以下载

wget  http://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz

wget http://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-8.0.21-linux-glibc2.12-x86_64.tar.xz

安装依赖包

yum -y install wget cmake gcc gcc-c++ ncurses ncurses-devel libaio-devel openssl openssl-devel

创建用户和组

groupadd  mysql
useradd -g mysql -M -s /sbin/nologin mysql

解压并规划目录
指定解压到目录，采用连接的方式创建目录，此种方式方便升级

tar xvJf mysql-8.0.21-linux-glibc2.12-x86_64.tar.xz -C /usr/local 
cd /usr/local/
ln -s mysql-8.0.21-linux-glibc2.12-x86_64 mysql ## 创建连接

配置环境变量

echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
使变量生效
source /etc/profile

数据库目录规划

数据文件和日志文件放在/data目录

datadir /usr/local/mysql/data /data/mysql/data
my.cnf /usr/local/mysql/etc/my.cnf /usr/local/mysql/etc
pid文件 /usr/local/mysql/run/mysql.pid 
socket文件 /usr/local/mysql/run/mysql.sock 
慢查询日志slow_query_log_file /usr/local/mysql/log/mysql_slow_query.log /usr/local/mysql/log
二进制日志log-bin /usr/local/mysql/binlogs/mysql-bin /data/mysql/binlogs/mysql-bin
错误日志log-error /usr/local/mysql/log/mysql_error.log /usr/local/mysql/log

创建目录及创建软连接

mkdir -p /data/mysql/{data,binlogs,log,etc,run}
ln -s /data/mysql/data /usr/local/mysql/data
ln -s /data/mysql/binlogs /usr/local/mysql/binlogs
ln -s /data/mysql/log /usr/local/mysql/log
ln -s /data/mysql/etc /usr/local/mysql/etc
ln -s /data/mysql/run /usr/local/mysql/run
ln -s /data/mysql/undo /usr/local/mysql/undo
chown -R mysql.mysql /data/mysql/
chown -R mysql.mysql /usr/local/mysql/{data,binlogs,log,etc,run，undo}

配置my.cnf参数文件
此处自定义文件位置，需要删除掉系统自带的文件my.cnf

rm -rf /etc/my.cnf

在/usr/local/mysql/etc/下创建my.cnf文件，加入如下参数，其他参数根据需要配置

vim /usr/local/mysql/etc/my.cnf
​```
[client]
port = 7306
socket = /usr/local/mysql/run/mysql.sock
​
[mysqld]
port = 7306
socket = /usr/local/mysql/run/mysql.sock
pid_file = /usr/local/mysql/run/mysql.pid
datadir = /usr/local/mysql/data
default_storage_engine = InnoDB
max_allowed_packet = 512M
max_connections = 2048
open_files_limit = 65535
​
skip-name-resolve
lower_case_table_names=1
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
​
innodb_buffer_pool_size = 1024M
innodb_log_file_size = 2048M
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 0
​
​
key_buffer_size = 64M
log-error = /usr/local/mysql/log/mysql_error.log
log-bin = /usr/local/mysql/binlogs/mysql-bin
slow_query_log = 1
slow_query_log_file = /usr/local/mysql/log/mysql_slow_query.log
long_query_time = 5
tmp_table_size = 32M
max_heap_table_size = 32M
​
server-id=1

​
初始化数据库

mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

使用–initiative 方法会在error日志中生成passowrd

grep 'temporary password' /usr/local/mysql/log/mysql_error.log
RzDexk14uT<W

​

生成SSL

mysql_ssl_rsa_setup --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/

设置启动方式

CentOS 6

cd /usr/local/mysql
cp support-files/mysql.server /etc/init.d/mysql.server
chkconfig --add mysql.server #添加入服务进程
chkconfig mysql.server on #设置自动启动
chkconfig --list   # 检测启动

CentOS 7

cd /usr/lib/systemd/system
touch mysqld.service
vim /usr/lib/systemd/system/mysqld.service

mysqd.service

[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
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
​
Type=forking
​
PIDFile=/usr/local/mysql/run/mysqld.pid
​
# Disable service start and stop timeout logic of systemd for mysqld service.
TimeoutSec=0
​
# 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/run/mysqld.pid $MYSQLD_OPTS
​
# Use this to switch malloc implementation
EnvironmentFile=-/etc/sysconfig/mysql
​
# Sets open_files_limit
LimitNOFILE = 65535
​
Restart=on-failure
​
RestartPreventExitStatus=1
​
PrivateTmp=false

添加进系统服务

systemctl daemon-reload
systemctl enable mysqld.service
systemctl is-enabled mysqld

启动mysql

systemctl start mysqld.service

设置安全和账号

/usr/local/mysql/bin/mysql_secure_installation​
Securing the MySQL server deployment.
tzAP#JM,c8hg
Enter password for user root:

导入时区

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

验证

mysqladmin version -uroot -p

​
结束