MySQL 5.6 ,5.7 ,8.0在安装部署的异同

5.6.44 二进制包安装部署

解压到以下目录

[root@oldboy ~]# ll /usr/local/mysql56/
drwxr-xr-x.  2 root root   4096 Jun  3 11:20 bin
-rw-r--r--.  1 7161 31415 17987 Mar 15 15:38 COPYING
drwxr-xr-x.  3 root root     18 Jun  3 11:19 data
drwxr-xr-x.  2 root root     55 Jun  3 11:19 docs
drwxr-xr-x.  3 root root   4096 Jun  3 11:19 include
drwxr-xr-x.  3 root root   4096 Jun  3 11:19 lib
drwxr-xr-x.  4 root root     30 Jun  3 11:19 man
drwxr-xr-x. 10 root root   4096 Jun  3 11:19 mysql-test
-rw-r--r--.  1 7161 31415  2496 Mar 15 15:38 README
drwxr-xr-x.  2 root root     30 Jun  3 11:19 scripts
drwxr-xr-x. 28 root root   4096 Jun  3 11:20 share
drwxr-xr-x.  4 root root   4096 Jun  3 11:19 sql-bench
drwxr-xr-x.  2 root root    136 Jun  3 11:19 support-files
[root@oldboy ~]# 

修改配置文件

[root@oldboy ~]# cat >/data/mysql56/my.cnf  <<EOF
[mysqld]
basedir=/usr/local/mysql56
datadir=/data/mysql56/data
socket=/tmp/mysql56.sock
user=mysql
log_error=/tmp/mysql56.log
skip_name_resolve
log_bin=/data/mysql56/mysql-bin
port=5606
server_id=5606
EOF

准备启动脚本

cat >/etc/systemd/system/mysqld56.service<<EOF