java.sql.SQLException: null, message from server: “Host ‘192.168.43.1‘ is not allowed to connect to

红太狼 2024-04-07 13:50 77阅读 0赞

## 问题 ##

使用jdbc连接mysql jdbc中url的IP之地为Host '192.168.43.1 访问数据库报错  
java.sql.SQLException: null, message from server: “Host ‘192.168.43.1’ is not allowed to connect to this MySQL server”

2022-09-06 21:16:15.800 5164-5547/com.example.electronicmall W/System.err: java.sql.SQLException: null,  message from server: "Host '192.168.43.1' is not allowed to connect to this MySQL server"
    2022-09-06 21:16:15.800 5164-5547/com.example.electronicmall W/System.err:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
    2022-09-06 21:16:15.800 5164-5547/com.example.electronicmall W/System.err:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
    2022-09-06 21:16:15.800 5164-5547/com.example.electronicmall W/System.err:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
    2022-09-06 21:16:15.800 5164-5547/com.example.electronicmall W/System.err:     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040)
    2022-09-06 21:16:15.800 5164-5547/com.example.electronicmall W/System.err:     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
    2022-09-06 21:16:15.800 5164-5547/com.example.electronicmall W/System.err:     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)
    2022-09-06 21:16:15.800 5164-5547/com.example.electronicmall W/System.err:     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)
    2022-09-06 21:16:15.800 5164-5547/com.example.electronicmall W/System.err:     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
    2022-09-06 21:16:15.800 5164-5547/com.example.electronicmall W/System.err:     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    2022-09-06 21:16:15.800 5164-5547/com.example.electronicmall W/System.err:     at java.lang.reflect.Constructor.newInstance0(Native Method)
    2022-09-06 21:16:15.800 5164-5547/com.example.electronicmall W/System.err:     at java.lang.reflect.Constructor.newInstance(Constructor.java:343)
    2022-09-06 21:16:15.800 5164-5547/com.example.electronicmall W/System.err:     at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    2022-09-06 21:16:15.800 5164-5547/com.example.electronicmall W/System.err:     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
    2022-09-06 21:16:15.800 5164-5547/com.example.electronicmall W/System.err:     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
    2022-09-06 21:16:15.801 5164-5547/com.example.electronicmall W/System.err:     at java.sql.DriverManager.getConnection(DriverManager.java:580)
    2022-09-06 21:16:15.801 5164-5547/com.example.electronicmall W/System.err:     at java.sql.DriverManager.getConnection(DriverManager.java:218)
    2022-09-06 21:16:15.801 5164-5547/com.example.electronicmall W/System.err:     at com.example.electronicmall.Mapper.MYSQLDBOpenHelper.getConn(MYSQLDBOpenHelper.java:20)
    2022-09-06 21:16:15.801 5164-5547/com.example.electronicmall W/System.err:     at com.example.electronicmall.test.User.UserRegisterActivity$3.run(UserRegisterActivity.java:199)
    2022-09-06 21:16:15.801 5164-5547/com.example.electronicmall W/System.err:     at java.lang.Thread.run(Thread.java:929)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err: java.sql.SQLException: null,  message from server: "Host '192.168.43.1' is not allowed to connect to this MySQL server"
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040)
    2022-09-06 21:16:15.801 5164-5547/com.example.electronicmall I/QarthLog: [PatchStore] createDisableExceptionQarthFile
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)
    2022-09-06 21:16:15.801 5164-5547/com.example.electronicmall I/QarthLog: [PatchStore] create disable file for com.example.electronicmall uid is 10254
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at java.lang.reflect.Constructor.newInstance0(Native Method)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at java.lang.reflect.Constructor.newInstance(Constructor.java:343)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at java.sql.DriverManager.getConnection(DriverManager.java:580)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at java.sql.DriverManager.getConnection(DriverManager.java:218)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at com.example.electronicmall.Mapper.MYSQLDBOpenHelper.getConn(MYSQLDBOpenHelper.java:20)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at com.example.electronicmall.test.User.UserRegisterActivity$2.run(UserRegisterActivity.java:166)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall W/System.err:     at java.lang.Thread.run(Thread.java:929)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall I/QarthLog: [PatchStore] createDisableExceptionQarthFile
    2022-09-06 21:16:15.801 5164-5547/com.example.electronicmall E/AndroidRuntime: FATAL EXCEPTION: Thread-6
        Process: com.example.electronicmall, PID: 5164
        java.lang.NullPointerException: Attempt to invoke interface method 'java.sql.Statement java.sql.Connection.createStatement()' on a null object reference
            at com.example.electronicmall.test.User.UserRegisterActivity$3.run(UserRegisterActivity.java:206)
            at java.lang.Thread.run(Thread.java:929)
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall I/QarthLog: [PatchStore] create disable file for com.example.electronicmall uid is 10254
    2022-09-06 21:16:15.801 5164-5546/com.example.electronicmall E/AndroidRuntime: FATAL EXCEPTION: Thread-5
        Process: com.example.electronicmall, PID: 5164
        java.lang.NullPointerException: Attempt to invoke interface method 'java.sql.Statement java.sql.Connection.createStatement()' on a null object reference
            at com.example.electronicmall.test.User.UserRegisterActivity$2.run(UserRegisterActivity.java:170)
            at java.lang.Thread.run(Thread.java:929)
    2022-09-06 21:16:15.802 5164-5546/com.example.electronicmall I/Process: Sending signal. PID: 5164 SIG: 9

