java.sql.SQLException: null, message from server: "Host '192.168.1.1' is not allowed to connect to this MySQL server"
该异常表示该Host不是远程对象,不能通过该对象远程访问数据库
解决方案:
方案一、授权
GRANT ALL PRIVILEGES ON *.* TO 'usrname'@'192.168.1.1' IDENTIFIED BY 'password' WITH GRANT OPTION;