ubuntu20下载mysql8
1,登进MySQL之后,
2,输入以下语句,进入mysql库:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'hdk';
FLUSH PRIVILEGES;
use mysql
3,更新域属性,'%'表示允许外部访问:
update user set host='%' where user ='root';
4,执行以上语句之后再执行:
FLUSH PRIVILEGES;
5,再执行授权语句:
GRANT ALL PRIVILEGES ON . TO 'root'@'%'WITH GRANT OPTION;
然后外部就可以通过账户密码访问了。