mysql5.7初始密码修改
使用yum安装mysql后,先启动mysql服务
查看mysql密码:
grep 'temporary password' /var/log/mysqld.log
使用临时密码登陆:
mysql -uroot -p
修改root密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root123';
如果需要的话,可以授权其他机器访问:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;