MYSQL数据库Rpm包安装

1.进mysql官网下载页https://dev.mysql.com/downloads/

2.选择MySQL Community Server

3.选择旧版本Looking for previous GA versions?

4.操作系统选：Red Hat

5.下载套件：mysql-5.7.38-1.el7.x86_64.rpm-bundle.tar

6.上传到服务器/opt/mysql目录

7.检查是否自带MARIADB：rpm -qa|grep mariadb

8.有就删除掉：rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64

9.按顺序安装：

rpm -ivh mysql-community-common-5.7.38-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.38-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-5.7.38-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-5.7.38-1.el7.x86_64.rpm

1. 数据库初始化：mysqld --initialize --user=mysql
2. 查看初始密码：grep "password" /var/log/mysqld.log
3. 启动MYSQL数据库：systemctl start mysqld.service
4. 进入数据库：mysql -uroot -p
5. 修改默认密码：alter user 'root'@'localhost' IDENTIFIED BY 'new_password';
6. 创建远程访问账号：

create user 'root'@'%' identified by 'new_password';

grant all privileges on *.* to 'root'@'%';

flush privileges;

1. 创建资产数据库：

CREATE DATABASE `business_assets` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

1. 修改mysql配置：

#lower_case_table_names表名大小写不敏感                  

lower_case_table_names=1                      

#sql-mode支持日期为0000-00-00 00:00:00                   

sql-mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION     

# 允许最大连接数                      

max_connections=1000                      

# 允许连接失败的次数。这是为了防止有人从该主机试图攻击数据库系统

max_connect_errors=10                     

# 服务端使用的字符集默认为UTF8                   

character-set-server=utf8  

# 创建新表时将使用的默认存储引擎                      

default-storage-engine=INNODB                     

#缓存池                   

innodb_buffer_pool_size=4G 

# 按事务刷盘，刷日志 [0:最快模式,1:安全模式,2:比0安全但比0要慢]看需求，服务器较为稳定可以选择2，自己搭建的最好选择1                    

innodb_flush_log_at_trx_commit=1   

# 默认8小时。交互等待时间和非交互等待时间                    

# 建议300~500s,两参数值必须一致，且同时修改                  

interactive_timeout=3600

wait_timeout=3600