mysql二进制安装步骤

##上传二进制包到服务器
mysql-5.7.33-el7-x86_64.tar.gz

或者从下列地址下载需要的版本
https://downloads.mysql.com/archives/community/

##创建相关目录

mkdir /data/mysql_5_7_33/data
mkdir /data/mysql_5_7_33/binlogdata
chown mysql:mysql /data/mysql_5_7_33/data
chown mysql:mysql  /data/mysql_5_7_33/binlogdata
chmod 775 /data/mysql_5_7_33/data
chmod 775 /data/mysql_5_7_33/binlogdata

##编辑my.cnf参数

cat > /etc/my5733.cnf <<EOF
[client]
port=23306
socket=/tmp/mysql.sock

[mysqld]
port = 23306
socket=/tmp/mysql.sock
user = mysql
basedir = /data/mysql5733
datadir = /data/my5733data
pid-file = /data/my5733data/mysqld.pid

default_storage_engine = InnoDB
max_allowed_packet = 512M
explicit_defaults_for_timestamp = 1

skip-name-resolve
lower_case_table_names=1

innodb_buffer_pool_size = 512M
innodb_log_file_size = 1024M
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 0

#UNDO Tablespace Configuration
innodb_undo_directory = /var/lib/mysql/
innodb_undo_tablespaces = 3
innodb_undo_logs = 256
innodb_undo_log_truncate = ON
innodb_rollback_segments = 128

log-error = /data/my5733data/error.log
log_timestamps=system

server-id = 100
log-bin = /data/my5733data/mysql-bin
binlog_format = row
expire_logs_days = 7 ##mysql5.7

EOF

set global binlog_expire_logs_seconds=42460*60; ##mysql8.0
purge binary logs to ‘mysql80-bin.000164’;

初始化

./mysqld --defaults-file=/etc/my5733.cnf --initialize

手工启动mysql

cd /data/mysql5733/bin
/data/mysql5733/bin/mysqld --defaults-file=/etc/my5733.cnf --user=mysql &

重新设置密码

mysql -uroot -p$password

ALTER USER 'root'@'localhost' IDENTIFIED BY 'q1w2e3r4';
flush privileges;

P@ssw0rd1

设置systemd启动服务

cat > /usr/lib/systemd/system/mysqld573.service << EOF
[Unit]
Description=MySQL Server
Documentation=man:mysqld(7)
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=/data/mysql5733/bin/mysqld_safe --defaults-file=/etc/my5733.cnf
LimitNOFILE = 5000
EOF

systemctl daemon-reload

systemctl start mysql

systemctl enable mysql