CentOS7 安装mysql8.0

1. 前往官方网站复制yum源链接Mysql官网的社区版下载地址官方下载
   -
2. 右键复制下载链接地址

https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

3. 安装wger

yum -y install wget

4. 下载mysql安装包

wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

5. 安装mysql源

yum -y install mysql80-community-release-el7-3.noarch.rpm

6. 查看安装结果

yum repolist enabled | grep mysql.*

7. 安装mysql服务

yum install mysql-community-server

8. 启动mysql服务

systemctl start  mysqld.service

9. 如果遇到Job for mysqld.service failed because the control process exited with error code. See “systemctl status mysqld.service” and “journalctl -xe” for details.

• 修改权限

ls -la /var/lib/mysql
chown -R  mysql:mysql  /var/lib/mysql

10. 查看初始密码

grep 'temporary password' /var/log/mysqld.log

11. 使用初始密码登录

mysql -uroot -p*****

12. 修改root初始密码，新密码需要包含大写字母，小写字母，数字，特殊符号

ALTER USER 'root'@'localhost' IDENTIFIED BY '****************';

13. 降低密码强度

set global validate_password.policy=0;
set global validate_password.length=1;

14. 创建远程登录账号

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

15. 修改远程协议

ALTER USER 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'password';

16. 允许远程访问

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%'WITH GRANT OPTION;

17. 刷新权限

flush privileges;

18. 查看用户表

use mysql;
select host, user, authentication_string, plugin from user;

19. 设置开机自启动

systemctl enable mysqld
systemctl daemon-reload

20. 打开防火墙端口

firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload