这个问题在这里已有答案:
我正在使用OsX并尝试将PHP Storm连接到MySQL . 虽然使用MAMP它工作正常,但现在我直接使用MySQL,从官方网站下载,PHPStorm不再连接到MySQL .
PHPStorm返回此错误:
与MyDatabase @ localhost的连接失败java.sql.SQLException:通信链路故障成功发送到服务器的最后一个数据包是0毫秒前 . 驱动程序未收到来自服务器的任何数据包 . at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)at java.lang.reflect.Constructor .newInstance(Constructor.java:513)位于com.mysql.jdbc.Util.handleNewInstance(Util.java:389)的com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1038)com.mysql.jdbc . MysqlIO . (MysqlIO.java:338)位于com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2237)的com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2270)com.mysql.jdbc . ConnectionImpl.createNewIO(ConnectionImpl.java:2069)位于com.mysql.jdbc.ConnectionImpl . (ConnectionImpl.java:794)的com.mysql.jdbc.JDBC4Connection . (JDBC4Connection.java:44)at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (本机方法)at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruc) torAccessorImpl.java:39)at the sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)at java.lang.reflect.Constructor.newInstance(Constructor.java:513)at com.mysql.jdbc.Util.handleNewInstance(Util .java:389)位于RemoteDriverImpl.connect(RemoteDriverImpl.java:27)中com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)的com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)在RemoteUtil.access $ 100(RemoteUtil.java:36)在远程用户名@ RemoteInvocationHandler.invoke(RemoteUtil.java:229)的com.sun.proxy . $ Proxy122.connect(未知来源)在LocalDataSource.getConnection(LocalDataSource.java:240) )由以下引起:java.net.ConnectException:java.net.PlainSocketImpl.mplConnect(PlainSocketImpl.java:382)中的java.net.PlainSocketImpl.smplConnect(Native Method)处于java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl . java:241)在java.net.So的java.net.PlainSocketImpl.connect(PlainSocketImpl.java:228) cksSocketImpl.connect(SocksSocketImpl.java:431),位于com.mysql.jdbc.MysqlIO的com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:213)的java.net.Socket.connect(Socket.java:527) . (MysqlIO.java:297)位于com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2237)的com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2270)com.mysql.jdbc.ConnectionImpl .createNewIO(ConnectionImpl.java:2069)位于com.mysql.jdbc.ConnectionImpl . (ConnectionImpl.java:794)的com.mysql.jdbc.JDBC4Connection . (JDBC4Connection.java:44)at sun.reflect.NativeConstructorAccessorImpl.newInstance0(本地方法)at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)at com.mysql.jdbc.ConnectionImpl.getInstance(Conn) ectionImpl.java:399)在RemoteDriverImpl.connect中的com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)(RemoteDriverImpl.java:27)
我认为这与配置有关,但我无法理解究竟是哪个问题 .
PHPMyAdmin只需使用用户和密码正确连接,而PHP Storm则不希望以任何方式连接 .
解决问题的好方法?谢谢!