mysql8 远程连接 - fubd/blowfish GitHub Wiki
切到 mysql 数据库, 修改 user 表
update mysql.user set host = '%' where user = 'root';
查看相关字段
select host, user, authentication_string from user;
调整加密方式
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'pasword';
授予权限
Grant all privileges on test.* to 'root'@'%';
curl 检查 ubuntu 的 3306端口能否远程连接
修改文件
/home/linuxbrew/.linuxbrew/etc/my.cnf 注释绑定的 127.0.0.1 ip