网站首页> 文章专栏> yum安装mysql5.7 采坑日记
yum安装mysql5.7 采坑日记
路人王 天津 2020-03-03 290 0 0

**1. 下载rpm安装包 wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm 2.本地安装 yum localinstall mysql57-community-release-el7-8.noarch.rpm 3.罗列 yum repolist enabled | grep "mysql.-community." 4.安装 yum install mysql-community-server 5.启动 systemctl start mysqld 6.开机自启 systemctl enable mysqld systemctl daemon-reload 7. mysql安装完成之后,在/var/log/mysqld.log文件中给root生成了一个默认密码。通过下面的方式找到root默认密码,然后登录mysql进行修改: mysql> set global validate_password_policy=0; 再修改密码的长度

mysql> set global validate_password_length=1; 再次执行修改密码就可以了

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; 8.远程登录 grant all on . to root@'%' identified by '123456' with grant option; flush privileges; **

mysql  

评论

评论  分享  打赏