使用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;

标签: none

添加新评论