mysql5.7.24二进制安装

mysql5.7.24二进制安装

一、准备

1、删除机器上所有mysql有关的

rpm -qa |grep mysql
whereis mysql >>> 找的就rm掉
find / -name mysql >>> 找的就rm掉
rpm -qa|grep mariadb >>> rpm -e --nodeps mariadb-libs-5.5.60-1.el7-5.x86_64
删除etc目录下的my.cnf，一定要删掉：rm /etc/my.cnf
删除用户和组
groupdel mysql
userdel mysql

2、新增mysql用户和组

[root@k8s-master-30 100]# groupadd mysql
[root@k8s-master-30 100]# useradd -r -g mysql mysql

3、上传官网下载的tar包到/usr/local下

二、安装：

1、解压，并放置在/usr/local目录下，并更名mysql

[root@localhost local]# tar -zxvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
[root@localhost local]# mv mysql-5.7.24-linux-glibc2.12-x86_64/ mysql

2、设置环境变量

echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
source /etc/profile

3、配置MySQL

详细命令：

[root@localhost apps]# mkdir -pv /apps/mysql/data
[root@localhost apps]# touch /apps/mysql/mysql.sock
[root@localhost apps]# touch /apps/mysql/mysql.pid
[root@localhost apps]# mkdir /apps/mysql/log
[root@localhost log]# touch mysqld.log
更改用户组与授权
[root@localhost apps]# chown -R mysql:mysql /apps*
[root@localhost apps]# chmod 755 /apps/mysql/data
[root@localhost log]# chmod 755 /apps/mysql/log/mysqld.log
[root@localhost apps]# chmod 755 /apps/mysql/mysql.sock
[root@localhost apps]# chmod 755 /apps/mysql/mysql.pid

4、配置my.cnf，例如,具体路径和配置根据自己需求可以修改。

[mysqld]
basedir=/usr/local/mysql
datadir=/apps/mysql/data
port = 3306
socket=/apps/mysql/mysql.sock

symbolic-links=0
log-error=/apps/mysql/log/mysqld.log
pid-file=/apps/mysql/mysqld.pid
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
log-bin=mysql-bin 
binlog-format=ROW 
server_id=1 
max_connections=1000