- 获取初始密码
一定要启动服务,不然可能log文件里只有上一次安装mysql的临时密码
systemctl start mysqld
grep 'temporary password' /var/log/mysqld.log
输出
2019-09-26T02:25:44.308864Z 1 [Note] A temporary password is generated for root@localhost: %M6SEFbghsI1
2019-10-06T03:01:09.870139Z 1 [Note] A temporary password is generated for root@localhost: mqs_d>9bwkoA
选择下面这个最新的mqs_d>9bwkoA
- 登陆mysql
mysql -uroot -p
然后输入密码。
- 修改密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
密码不符合规范。
必须修改两个全局参数:
首先,修改validate_password_policy参数的值
mysql> set global validate_password_policy=0;
再修改密码的长度
set global validate_password_length=1;
再次执行修改密码就可以了
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
- 授权其他机器登陆
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;