MySQL进阶之mysql二进制安装和配置文件

---

二进制安装Mysql

//下载二进制格式mysql包
[root@139]# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz -C /opt/

//解压软件包
[root@139 opt]# tar xf mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz
[root@139 opt]# ls
mysql-5.7.38-linux-glibc2.12-x86_64

//创建用户
[root@139 opt]# useradd -M -r -s /sbin/nologin mysql
[root@139 opt]# id mysql
uid=995(mysql) gid=992(mysql) groups=992(mysql)

//创建软连接
[root@139 opt]# ln -sv mysql-5.7.38-linux-glibc2.12-x86_64/ mysql
'mysql' -> 'mysql-5.7.38-linux-glibc2.12-x86_64/'
[root@139 opt]# ll
total 0
lrwxrwxrwx. 1 root root  36 Jul 26 18:34 mysql -> mysql-5.7.38-linux-glibc2.12-x86_64/
drwxr-xr-x. 9 root root 129 Jul 26 18:30 mysql-5.7.38-linux-glibc2.12-x86_64

//修改属主和属组
[root@139 opt]# chown -R mysql.mysql mysql
[root@139 opt]# chown -R mysql.mysql mysql-5.7.38-linux-glibc2.12-x86_64/
[root@139 opt]# ll
total 0
lrwxrwxrwx. 1 mysql mysql  36 Jul 26 18:34 mysql -> mysql-5.7.38-linux-glibc2.12-x86_64/
drwxr-xr-x. 9 mysql mysql 129 Jul 26 18:30 mysql-5.7.38-linux-glibc2.12-x86_64

//配置环境变量
[root@139 opt]# cd mysql
[root@139 mysql]# ls
bin  docs  include  lib  LICENSE  man  README  share  support-files
[root@139 mysql]# echo 'export PATH=$PATH:/opt/mysql/bin' >/etc/profile.d/mysql.sh
[root@139 mysql]# source /etc/profile.d/mysql.sh
[root@139 mysql]# which mysql
/opt/mysql/bin/mysql

[root@139 mysql]# ln -s /opt/mysql/include  /usr/include/mysql
[root@139 mysql]# ll /usr/include/
total 0
lrwxrwxrwx. 1 root root 18 Jul 26 18:39 mysql -> /opt/mysql/include

[root@139 mysql]# echo '/opt/mysql/lib' > /etc/ld.so.conf.d/mysql.conf
[root@139 mysql]# cat /etc/ld.so.conf.d/mysql.conf
/opt/mysql/lib

[root@139 mysql]# vim /etc/man_db.conf
MANDATORY_MANPATH                       /opt/mysql/ma