第一步:下载RPM包
wget http://repo.mysql.com/mysql57-community-release-el7-10.noarch.rpm
第二步:安装软件源
rpm -Uvh mysql57-community-release-el7-10.noarch.rpm
第三步:安装服务端
yum install -y mysql-community-server
第四步:启动mysql
service mysqld start
systemctl start mysqld.service
第五步:查找默认密码
grep 'temporary password' /var/log/mysqld.log
第六步:登陆并修改密码
修改密码: ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';
密码过于简单:
(1),修改validate_password_policy参数的值
set global validate_password_policy=0;
(2),再修改密码的长度
set global validate_password_length=1;
(3),修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';
第七步:授权其他机器登陆
GRANT ALL PRIVILEGES ON *.* TO 'root' @ '%' IDENTIFIED BY '数据库密码' WITH GRANT OPTION;
FLUSH PRIVILEGES;
第八步:数据库重启
service mysqld restart
systemctl restart mysqld.service
网友评论