centos7安装mysql8.0

centos7安装mysql8.0

下载mysql源

https://dev.mysql.com/downloads/repo/yum/

选择对应版本

注意：Linux 8对应centos 8,需要下载Linux 7

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

安装mysql源

yum localinstall mysql80-community-release-el7-3.noarch.rpm

检测是否安装成功

yum repolist enabled | grep "mysql.*-community.*"

输出

mysql-connectors-community/x86_64 MySQL Connectors Community                 212
mysql-tools-community/x86_64      MySQL Tools Community                      132
mysql80-community/x86_64          MySQL 8.0 Community Server                 283

安装mysql

yum install mysql-community-server

注意：默认是安装mysql8.0，如需安装5.7版本，需切换版本

启动数据库

systemctl start mysqld

重启数据库

systemctl restart mysqld

查看启动状态

systemctl status mysqld
或
service mysqld status

设置开机启动

systemctl enable mysqld
systemctl daemon-reload

查看默认密码

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

登录mysql

mysql -uroot -p

修改默认密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Test@123'

注意：密码需包含大小写、数字和特殊字符

查看密码策略（需要先修改默认密码）

show variables like '%validate_password%';

结果说明：

validate_password_policy：MEDIUM   密码策略，默认为MEDIUM策略

validate_password_dictionary_file   密码策略文件，策略为STRONG才需要

validate_password_length：8    密码最少长度8位

validate_password_mixed_case_count：1    大小写字符长度，至少1个

validate_password_number_count ：1      数字至少1个

validate_password_special_char_count：1     特殊字符至少1个

修改密码策略（可选）

需要修改/etc/my.cnf下的validate_password_policy配置

validate_password_policy=0   0-low , 1-medium , 2 - strong

validate_password = off  设置成不需要密码策略

授权root远程访问

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

查看数据库编码方式

SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%';

创建用户

CREATE USER 'test'@'%' IDENTIFIED BY 'test';

允许用户远程连接

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