centos7 设置 mysql 登录密码
mysql安装完成之后,在/var/log/mysqld.log文件中给root生成了一个默认密码。通过下面的方式找到root默认密码,然后登录mysql进行修改:
grep 'temporary password' /var/log/mysqld.log
本地MySQL客户端登录
mysql -u root -p
密码是上一步查询出来的。输入后回车。
然后修改密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'TestBicon@123';
或者
set password for 'root'@'localhost'=password('TestBicon@123');
如果失败,请看 https://www.cnblogs.com/crazycode2/p/12395377.html
遇到 报错:1130-host ... is not allowed to connect to this MySql server
1、连接服务器: mysql -u root -p
2、看当前所有数据库:show databases;
3、进入mysql数据库:use mysql;
4、查看mysql数据库中所有的表:show tables;
5、查看user表中的数据:select Host, User from user;
6、修改user表中的Host:update user set Host='%' where User='root';
7、最后刷新一下:flush privileges;
遇到 Client does not support authentication protocal requested by server
alter user 'root'@'%' identified with mysql_native_password by 'password';
.