Yum 安装 Mysql

Mysql yum 源地址
https://dev.mysql.com/downloads/repo/yum/

#下载后安装yum源
yum localinstall mysql80-community-release-el7-1.noarch.rpm

#更新yum源
yum clean all
yum makecache

#开始安装MySQL
yum install mysql-community-server

#启动MySQL
systemctl start mysqld

#启动成功后可以查看初始化密码随机生成的
cat /var/log/mysqld.log | grep password

#登录MySQL修改mysql用户密码
mysql -u root -p
mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘yourpassword’;
#远程设置
mysql> use mysql;
mysql> update user set host=’%’ where user=‘root’;
#授权用户名的权限，赋予任何主机访问数据的权限
mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’%'WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

#启动mysql
systemctl start mysqld.service

#结束
systemctl stop mysqld.service

#重启
systemctl restart mysqld.service

#开机自启
systemctl enable mysqld.service

#修改加密规则 （这行我没有写，不过貌似也可以）密码需要设置包含大小写字母符号和数字的格式，否则设置不会超成功
ALTER USER ‘root’@’%’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;
#更新一下用户的密码
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘password’;
#刷新权限
FLUSH PRIVILEGES;