下载mysql-5.7.24的mysql的repo源,此yum源自动下载最新版本。
    下载完成后执行安装

    1. wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
    2. rpm -ivh mysql57-community-release-el7-8.noarch.rpm
    3. yum -y install mysql-server

    安装完成后
    修改my.cnf文件

    1. vim /etc/my.cnf
    2. [mysqld]
    3. #
    4. # Remove leading # and set to the amount of RAM for the most important data
    5. # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
    6. # innodb_buffer_pool_size = 128M
    7. #
    8. # Remove leading # to turn on a very important data integrity option: logging
    9. # changes to the binary log between backups.
    10. # log_bin
    11. #
    12. # Remove leading # to set options mainly useful for reporting servers.
    13. # The server defaults are faster for transactions and fast SELECTs.
    14. # Adjust sizes as needed, experiment to find the optimal values.
    15. # join_buffer_size = 128M
    16. # sort_buffer_size = 2M
    17. # read_rnd_buffer_size = 2M
    18. datadir=/var/lib/mysql
    19. socket=/var/lib/mysql/mysql.sock
    20. # Disabling symbolic-links is recommended to prevent assorted security risks
    21. symbolic-links=0
    22. log-error=/var/log/mysqld.log
    23. pid-file=/var/run/mysqld/mysqld.pid
    24. # 设置密码安全策略为0,低等级
    25. validate_password_policy=0
    26. # 设置编码
    27. character_set_server=utf8
    28. init_connect='SET NAMES utf8'
    29. # 忽略表名大小写
    30. lower_case_table_names=1
    31. skip-name-resolve

    [可选项 start]
    执行mysqld --initialize 初始化
    如果遇到 unknown variable 'validate_password_policy=0' 错误,在my.cnf中将这个变量注释掉
    如果遇到 The innodb_system data file 'ibdata1' must be writable 错误,执行此命令给mysql data文件夹赋予读写权限 chmod -R 777 /var/lib/mysql
    [可选项 end]

    使用 systemctl start mysqld 启动mysql服务
    使用 grep 'password' /var/log/mysqld.log 获取mysql初始密码
    使用刚刚获取的初始密码登录 mysql -uroot -p
    更改新密码 set password for root@localhost = password('your password');
    创建新用户,授权,刷新权限

    1. grant privileges ON databasename.tablename to 'username'@'host' idendified by 'password';
    2. flush privileges;

    PS.设置mysql自启动

    1. systemctl enable mysqld
    2. systemctl enable daemon-reload