java.sql.SQLException: null, message from server: "Host '10.21.0.245' is not allowed to connect to this MySQL server解决方法:一.允许root用户在任何地方进行远程登录,并具有所有库任何操作权限,具体操作如下: 1、在本机先使用root用户登录mysql: mysql -u root -p"password" 2、进行授权操作: mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; 3、重载授权表:flush privileges;二.允许root用户在一个特定的IP进行远程登录,并具有所有库任何操作权限,具体操作如下: 1、在本机先使用root用户登录mysql: mysql -u root -p "password" 2、进行授权操作: GRANT ALL PRIVILEGES ON *.* TO root@"10.21.0.24" IDENTIFIED BY "password" WITH GRANT OPTION; 3、重载授权表:flush privileges;注:password是mySQl的登陆密码,ip换成本机ip
message from server: "Host '10.21.0.245' is not allowed to connect to this MySQL server
最新推荐文章于 2022-09-06 12:49:33 发布