1.安装完成查看root初始密码
初始密码存放在/var/log/mysqld.log中,其中有一行为password is generated XXXXX,这个地方即为初始密码
也可以使用如下命令快速查看
grep "password is generated" /var/log/mysqld.log | awk '{print $NF}'
2.为用户修改密码
#将root的密码设置为123456
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'
3.设置mysql可以远程访问
# %代表哪里都可以访问,123456是密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;