### 解决方案 ###

1 打开控制面板  
 w i n + R win+R win\+R  → \\rightarrow →  c m d cmd cmd  
2 登录到mysql

mysql -u root -p

3 检查数据库是否可用

use mysql;

4 查看host数据库

select host from user where user='root';

5 修改帐号不允许从远程登陆，只能在localhost（默认设置）。更改 “mysql” 数据库里的 “user” 表的 “host” 项，从"localhost"改为"%"

update user set host = '%' where user ='root';

6 刷新配置。

flush privileges;

具体操作过程如下图所示  
![请添加图片描述][c49fbfc7dd42497dac2bccd2d42e68a1.png]

### 原因 ###

由于mysql默认设置为修改帐号不允许从远程登陆，只能在localhost端登录。因此需要更改 “mysql” 数据库里的 “user” 表的 “host” 项，从"localhost"改为"%"（%通配符 表示任何操作对象都可以操作数据库）

参考文献

[is not allowed to connect to this mysql server][]

原创不易  
转载请标明出处  
如果对你有所帮助 别忘啦点赞支持哈  
![在这里插入图片描述][9cb4cb80a18345158f8a69e2f196e5b9.png]

[c49fbfc7dd42497dac2bccd2d42e68a1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/ad3b4ec664a745958329316630701605.png
[is not allowed to connect to this mysql server]: https://blog.csdn.net/iiiiiilikangshuai/article/details/100905996
[9cb4cb80a18345158f8a69e2f196e5b9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/eaf994ec869d43ff8f5547f5aad7f9a2.png

java.sql.SQLException: null, message from server: “Host ‘192.168.43.1‘ is not allowed to connect to

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 java.sql.SQLException: null, message from server: “Host ‘192.168.43.1‘ is not allowed to connect to

相关 Bug：解决java.sql.SQLException: null, message from server: “Host ‘XXX‘ is not allowed to connect异常

相关【MySQL异常】解决java.sql.SQLException: null, message from server: “Host xxx‘ is not allowed to connect to

相关 while opening read connection: jdbc:mysql message from server: Host is not allowed to connect to t

相关 null, message from server: “Host ‘xxx‘ is not allowed to connect to this MySQL server“

相关连接失败！null, message from server: “Host ‘xxxx‘ is not allowed to connect to this MySQL server“

相关 Java null, message from server: “Host ‘xxx‘ is not allowed to connect to this MySQL server“文件解决

相关 message from server: "Host is not allowed to connect to this MySQL server"解决办法

相关 Host is not allowed to connect to this MySQL server

相关 message from server: "Host is not allowed to connect to this MySQL server"解决办法