1、官网下载安装包: https://downloads.mysql.com/archives/community/
2、解压并移动到安装目录下
tar -xvf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.22-linux-glibc2.12-x86_64 /opt/mysql3306
3、创建用户组
groupadd mysql
useradd mysql -g mysql
passwd mysql
4、添加文件授权
①创建目录(将日志和数据文件单独存放)
mkdir -p /data/mysql_log
mkdir -p /data/mysql_data
mkdir -p /data/tmp
②做超链接,指向当前目录
ln -s /data/mysql_log /opt/mysql3306/logs
ln -s /data/mysql_data /opt/mysql3306/data
③授权
chown -R mysql:mysql /opt/mysql3306
chown -R mysql:mysql /opt/mysql3306/logs
chown -R mysql:mysql mysql_log
chown -R mysql:mysql /data/tmp
④上传my.cnf到/opt/mysql3306
###我的my.cnf如下,路径一定要正确###
[client]
default-character-set = utf8mb4
socket = /tmp/mysql.sock
port=3306
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
#基础参数
basedir=/opt/mysql3306
datadir=/opt/mysql3306/data
port=3306
tmpdir = /data/tmp
user=mysql
pid-file=/opt/mysql3306/mysqld.pid
socket = /tmp/mysql.sock
default-storage-engine=INNODB
explicit_defaults_for_timestamp = true
#开启二进制日志
server-id=1234
log-bin=/opt/mysql3306/logs/mysql-bin
#开启慢日志
slow_query_log=ON
long_query_time=2
slow_query_log_file=/opt/mysql3306/logs/mysql-slow.log
#时区
log_timestamps=SYSTEM
[mysqld_safe]
log-error = /opt/mysql3306/logs/error.log
pid-file = /opt/mysql3306/mysqld.pid
5、初始化数据库
/opt/mysql3306/bin/mysqld --defaults-file=/opt/mysql3306/my.cnf --basedir=/opt/mysql3306 --datadir=/opt/mysql3306/data --initialize --user=mysql
执行完会输出这个,记住后面的密码(3Nr8bys<adDy),这个是root的初始密码
6、拷贝控制启停文件
cp /opt/mysql3306/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
vim /etc/init.d/mysqld
basedir=/opt/mysq3306 ##在第46~47行 改成my.cnf里面的那个路径
datadir=/opt/mysq3306/data
7、配置开机启动
chkconfig --add mysqld
chkconfig mysqld on
chkconfig --list mysqld ##检查mysql是否开机启动
8、创建错误日志文件并启动mysql
①创建错误日志文件并授权
touch /opt/mysql3306/logs/error.log
chown -R mysql:mysql /opt/mysql3306/logs/error.log
②启动
/etc/init.d/mysqld start