mysql8-安装 - 掘金

1.处理mysql镜像源 & 安装mysql8

wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
rpm -ivh mysql80-community-release-el7-3.noarch.rpm
yum clean all && yum makecache
yum install -y  mysql-community-server

2.修改配置文件 & 修改用户密码

vim /etc/my.cnf
[mysqld]
port = 3306
character-set-server=utf8mb4
collation-server=utf8mb4_general_ci
lower_case_table_names=1 # 表名不区分大小写(启动前配置)
log_timestamps=SYSTEM #设置日志时区和系统一致
default_authentication_plugin=mysql_native_password #设置mysql8密码访问模式为native
[client]
default-character-set=utf8mb4

systemctl start mysqld
grep "A temporary password" /var/log/mysqld.log   #打印默认的mysql的root密码
mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';  #修改密码

3.开启远程连接

(上面如果已经配置mysql_native_password可以忽略)

USE mysql;
SELECT host, user, authentication_string, plugin FROM user; #查看当前用户列表
update user set host = '%' where user ='root';
FLUSH PRIVILEGES;  #刷新权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'MyNewPass4!';
FLUSH PRIVILEGES;