MySql_8在线安装

一、查看是否已经安装过的mysql组件

rpm -qa | grep -i mysql

yum -y remove  #上一命令出现的组件，没有则跳过

1. 清理软件源

yum clean all

2. 建立源数据缓存

yum makecache

二、MySql8下载地址：https://dev.mysql.com/downloads/repo/yum/

wget https://dev.mysql.com/get/mysql80-community-release-el8-3.noarch.rpm  #连接在上面的下载地址找一下

1. 安装

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

2. 检查MySQL源是否安装成功

yum repolist enabled | grep mysql.*

3. 开始安装

yum install mysql-community-server

4.尝试启动

systemctl start mysqld

5. 查看状态

systemctl status mysqld

6. 设置开机启动

systemctl enable mysqld

7. 重载所有修改过的配置文件

systemctl daemon-reload

8. 查看MySQL下root账号的默认密码，并记在某处备用

grep 'temporary password' /var/log/mysqld.log #例：0%22kavoPwp4

9. 先修改配置文件，后设置密码（不修改也没事）

vim /etc/my.cnf #打开MySQL默认配置文件

一点简单的设置

##字符编码设置为utf8
character_set_server = utf8
init_connect = 'SET NAMES utf8'

MySql8.0的密码策略，简单的密码会设置不成功，绕个弯

mysql> SHOW VARIABLES LIKE 'validate_password%';   #下面是默认的密码策略，目前最新的mysql80-community-release-el7-5不设密码这里也出错
+--------------------------------------+--------+
| 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      |
+--------------------------------------+--------+

alter user 'root'@'localhost' identified by '!QAZ2wsx';
set global validate_password.policy=LOW; 
set global validate_password.length=6;
alter user 'root'@'localhost' identified by '123456';
注意，mysql重启后这些设置会还原，但密码已经设置好了

MySql8.0配置root远程访问，下面的命令已不再适用

grant all privileges on *.* to 'root' @'%' identified by '123456'; #会出错

查一下user表

mysql> use 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 |
| localhost | root             | $A$005$Y
FDGk`,m TyE%DwNWuNX4SsXWLZqQ4ef.eB0t0DDcQk5n4PdUc2vNQWA | caching_sha2_password |
+-----------+------------------+------------------------------------------------------------------------+-----------------------+

可以使用修改来完成

mysql> update user set host='%' where user='root';  # 也是设置可远程访问
mysql> grant all privileges on *.* to root@'%'
mysql> flush privileges;

或

create user 'xxx'@'%' identified by 'xxx';
Grant all privileges on *.* to 'xxx'@'%';
flush privileges;