前提条件:centos7安装mysql8
1、下载mysql yum包
http://dev.mysql.com/downloads/repo/yum/
2、安装软件源
sudo rpm -Uvh platform-and-version-specific-package-name.rpm
例如:
rpm -Uvh mysql80-community-release-el7-2.noarch.rpm
3、安装mysql服务端
yum install -y mysql-community-server
4、启动mysql
service mysqld start
systemctl start mysqld.service
5、检查mysql运行状态
service mysqld status
6、登录并修改密码
登录:
mysql -uroot -p
7、更改密码强度:
set global validate_password.policy=0;
set global validate_password.length=1;
8、设置密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root123';
9、设置远程连接:
update user set host = "%" where user = "root";
FLUSH PRIVILEGES;