mysql Server version: 5.7.33-0ubuntu0.16.04.1 (Ubuntu)
mysql刚下载,ubuntu配置好服务器后,win下无法用客户端登录,需要配置密码
#查看密码,authentication_string为密码,之前的版本该字段为password
1.select host,user,authentication_string,plugin from user;
#修改主机ip,原来是localhost,改成%意思是,可以匹配所有ip
update user set host = ‘%’ where user = ‘root’;
#修改plugin字段为mysql_native_password,否则后面密码设置会提示找不到password函数
update user set plugin=‘mysql_native_password’ where user=‘root’;
#修改密码
update user set authentication_string=password(‘你的密码’) where user=‘root’;
#更新权限
flush privileges;