centos7安装mysql5.7(免编译安装)

1.下载mysql5.7

https://dev.mysql.com/downloads/mysql/5.7.html#downloads

2.安装mysql5.7

tar zxvf mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz

#重命名目录，方便查看
mv mysql-5.7.35-linux-glibc2.12-x86_64 mysql-5.7.35

#创建账号
useradd -M -s /sbin/nologin mysql

#指定mysql的所有者
chown -R mysql.mysql /data/mysql-5.7.35

#初始化mysql
/data/mysql-5.7.35/bin/mysqld --initialize-insecure --user=mysql --basedir=/data/mysql-5.7.35 --datadir=/data/mysql-5.7.35/data

3. 修改 mysql的配置文件 /etc/my.cnf (仅供参考)

[client]
port = 3306
socket = /data/mysql-5.7.35/mysql.sock
default-character-set = utf8

[mysqld]
user = mysql
port = 3306
socket = /data/mysql-5.7.35/mysql.sock
basedir = /data/mysql-5.7.35
datadir = /data/mysql-5.7.35/data
pid-file = /data/mysql-5.7.35/mysql.pid
log_error = /data/mysql-5.7.35/mysql-error.log
init-connect = 'SET NAMES utf8'
character-set-server = utf8
default_storage_engine = InnoDB

slow_query_log = 1
long_query_time = 3
slow_query_log_file = /data/mysql-5.7.35/mysql-slow.log

4.配置环境变量

vim /etc/profile

export MYSQL=/data/mysql/mysql-5.7.35
export PATH=$PATH:$MYSQL/bin

5. 启动mysql

mysqld &