Mysql的安装与备份

Mysql的二进制安装

[root@tj mysql]# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz
--2021-05-05 19:13:44--  https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz
正在解析主机 downloads.mysql.com (downloads.mysql.com)... 137.254.60.14
正在连接 downloads.mysql.com (downloads.mysql.com)|137.254.60.14|:443... 已连接。
已发出 HTTP 请求，正在等待回应... 302 Found
位置：https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz [跟随至新的 URL]
--2021-05-05 19:13:45--  https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz
正在解析主机 cdn.mysql.com (cdn.mysql.com)... 184.86.92.235
正在连接 cdn.mysql.com (cdn.mysql.com)|184.86.92.235|:443... 已连接。
已发出 HTTP 请求，正在等待回应... 200 OK
长度：661718255 (631M) [application/x-tar-gz]
正在保存至: “mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz”

mysql-5.7.33-linux-g 100%[====================>] 631.06M  21.2MB/s  用时 34s     

2021-05-05 19:14:20 (18.4 MB/s) - 已保存 “mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz” [661718255/661718255])

 创建用户

[root@tj mysql]#  useradd -r -M -s /sbin/nologin mysql

解压至指定目录

[root@tj mysql]#  tar xf mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz -C /usr/local

创建软链接或修改目录名

[root@tj ~]# cd /usr/local
[root@tj local]#  mv mysql-5.7.33-linux-glibc2.12-x86_64/ mysql
[root@tj local]# ls
bin  etc  games  include  lib  lib64  libexec  mysql  sbin  share  src

修改属组和属主

[root@tj local]# chown -R mysql.mysql /usr/local/mysql/
[root@tj local]# ll
总用量 0
drwxr-xr-x. 2 root  root    6 8月  12 2018 bin
drwxr-xr-x. 2 root  root    6 8月  12 2018 etc
drwxr-xr-x. 2 root  root    6 8月  12 2018 games
drwxr-xr-x. 2 root  root    6 8月  12 2018 include
drwxr-xr-x. 2 root  root    6 8月  12 2018 lib
drwxr-xr-x. 2 root  root    6 8月  12 2018 lib64
drwxr-xr-x. 2 root  root    6 8月  12 2018 libexec
drwxr-xr-x. 9 mysql mysql 129 5月   5 19:19 mysql
drwxr-xr-x. 2 root  root    6 8月  12 2018 sbin
drwxr-xr-x. 5 root  root   49 3月  27 02:54 share
drwxr-xr-x. 2 root  root