1.上传安装包

2.检查mariadb并删除

rpm -qa | grep mariadbrpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

3.添加用户组和用户

groupadd mysqluseradd -r -g mysql mysql

4.解压安装包

cd /usr/local/tar -zxvf /usr/local/mysql-5.7.37-linux-glibc2.12-x86_64.tar.gz

5.重命名目录

mv /usr/local/mysql-5.7.37-linux-glibc2.12-x86_64 /usr/local/mysql

6.更改权限

chown -R mysql:mysql /usr/local/mysql

7.新建配置文件/etc/my.cnf

[client]# 设置mysql客户端默认字符集  default-character-set=utf8mb4#如果不设置会报错ERROR 2002 (HY000): Can't connect to local MySQL server through socketsocket=/data/mysql57/data/mysql.sock[mysqld]  #设置3306端口  port=3306  character-set-server=utf8mb4#设置数据目录等basedir=/usr/local/mysqldatadir=/data/mysql57/datasocket=/data/mysql57/data/mysql.sock# 禁用主机名解析skip-name-resolve# 创建新表时将使用的默认存储引擎  default-storage-engine=INNODB  #设置大小写是否敏感lower_case_table_names=1# 过小可能会导致写入(导入)数据失败max_allowed_packet = 256Mgroup_concat_max_len = 10240# 允许最大连接数  max_connections=200# 提到 join 的效率join_buffer_size=16M# 事务日志大小innodb_log_file_size = 256M# 日志缓冲区大小innodb_log_buffer_size = 4M# 事务在内存中的缓冲innodb_log_buffer_size = 3M[mysqldump]# 开启快速导出quickdefault-character-set = utf8mb4max_allowed_packet = 256M

8.安装libaio-0.3.109-13.el7.x86_64.rpm

#下载地址安装软件rpm -ivh /usr/local/libaio-0.3.109-13.el7.x86_64.rpm

9.创建目录设置权限

#递归创建目录mkdir -p /data/mysql57/data#更改权限chown -R mysql:mysql /data/mysql57/data

10.初始化安装，记录初始密码

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

11.开机自启动

cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqldchmod +x /etc/rc.d/init.d/mysqldchkconfig --add mysqldservice mysqld start

ln -s /usr/local/mysql/bin/mysql /usr/bin

13.登录系统，输入初始密码，修改密码，远程登录

mysql -uroot -pset password for root@localhost=password("sa@123");GRANT ALL PRIVILEGES ON *.* TO'root'@'%' IDENTIFIED BY 'sa@123' WITH GRANT OPTION;FLUSH PRIVILEGES;exit;

14.防火墙配置

firewall-cmd --zone=public --add-port=3306/tcp --permanentfirewall-cmd --reload