Mysql配置环境以及设置远程连接

CentOS7使用yum 安装mysql8.0

下载mysql yum源

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

安装yum源

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

更新yum源

yum clean all
yum makecache

开始安装

yum install mysql-community-server

运行mysql

systemctl start mysqld

查看默认密码

grep "password" /var/log/mysqld.log

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';  

mysql8.0如果需要简单密码的话需要修改安全策略

set global validate_password.policy=0;
set global validate_password.length=4;

之后修改可远程登录mysql

8.0的设置与之前不同

use mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码';
FLUSH PRIVILEGES;
alter user set user.host='%' where user.user='root'
FLUSH PRIVILEGES;