centos7下安装mysql5.7

Centos8 安装mysql5.7
https://computingforgeeks.com/install-mysql-5-7-on-centos-rhel-linux/

---

注意事项
本次使用的是 CentOS7 + MySQL 5.7.32 其他版本的 5.7 MySQL 应该也支持 本次不提供安装包，但提供安装包的下载地址，均为官网下载地址 如果报出权限不足的异常请在涉及到的命令前面加上 sudo，如果无法解决请联系系统管理员分配权限

---

安装步骤

1.安装jdk1.8

yum install -y java-1.8.0-openjdk*

2.去官网下载rpm包，使用命令

wget \
https://cdn.mysql.com/archives/mysql-5.7/mysql-community-client-5.7.32-1.el7.x86_64.rpm \
https://cdn.mysql.com/archives/mysql-5.7/mysql-community-common-5.7.32-1.el7.x86_64.rpm \
https://cdn.mysql.com/archives/mysql-5.7/mysql-community-libs-5.7.32-1.el7.x86_64.rpm \
https://cdn.mysql.com/archives/mysql-5.7/mysql-community-libs-compat-5.7.32-1.el7.x86_64.rpm \
https://cdn.mysql.com/archives/mysql-5.7/mysql-community-server-5.7.32-1.el7.x86_64.rpm
为了方便，来下载页面描述一下我们下载了那些 rpm

3.些安装包

yum install -y mysql-community-*-5.7.32-1.el7.x86_64.rpm

看到这个画面表示安装成功

4.启动服务并初始化密码

# 开启MySQL服务器
systemctl start mysqld
# 查看默认生成的密码
cat /var/log/mysqld.log | grep password

生成的密码如下：

使用该密码登录本地 MySQL 服务器：

mysql -uroot -h127.0.0.1 -p
然后输入以下命令修改默认密码：
# 设置密码等级
set global validate_password_length=4;
set global validate_password_policy=0;
# 修改默认密码，注意替换后面的密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
#grant这个不执行的话，就无法正确登陆
 GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '123456' WITH GRANT OPTION;
我们退出后发现密码已经设置完成
设置 root 账户远程登陆（此步骤如果不需要可以跳过），进入到 MySQL 命令行使用命令：
use `mysql`;
# 注意将密码替换掉
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '您的密码' WITH GRANT OPTION;
FLUSH PRIVILEGES;

4. 修改 /etc/my.cnf 文件来修改这个配置

vim /etc/my.cnf
修改之后：
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
character-set-server=utf8
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
character-set-server=utf8

6.systemctl restart mysqld 重启MySQL服务器

7.注意事项

安装后，会遇到两个错误，一是err日志权限不够，二是要删除/data/mysql里的文件 ,如果启动时提示ibdata1权限不足

vi /etc/selinux/config
setenforce 1

8.用户授权

create database db_dev default character set utf8mb4 collate utf8mb4_general_ci;
GRANT ALL PRIVILEGES ON *.* TO 'myserver'@'10.200.%.%' IDENTIFIED BY 'zo72YAlw5#Il' WITH GRANT OPTION;
grant select on udb.* to udb_read@103.238.132.109 IDENTIFIED by 'connect10.12'
grant all privileges on *.* to abc@"10.200.%.%" IDENTIFIED by 'su*Yd_4Y8fg4';
FLUSH PRIVILEGES;