Mysql安装

1. 下载mysql相关的rpm包，或者wget去下载

2. 解压rmp

     tar -xvf mysql-5.7.37-1.el7.x86_64.rpm-bundle.tar
   

3. 查询是否安装mysql或者mariadb

     rpm -qa|grep mysql
     rpm -qa|grep mariadb
   

4. 如果存在则卸载

     rpm -e --nodeps xxx
   
   

5. 依次进行安装

      rmp -ivh mysql-xxx-common-xxx
      rmp -ivh mysql-xxx-libs-xxx
      rmp -ivh mysql-xxx-client-xxx
      rmp -ivh mysql-xxx-server-xxx
   

6. 安装完毕后，启动mysql

     systemctl start mysqld
   

7. 查看临时登录日志

     vim /var/log/mysql.log
   

8. 登录后修改密码

     SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xxxx');
     GRANT ALL PRIVILEGES ON  *.* TO 'jxcp'@'%' identified by 'xxx' WITH GRANT OPTION;
     flush privileges;
   

9. 修改mysql配置文件

     vim /etc/my.cnf
     #增加下面配置项
     sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
     lower_case_table_names=1
     innodb_buffer_pool_size=4G
     max_allowed_packet = 1G
   
   

10. 重启数据库，创建数据库

      systectl restart mysqld
      
      #创建数据库
      CREATE DATABASE `jxcp_xxx` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;