MYSQL 5.7.31二进制包安装

mysql二进制包下载地址:
https://downloads.mysql.com/archives/community/

上传软件包至tmp目录:
[root@mysql57 tmp]# pwd
/tmp
[root@mysql57 tmp]# ll mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz
-rw-r–r-- 1 root root 118 Jan 16 11:29 mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz

创建软件存放目录:
[root@mysql57 ~]# mkdir /mysql/app -pv

解压软件:
[root@mysql57 tmp]#tar xvf mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz
[root@mysql57 tmp]# mv mysql-5.7.31-linux-glibc2.12-x86_64/* /mysql/app/
[root@mysql57 tmp]# cd /mysql/app/
[root@mysql57 app]# ls
bin docs include lib LICENSE man README share support-files

编写环境变量:
[root@mysql57 app]# cd bin/
[root@mysql57 bin]# pwd
/mysql/app/bin

[root@mysql57 bin]#vim /etc/profile:
添加至最后一行
export PATH=/mysql/app/bin:$PATH
[root@mysql57 bin]# source /etc/profile

创建mysql用户和组:
[root@mysql57 ~]# groupadd mysql
[root@mysql57 ~]# useradd mysql -g mysql

创建数据目录:
[root@mysql57 ~]# mkdir /mysql/app/data
[root@mysql57 ~]# chown -R mysql.mysql /mysql

初始化数据库:
[root@mysql57 ~]#mysqld --initialize --user=mysql --basedir=/mysql/app --datadir=/mysql/app/data
2021-01-16T17:13:50.111297Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-01-16T17:13:50.380327Z 0 [Warning] InnoDB: New log files created, LSN=45790
2021-01-16T17:13:50.550801Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-01-16T17:13:50.646351Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 33cffab5-581e-11eb-bf5e-000c29a4076e.
2021-01-16T17:13:50.646896Z 0 [Warning] Gtid table is not ready to be used. Table ‘mysql.gtid_executed’ cannot be opened.
2021-01-16T17:13:51.316079Z 0 [Warning] CA certificate ca.pem is self signed.
2021-01-16T17:13:51.491152Z 1 [Note] A temporary password is generated for root@localhost: #tCMIFge7bpm

编写配置文件:
想要修改默认位置只需要修改/mysql/support-files/mysql.server中conf行
[root@mysql57 ~]# more /etc/my.cnf
[mysqld]
user=mysql
basedir=/mysql/app
datadir=/mysql/app/data
server_id=6
port=3306
socket=/mysql/app/mysql.sock

[client]
socket=/mysql/app/mysql.sock

启动方式如下:
使用mysqld_safe启动:
[root@mysql57 ~]# mysqld_safe &
2021-01-16T17:30:16.050164Z mysqld_safe Logging to ‘/mysql/app/data/mysql57.err’.
2021-01-16T17:30:16.070013Z mysqld_safe Starting mysqld daemon with databases from /mysql/app/data

配置init.d启动脚本:
[root@mysql57 ~]# cp /mysql/app/support-files/mysql.server /etc/init.d/mysqld

启动mysql:
[root@mysql57 ~]# /etc/init.d/mysqld start
Starting MySQL. SUCCESS!

登录mysql:
[root@mysql57 ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.31

Copyright © 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> alter user ‘root’@‘localhost’ identified by ‘123456’;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

配置使用systemd管理mysql：
[root@mysql57 ~]# vim /etc/systemd/system/mysqld.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
ExecStart=/mysql/app/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000

[root@mysql57 ~]# /etc/init.d/mysqld stop
Shutting down MySQL… SUCCESS!

[root@mysql57 ~]# systemctl start mysqld
[root@mysql57 ~]# systemctl status mysqld
● mysqld.service - MySQL Server
Loaded: loaded (/etc/systemd/system/mysqld.service; disabled; vendor preset: disabled)
Active: active (running) since Sat 2021-01-16 12:22:01 EST; 4s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Main PID: 2890 (mysqld)
CGroup: /system.slice/mysqld.service
└─2890 /mysql/app/bin/mysqld --defaults-file=/etc/my.cnf

Jan 16 12:22:01 mysql57 mysqld[2890]: 2021-01-16T17:22:01.555948Z 0 [Warning] …d.
Jan 16 12:22:01 mysql57 mysqld[2890]: 2021-01-16T17:22:01.556001Z 0 [Note] Ski…y.
Jan 16 12:22:01 mysql57 mysqld[2890]: 2021-01-16T17:22:01.556081Z 0 [Note] Ser…06
Jan 16 12:22:01 mysql57 mysqld[2890]: 2021-01-16T17:22:01.556124Z 0 [Note] IPv…e.
Jan 16 12:22:01 mysql57 mysqld[2890]: 2021-01-16T17:22:01.556131Z 0 [Note] -…’;
Jan 16 12:22:01 mysql57 mysqld[2890]: 2021-01-16T17:22:01.556141Z 0 [Note] Ser…’.
Jan 16 12:22:01 mysql57 mysqld[2890]: 2021-01-16T17:22:01.558072Z 0 [Note] Fai…’’
Jan 16 12:22:01 mysql57 mysqld[2890]: 2021-01-16T17:22:01.560899Z 0 [Note] Eve…ts
Jan 16 12:22:01 mysql57 mysqld[2890]: 2021-01-16T17:22:01.560997Z 0 [Note] /my…s.
Jan 16 12:22:01 mysql57 mysqld[2890]: Version: ‘5.7.31’ socket: '/mysql/app/m…L)
Hint: Some lines were ellipsized, use -l to show in full.

配置开机自启动:
[root@mysql57 ~]# systemctl enable mysqld
Created symlink from /etc/systemd/system/multi-user.target.wants/mysqld.service to /etc/systemd/system/mysqld.service.