1.使用初始账号密码登录
1)查看账号密码
cat /etc/mysql/debian.cnf
2)登录
mysql -u 用户名 -p
回车,输入密码;
切换数据库:
use mysql;
2.连接报错
ERROR 1130: Host ‘192.168.xx.xxx’ is not allowed to connect to this MySQL;
需要将mysql.user表中的root用户的host字段改为 %(或者需要连接的主机地址)
update user set host = '%' where user = 'root';
flush privileges;
3.密码错误
ERROR 1045:Access denied for user ‘root’@’192.168.xx.xxx’
需要修改root用户密码
flush privileges;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword';
flush privileges;
可能会报错,是因为root用户的host字段已被改为 %
因此 sql改为:
flush privileges;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'newpassword';
flush privileges;