CentOS 7.9 二进制、rpm、yum 安装mysql数据库

CentOS 7.9 二进制、rpm、yum 安装mysql数据库

mysql安装方式
二进制安装、源代码安装、rpm包安装、yum源安装

下载MySQL 5.7二进制包

下载页面：https://dev.mysql.com/downloads/mysql/5.7.html#downloads
[root@localhost ~]#yum -y install lrzsz
[root@localhost ~]# rz                （回车，选择安装包）

OS选择：linux generic，按照系统版本下载。

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz

创建用户

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

解压安装包

[root@localhost ~]# tar xvfz mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz -C /usr/local
[root@localhost ~]#cd /usr/local

建立软连接

[root@localhost local]# ln -s mysql-5.7.26-linux-glibc2.12-x86_64 mysql

环境变量设置

[root@localhost local]# echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
[root@localhost local]# source /etc/profile

配置MySQL
例如把mysql数据放在/data/mysql目录，创建目录。

[root@localhost local]# mkdir -pv /data/mysql
[root@localhost local]# chown mysql：mysql /data/mysql
[root@localhost local]# chmod go-rwx /data/mysql

###配置my.cnf，例如
vim /etc/my.cnf
[client]
port = 3306
socket = /tmp/mysql.sock

[mysqld]
port = 3306
socket = /tmp/mysql.sock
pid_file = /data/mysql/mysql.pid
datadir = /data/mysql
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 = 512M
innodb_log_file_size = 1024M
innodb_file_per_table = 1
innod