二进制安装mysql5.7

卸载旧版本rpm包
rpm -qa|grep mysql -i
rpm -qa|grep mariadb -i
rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64


安装依赖包
yum install -y libaio perl perl-devel


解压软件包
tar -zxvf  mysql-5.7.42-linux-glibc2.12-x86_64.tar.gz -C /usr/local/


创建软链接
ln -s /usr/local/mysql-5.7.42-linux-glibc2.12-x86_64 /usr/local/mysql


创建运行的用户
groupadd mysql
useradd -g mysql -d /usr/local/mysql -s /sbin/nologin -M -n mysql


创建所需要的目录、修改权限
mkdir -p /data/mysql/3306
chown -R mysql:mysql /usr/local/mysql/
chown -R mysql:mysql /data/mysql


cat >  /data/mysql/my3306.cnf  << EOF
[client]
port                                        = 3306
socket                                      = /data/mysql/3306/mysql.sock

[mysql]
prompt                                      = "\\h:\\p_\\u@\\d \\R:\\m:\\s>"
no-auto-rehash  
default_character_set                       = utf8mb4

[mysqld]
port                                        = 3306
server_id                                   = 3306 
basedir                                     = /usr/local/mysql
datadir                                     = /data/mysql/3306
pid_file                                    = /data/mysql/3306/mysqld.pid
socket                                      = /data/mysql/3306/mysql.sock
tmpdir                                      = /data/mysql/3306
secure_file_priv                            = /data/mysql/3306
log_bin                                     = /data/mysql/3306/mysql-bin
log_bin_index                               = /data/mysql/3306/mysql-bin-index
slow_query_log_file                         = /data/mysql/3306/slow.log
log-error                                   = /data/mysql/3306/error.log
relay_log                                   = /data/mysql/3306/mysql-relay
relay_log_index                             = /data/mysql/3306/mysql-relay-index
innodb_buffer_pool_size                     = 200MB  
default_time_zone                           = "+8:00"
sql_mode                                    = ""
user                                        = mysql

## GTID
gtid_mode                                   = on
enforce_gtid_consistency                    = 1
master_info_repository                      = TABLE
relay_log_info_repository                   = TABLE

[mysqldump]
quick
max_allowed_packet                          = 2G
EOF


修改my.cnf权限
chown mysql:mysql /data/mysql/my3306.cnf


添加到环境变量
echo "export PATH=\$PATH:/usr/local/mysql/bin">>/etc/profile
source /etc/profile


初始化MySQL
/usr/local/mysql/bin/mysqld --defaults-file=/data/mysql/my3306.cnf --basedir=/usr/local/mysql   --user=mysql --initialize-insecure


启动MySQL
/usr/local/mysql/bin/mysqld --defaults-file=/data/mysql/my3306.cnf  &


修改密码
use mysql;
update mysql.user set authentication_string=password('chengce243') where user='root' ;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'chengce243' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'chengce243' WITH GRANT OPTION;
flush privileges;


关闭
/usr/local/mysql/bin/mysqladmin -uroot -pchengce243 -S  /data/mysql/3306/mysql.sock  shutdown