MYSQL的安装

二进制安装

安装依赖：

yum install make gcc gcc-c++ cmake bison-devel ncurses-devel -y
卸载玛锐DB：

yum remove mariadb-libs -y

环境准备：

useradd mysql -s /sbin/nologin

mkdir -p /var/log/mysql
mkdir -p /data/mysqldata
mkdir /data/binlog
chown mysql.mysql -R /data/binlog
chown mysql.mysql -R /var/log/mysql
chown mysql.mysql -R /data/mysqldata

下载二进制包

wget http://192.168.1.200/220711-note/mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz

安装：

tar -xvf mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz -C  /usr/local/

mv /usr/local/mysql-5.7.38-linux-glibc2.12-x86_64 /usr/local/mysql
chown mysql.mysql -R /usr/local/mysql

修改环境变量：echo 'export PATH=/usr/local/mysql/bin:$PATH' >> /etc/profile

配置文件/etc/my.cnf

[mysqld]
user=mysql
basedir=/usr/local/mysql
datadir=/data/mysqldata
server_id=5
log_bin=/data/binlog/mysql-bin
sync_binlog=1
binlog_format=row
expire_logs_days=15
max_binlog_size = 100M
gtid-mode=on
enforce-gtid-consistency=true
log-error=/var/log/mysql/error.log
slow_query_log = on
long_query_time = 2
slow-query-log-file = /var/log/mysql/slow.log
port=3306
socket=/tmp/mysql.sock
[mysql]
socket=/tmp/mysql.sock
[client]
socket=/tmp/mysql.sock

初始化

无密码初始化：

mysqld --initialize-insecure  --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysqldata

生成临时密码初始化：

mysqld --initialize  --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysqldata

加入启动服务：

cp support-files/mysql.server /etc/init.d/mysqld && chmod a+x /etc/init.d/mysqld
support-files/mysql.server start
chkconfig --add mysqld