以前は正しくMySQLへの接続ができていました。
しかし新しくデータベースを作成した後にEclipseで動的webプロジェクトを実行し、
MySQLへアクセスしようとすると以下のようなエラーが出てしまいます。
java.sql.SQLException: null, message from server: "Host 'localhost' is not allowed to connect to this MySQL server"
以下2つは試しましたが解決できませんでした。
・my.cnfのポート番号を3306から3308へ変更
・Eclipseの再インストール
環境
MacBook Air High Sierra 10.13.4
tomcat 8.5.31
Eclipse Photon 4.8.0
MySQL 8.0.11
以下、該当コードとエラー内容です。
DbUtility.java
Java
1package jp.co.db; 2 3import java.sql.Connection; 4import java.sql.DriverManager; 5import java.sql.SQLException; 6 7public class DbUtil { 8 public static Connection dbConnect() throws SQLException, ClassNotFoundException { 9 10 Class.forName("com.mysql.jdbc.Driver"); 11 // Connectionの生成 12 Connection con = DriverManager.getConnection( 13 "jdbc:mysql://localhost:3306/mysql?serverTimezone=UTC" // データベース 14 , "achm" // ユーザ 15 , "nia" // パスワード 16 ); 17 System.out.println(con); 18 return con; 19 20 } 21 22 public static void dbClose(Connection con) throws SQLException{ 23 con.close(); 24 } 25 26 } 27
Error
1java.sql.SQLException: null, message from server: "Host 'localhost' is not allowed to connect to this MySQL server" 2 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) 3 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) 4 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) 5 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1038) 6 at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190) 7 at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221) 8 at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016) 9 at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776) 10 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) 11 at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 12 at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 13 at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 14 at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:488) 15 at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) 16 at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) 17 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) 18 at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:678) 19 at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:229) 20 at jp.co.db.DbUtil.dbConnect(DbUtil.java:12) 21 at jp.co.ClientLogin.clientLogin(ClientLogin.java:18) 22 at jp.co.ClientLoginServlet.doPost(ClientLoginServlet.java:32) 23 at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) 24 at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) 25 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) 26 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 27 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) 28 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) 29 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 30 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) 31 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) 32 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496) 33 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) 34 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) 35 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) 36 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) 37 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) 38 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) 39 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) 40 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) 41 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1468) 42 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) 43 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) 44 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) 45 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) 46 at java.base/java.lang.Thread.run(Thread.java:844)
回答1件
あなたの回答
tips
プレビュー