你好 https://blog.csdn.net/uirlvelo/article/details/115531897该五子棋对战平台项目中 请问怎么储存账号信息 是因为我数据库配置有问题吗
这个你根据提示去debug代码,看看查询有问题,还是数据库没有数据
能看看 帮忙解答一下吗
java.sql.SQLException: null, message from server: "Host 'LAPTOP-EIH6BHF0' is not allowed to connect to this MySQL server"
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1096)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2048)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.wupgig.common.JdbcUtils.getConnection(JdbcUtils.java:37)
at com.wupgig.dao.impl.BaseDAO.select(BaseDAO.java:57)
at com.wupgig.dao.impl.AddressDAOImpl.queryAccountByIP(AddressDAOImpl.java:20)
at com.wupgig.service.impl.AddressServiceImpl.queryAccountByIP(AddressServiceImpl.java:13)
at com.wupgig.login.UserLogin.rememberAccount(UserLogin.java:145)
at com.wupgig.login.UserLogin.<init>(UserLogin.java:88)
at com.wupgig.main.GobangMainApplication.start(GobangMainApplication.java:22)
at com.sun.javafx.application.LauncherImpl.lambda$launchApplication1$8(LauncherImpl.java:863)
at com.sun.javafx.application.PlatformImpl.lambda$runAndWait$7(PlatformImpl.java:326)
at com.sun.javafx.application.PlatformImpl.lambda$null$5(PlatformImpl.java:295)
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.javafx.application.PlatformImpl.lambda$runLater$6(PlatformImpl.java:294)
at com.sun.glass.ui.InvokeLaterDispatcher$Future.run$$$capture(InvokeLaterDispatcher.java:95)
at com.sun.glass.ui.InvokeLaterDispatcher$Future.run(InvokeLaterDispatcher.java)
at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
at com.sun.glass.ui.win.WinApplication.lambda$null$4(WinApplication.java:185)
at java.lang.Thread.run(Thread.java:750)
java.lang.NullPointerException
at com.wupgig.dao.impl.BaseDAO.select(BaseDAO.java:59)
at com.wupgig.dao.impl.AddressDAOImpl.queryAccountByIP(AddressDAOImpl.java:20)
at com.wupgig.service.impl.AddressServiceImpl.queryAccountByIP(AddressServiceImpl.java:13)
at com.wupgig.login.UserLogin.rememberAccount(UserLogin.java:145)
at com.wupgig.login.UserLogin.<init>(UserLogin.java:88)
at com.wupgig.main.GobangMainApplication.start(GobangMainApplication.java:22)
at com.sun.javafx.application.LauncherImpl.lambda$launchApplication1$8(LauncherImpl.java:863)
at com.sun.javafx.application.PlatformImpl.lambda$runAndWait$7(PlatformImpl.java:326)
at com.sun.javafx.application.PlatformImpl.lambda$null$5(PlatformImpl.java:295)
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.javafx.application.PlatformImpl.lambda$runLater$6(PlatformImpl.java:294)
at com.sun.glass.ui.InvokeLaterDispatcher$Future.run$$$capture(InvokeLaterDispatcher.java:95)
at com.sun.glass.ui.InvokeLaterDispatcher$Future.run(InvokeLaterDispatcher.java)
at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
at com.sun.glass.ui.win.WinApplication.lambda$null$4(WinApplication.java:185)
at java.lang.Thread.run(Thread.java:750)
java.sql.SQLException: null, message from server: "Host 'LAPTOP-EIH6BHF0' is not allowed to connect to this MySQL server"
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1096)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2048)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.wupgig.common.JdbcUtils.getConnection(JdbcUtils.java:37)
at com.wupgig.dao.impl.BaseDAO.select(BaseDAO.java:57)
at com.wupgig.dao.impl.AddressDAOImpl.queryAccountByIP(AddressDAOImpl.java:20)
at com.wupgig.service.impl.AddressServiceImpl.queryAccountByIP(AddressServiceImpl.java:13)
at com.wupgig.login.UserLogin.isRememberPassword(UserLogin.java:123)
at com.wupgig.login.UserLogin.<init>(UserLogin.java:91)
at com.wupgig.main.GobangMainApplication.start(GobangMainApplication.java:22)
at com.sun.javafx.application.LauncherImpl.lambda$launchApplication1$8(LauncherImpl.java:863)
at com.sun.javafx.application.PlatformImpl.lambda$runAndWait$7(PlatformImpl.java:326)
at com.sun.javafx.application.PlatformImpl.lambda$null$5(PlatformImpl.java:295)
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.javafx.application.PlatformImpl.lambda$runLater$6(PlatformImpl.java:294)
at com.sun.glass.ui.InvokeLaterDispatcher$Future.run$$$capture(InvokeLaterDispatcher.java:95)
at com.sun.glass.ui.InvokeLaterDispatcher$Future.run(InvokeLaterDispatcher.java)
at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
at com.sun.glass.ui.win.WinApplication.lambda$null$4(WinApplication.java:185)
at java.lang.Thread.run(Thread.java:750)
java.lang.NullPointerException
at com.wupgig.dao.impl.BaseDAO.select(BaseDAO.java:59)
at com.wupgig.dao.impl.AddressDAOImpl.queryAccountByIP(AddressDAOImpl.java:20)
at com.wupgig.service.impl.AddressServiceImpl.queryAccountByIP(AddressServiceImpl.java:13)
at com.wupgig.login.UserLogin.isRememberPassword(UserLogin.java:123)
at com.wupgig.login.UserLogin.<init>(UserLogin.java:91)
at com.wupgig.main.GobangMainApplication.start(GobangMainApplication.java:22)
at com.sun.javafx.application.LauncherImpl.lambda$launchApplication1$8(LauncherImpl.java:863)
at com.sun.javafx.application.PlatformImpl.lambda$runAndWait$7(PlatformImpl.java:326)
at com.sun.javafx.application.PlatformImpl.lambda$null$5(PlatformImpl.java:295)
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.javafx.application.PlatformImpl.lambda$runLater$6(PlatformImpl.java:294)
at com.sun.glass.ui.InvokeLaterDispatcher$Future.run$$$capture(InvokeLaterDispatcher.java:95)
at com.sun.glass.ui.InvokeLaterDispatcher$Future.run(InvokeLaterDispatcher.java)
at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
at com.sun.glass.ui.win.WinApplication.lambda$null$4(WinApplication.java:185)
at java.lang.Thread.run(Thread.java:750)