mysql开启远程访问

1. 配置文件或者客户端的驱动连接参数中增加：

allowPublicKeyRetrieval=true&useSSL=false

eg:-Dspring.datasource.url=jdbc:mysql://127.0.0.1:3306/sdld?allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC

2. 进入mysql开放远程访问：
mysql -uroot -p
use mysql;

方式一：
UPDATE user SET `Host` = '%' WHERE `User` = 'root' LIMIT 1;

方式二：

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'amigo'

flush privileges;

参考链接：
https://blog.csdn.net/m0_67394002/article/details/123676691