1.1 下载二进制安装文件
地址:https://downloads.mysql.com/archives/community/
上传到/root
[6.8 localhost ~ 0 32]# cat /etc/redhat-release
CentOS release 6.8 (Final)
[6.8 localhost ~ 0 33]# ll mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz
-rw-r--r-- 1 root root 661214270 3月 30 23:32 mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz
1.2 创建用户
groupadd mysql
useradd mysql -g mysql
[6.8 localhost ~ 0 35]# id mysql
uid=27(mysql) gid=27(mysql) 组=27(mysql)
1.3 创建目录
mkdir /home/mysql/{program,conf} -p
mkdir /home/mysql/data/mysqldata1/{mydata,sock,tmpdir,log,innodb_ts,innodb_log,undo,slowlog,binlog,relaylog} -p
1.4 解压缩二进制安装文件并设置目录权限
tar -xvf mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz -C /home/mysql/program/
[6.8 localhost /home/mysql 0 90]# chown -R mysql.mysql /home/mysql/
[6.8 localhost /home/mysql 0 91]# ll
总用量 12
drwxr-xr-x 2 mysql mysql 4096 3月 29 23:39 conf
drwxr-xr-x 3 mysql mysql 4096 3月 29 23:44 data
drwxr-xr-x 3 mysql mysql 4096 3月 29 23:45 program
1.5 软链接,并设置PATH覆盖原有mysql
[6.8 localhost /usr/local/mysql/bin 0 34]# ln -s /home/mysql/program/mysql-5.7.32-linux-glibc2.12-x86_64/ /usr/local/mysql
[6.8 localhost /usr/local/mysql/bin 0 34]# readlink -f mysql
/home/mysql/program/mysql-5.7.32-linux-glibc2.12-x86_64/bin/mysql
[6.8 localhost /usr/local/mysql/bin 0 36]# which mysql
/usr/bin/mysql
[6.8 localhost /usr/local/mysql/bin 0 37]# export PATH=/usr/local/mysql/bin/:$PATH
[6.8 localhost /usr/local/mysql/bin 0 38]# echo $PATH
/usr/local/mysql/bin/:/root/.pyenv/plugins/pyenv-virtualenv/shims:/root/.pyenv/shims:/root/.pyenv/bin:/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/root/bin
[6.8 localhost /usr/local/mysql/bin 0 40]# which mysql
/usr/local/mysql/bin/mysql
[6.8 localhost /usr/local/mysql/bin 0 43]# mysql -V
mysql Ver 14.14 Distrib 5.7.32, for linux-glibc2.12 (x86_64) using EditLine wrapper
[6.8 localhost /usr/local/mysql/bin 0 41]# echo 'export PATH=/usr/local/mysql/bin/:$PATH'>>/etc/profile
1.6 增加man 文档
[6.8 localhost / 1 17]# grep mysql /etc/man.config
MANPATH /usr/local/mysql/man
[6.8 localhost / 1 18]# man -aw mysql
/usr/share/man/man1/mysql.1.gz
/usr/local/mysql/man/man1/mysql.1
[6.8 localhost / 1 19]# man -M /usr/local/mysql/man mysql
1.7 添加库文件,头文件
[6.8 localhost / 1 42]# cat /etc/ld.so.conf.d/mysql.conf
/usr/local/mysql/lib
[6.8 localhost / 1 43]# ldconfig -v
[6.8 localhost /usr/include 1 60]# ln -s /usr/local/mysql/include/ /usr/include/mysql57
1.8 参数文件
[6.8 localhost ~ 0 12]# mysql --help
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf
mv /etc/my.cnf /etc/my.cnfbak48
[6.8 localhost ~ 0 15]# mkdir -p /usr/local/mysql/etc/
[6.8 localhost /usr/local/mysql 0 27]# chown mysql.mysql /usr/local/mysql/etc/
vim my.cnf
[mysqld]
socket=/home/mysql/data/mysqldata1/sock/mysql.sock
user=mysql
basedir=/usr/local/mysql
datadir=/home/mysql/data/mysqldata1/mydata
# Disabling symbolic-links is recommended to prevent assorted security risks
#symbolic-links=0
#default-storage-engine=InnoDB
log_bin=/home/mysql/data/mysqldata1/binlog/mysql-bin
relay-log=/home/mysql/data/mysqldata1/relaylog/mysql-relay-bin
server_id=1
#[mysqld_safe]
tmpdir=/home/mysql/data/mysqldata1/tmpdir
log-error=/home/mysql/data/mysqldata1/log/error.log
pid-file=/home/mysql/data/mysqldata1/sock/mysql.pid
slow_query_log
slow_query_log_file=/home/mysql/data/mysqldata1/slowlog/slow-query.log
#skip_name_resolve=on
innodb_file_per_table=on
innodb_data_home_dir=/home/mysql/data/mysqldata1/innodb_ts
innodb_log_group_home_dir=/home/mysql/data/mysqldata1/innodb_log
innodb_undo_directory=/home/mysql/data/mysqldata1/undo/
log_timestamps=SYSTEM
1.9 初始化mysql,启动
mysqld --defaults-file=/usr/local/mysql/etc/my.cnf --initialize-insecure
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld57
chmod +x /etc/init.d/mysqld57
service mysqld57 start