1、下载mysql地址：
根据所需版本进行下载、本次选择5.7.20进行安装
https://downloads.mysql.com/archives/community/2、安装步骤
1、解压包
tar -zxvf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.20-linux-glibc2.12-x86_64 /usr/local/mysql
2、创建用户、组
groupadd mysql
useradd -r -g mysql mysql
3、创建数据目录
mkdir /usr/local/mysql/data
4、授权mysql安装目录
chown -R mysql:mysql /usr/local/mysql/
5、初始化数据库
cd /usr/local/mysql
./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data
#记录下输出的初始化密码
6、配置启动脚本程序
vim /usr/lib/systemd/system/mysqld.service
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=https://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
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE=65535
Restart=on-failure
RestartPreventExitStatus=1
PrivateTmp=true
[Install]
WantedBy=multi-user.target
7、写入mysql配置文件
[root@nginx-67 ~]# cat /etc/my.cnf
[client]
socket=/usr/local/mysql/mysql.sock
[mysqld]
########basic settings########
server-id = 11
port = 3306
user = mysql
autocommit = 0
character_set_server=utf8mb4
skip_name_resolve = 1
max_connections = 800
max_connect_errors = 1000
datadir = /usr/local/mysql/data
transaction_isolation = READ-COMMITTED
explicit_defaults_for_timestamp = 1
join_buffer_size = 134217728
tmp_table_size = 67108864
tmpdir = /tmp
max_allowed_packet = 16777216
#sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER"
socket=/usr/local/mysql/mysql.sock
interactive_timeout = 1800
wait_timeout = 1800
read_buffer_size = 16777216
read_rnd_buffer_size = 33554432
sort_buffer_size = 33554432
8、启动mysql
[root@k8s-master1-60 data]# systemctl enable --now mysqld.service
[root@k8s-master1-60 data]# systemctl status mysqld.service
9、使用初始密码登录后进行改密码
set password for root@localhost = password('123456');
10、开启远程登录
update user set user.Host='%' where user.User='root';
flush privileges;