创建用户和目录

创建用户：

groupadd mysql

useradd -g mysql mysql

创建目录

mkdir /data/mysql

mkdir /log/mysql

添加环境变量

vim /etc/profile

内容如下：

export MYSQL_HOME=/opt/mysql

export PATH=$PATH:$MYSQL_HOME/bin

source /etc/profile

 安装mysql依赖包

删除其他数据库

rpm -qa|grep mariadb

rpm -e  mariadb-libs --nodeps

安装依赖

yum -y install numactl libaio

安装mysql

解压mysql安装包

tar -zxf mysql-5.7.44-linux-glibc2.12-x86_64.tar.gz -C /opt/

创建软链接

ln -s /opt/mysql-5.7.44-linux-glibc2.12-x86_64 /opt/mysql

配置my.cnf

vi /etc/my.cnf

[client]

socket=/opt/mysql/mysql.sock

[mysql]

socket=/opt/mysql/mysql.sock

[mysqld]

log_error=/log/mysql/err.log

port = 3306

socket=/opt/mysql/mysql.sock

basedir=/opt/mysql

datadir=/data/mysql

server-id = 1  

auto_increment_offset = 1

auto_increment_increment = 2

log-bin = mysql-bin                                                    

binlog-format=ROW

gtid-mode=on

enforce-gtid-consistency=true

master-info-repository=TABLE

relay-log-info-repository=TABLE

sync-master-info=1

slave-parallel-workers=0

sync_binlog=0

binlog-checksum=CRC32

master-verify-checksum=1

slave-sql-verify-checksum=1

binlog-rows-query-log_events=1

expire_logs_days=7

max_binlog_size=1024M

修改权限

chown -R mysql:mysql /opt/mysql/

chown -R mysql:mysql /data/mysql

chown -R mysql:mysql /log/mysql 

启动mysql

1. 设置开机自启:

cp -a /opt/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld

2. 初始化:

su - mysql

cd /opt/mysql/bin

./mysqld --initialize --user=mysql --basedir=/data/mysql

3. 启动：

su - mysql

chmod +x /etc/rc.d/init.d/mysqld

/etc/init.d/mysqld start