参考链接:https://blog.csdn.net/m0_37460012/article/details/90290148
https://blog.csdn.net/Rhdykx/article/details/106121259?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522160466873519725266963697%2522%252C%2522scm%2522%253A%252220140713.130102334…%2522%257D&request_id=160466873519725266963697&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2allbaidu_landing_v2~default-1-106121259.first_rank_ecpm_v3_pc_rank_v2&utm_term=java.sql.SQLNonTransientConnec&spm=1018.2118.3001.4449
今天在连接服务器数据库的时候出现了java.sql.SQLException: null, message from server: “Host ‘xxx’ is not allowed to connect的错误,
解决办法:
打开cmd,cd 进入mysql的安装路径下,然后看下图操作:
好了,问题解决,之后再次连接数据库,又出现了
Public Key Retrieval is not allowed的错误
解决办法:
在项目的JDBC连接数据库的url中,加上allowPublicKeyRetrieval=true参数
就可以连接到数据库了