CentOS 7 安装MySQL8

安装步骤

配置Mysql 8.0安装源
sudo rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
安装Mysql 8.0
sudo yum --enablerepo=mysql80-community install mysql-community-server
疑难杂症

​解决安装Mysql失败：GPG密钥已安装，但是不适用于此软件包的问题​


启动mysql服务
sudo service mysqld start
查看mysql服务运行状态
service mysqld status

安装后操作

设置root账号密码

查看临时密码
grep "A temporary password" /var/log/mysqld.log

执行后：

[root@localhost ~]# grep "A temporary password" /var/log/mysqld.log
2022-03-14T05:29:14.118728Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: _!dqQwpS*20K
登录mysql
mysql -uroot -p

执行后:

[root@localhost ~]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.28

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
更改临时密码

修改root密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '!QAZ2wsx';

查看MySQL密码规则：

mysql> SHOW VARIABLES LIKE 'validate_password.%';
+--------------------------------------+--------+
| Variable_name                        | Value  |
+--------------------------------------+--------+
| validate_password.check_user_name    | ON     |
| validate_password.dictionary_file    |        |
| validate_password.length             | 8      |
| validate_password.mixed_case_count   | 1      |
| validate_password.number_count       | 1      |
| validate_password.policy             | MEDIUM |
| validate_password.special_char_count | 1      |
+--------------------------------------+--------+
7 rows in set (0.02 sec)

配置远程访问

允许root远程登录

update user set host='%' where user ='root';

授予访问权限：

grant all privileges on *.* to 'root'@'%' with grant option;

刷新数据块：

FLUSH PRIVILEGES;

参考链接

  • https://developer.aliyun.com/article/842657