CentOS7使用yum安装mysql8.0
一、首先查询系统当前是否安装了mysql
1:rpm -qa|grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64
2 :如果存在通过如下命令卸载
sudo rpm -e --nodeps mariadb-libs
二、配置yum源并下载wget
1. curl -o /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo
2. wget -O /etc/yum.repos.d/epel.repo http://mirrors.aliyun.com/repo/epel-7.repo
3. yum -y install vim wget
三、使用官方的yum源下载
!里插入图片描述](https://img-blog.csdnimg.cn/e2b3ba5c2c4c4933b3bc1863250d327e.png)
1 、 wget https://dev.mysql.com/get/mysql80-community-release-el7-4.noarch.rpm (复制下来的链接)
2 、yum install mysql80-community-release-el7-4.noarch.rpm
3 、生成yum缓存,避免安装出错
yum makecache
4、安装mysql服务
yum install -y mysql-community-server
如果报错
源 "MySQL 8.0 Community Server" 的 GPG 密钥已安装,但是不适用于此软件包。请检查源的公钥 URL 是否配置正确。
失败的软件包是:mysql-community-client-plugins-8.0.29-1.el7.x86_64
GPG 密钥配置为:file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
执行 sudo yum install mysql-server --nogpgcheck
5、启动mysql服务
启动mysqld 服务端 systemctl start mysqld
查看是否启动 systemctl status mysqld
三 、初始化mysql
mysql服务器初始化(从mysql 5.7开始)
在 mysql 服务器初始启动时,如果服务器的数据目录为空,则会发生以下情况:
mysql 服务器已初始化。
在数据目录中生成SSL证书和密钥文件。
安装并启用该 validate_password 插件。
将创建一个超级用户 帐户’root’@‘localhost’。并会设置超级用户的密码,将其存储在错误日志文件/var/log/mysqld.log中。
1. grep 'temporary password' /var/log/mysqld.log
2.尝试连接并修改默认密码
mysql -uroot -p'上方查看到的密码'
3 出现以下提示,说明要更改初始密码
修改初始密码
alter user root@localhost identified by '000000';
报错
密码过于简单不符合mysql的密码标准 执行
alter user root@localhost identified by 'Mysql@12';
成功
查看mysql密码规则
SHOW VARIABLES LIKE 'validate_password%';
//设置mysql可以使用简单密码
mysql> set global validate_password.policy=LOW;
Query OK, 0 rows affected (0.00 sec)
//设置mysql密码长度为6
mysql> set global validate_password.length=6;
Query OK, 0 rows affected (0.00 sec)
//更改root用户密码为简单密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
Query OK, 0 rows affected (0.00 sec)
use user
查看mysql允许登陆规则
mysql> select host,user,authentication_string,plugin from user;
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
| host | user | authentication_string | plugin |
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
| localhost | mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| localhost | mysql.session | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| localhost | mysql.sys | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
6sjocalhost | root | $A$005$2Xmb""`b|I
8 S> 60c4Eq07Manc.Nolukw7ZQMSv4lIqBYg3iitiK.yNN0 | caching_sha2_password |
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
4 rows in set (0.00 sec)
//更改允许任意IP登陆
mysql> update user set host = "%" where user = "root";
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
参考:https://blog.csdn.net/qq_55752792/article/details/122149990