MySQL Error

Community support
#1

Hello everyone!
I’ve had my 000webhost account for a while now and I noticed the MySQL isn’t working. I am using mysql13.000webhost.com and it wont let me connect to it with one of my programs. I also tried http://www.rainbowspuppiessunshine.com/tools/dbtest/index.php and got a connection error.

Help Please!
-Emalton(ator)

Here is the error below

[17:21:53 WARN]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[17:21:53 WARN]: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[17:21:53 WARN]: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
[17:21:53 WARN]: 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[17:21:53 WARN]: 	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
[17:21:53 WARN]: 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[17:21:53 WARN]: 	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
[17:21:53 WARN]: 	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
[17:21:53 WARN]: 	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
[17:21:53 WARN]: 	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
[17:21:53 WARN]: 	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
[17:21:53 WARN]: 	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
[17:21:53 WARN]: 	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
[17:21:53 WARN]: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[17:21:53 WARN]: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
[17:21:53 WARN]: 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[17:21:53 WARN]: 	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
[17:21:53 WARN]: 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[17:21:53 WARN]: 	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
[17:21:53 WARN]: 	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
[17:21:53 WARN]: 	at java.sql.DriverManager.getConnection(DriverManager.java:571)
[17:21:53 WARN]: 	at java.sql.DriverManager.getConnection(DriverManager.java:215)
[17:21:53 WARN]: 	at com.intellectualcrafters.plot.database.MySQL.openConnection(MySQL.java:75)
[17:21:53 WARN]: 	at com.intellectualcrafters.plot.PlotMain.onEnable(PlotMain.java:1366)
[17:21:53 WARN]: 	at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)
[17:21:53 WARN]: 	at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:335)
[17:21:53 WARN]: 	at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
[17:21:53 WARN]: 	at org.bukkit.craftbukkit.v1_8_R1.CraftServer.loadPlugin(CraftServer.java:355)
[17:21:53 WARN]: 	at org.bukkit.craftbukkit.v1_8_R1.CraftServer.enablePlugins(CraftServer.java:315)
[17:21:53 WARN]: 	at net.minecraft.server.v1_8_R1.DedicatedServer.init(DedicatedServer.java:153)
[17:21:53 WARN]: 	at net.minecraft.server.v1_8_R1.MinecraftServer.run(MinecraftServer.java:494)
[17:21:53 WARN]: 	at java.lang.Thread.run(Thread.java:744)
[17:21:53 WARN]: Caused by: java.net.ConnectException: Operation timed out
[17:21:53 WARN]: 	at java.net.PlainSocketImpl.socketConnect(Native Method)
[17:21:53 WARN]: 	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
[17:21:53 WARN]: 	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
[17:21:53 WARN]: 	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
[17:21:53 WARN]: 	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
[17:21:53 WARN]: 	at java.net.Socket.connect(Socket.java:579)
[17:21:53 WARN]: 	at java.net.Socket.connect(Socket.java:528)
[17:21:53 WARN]: 	at java.net.Socket.<init>(Socket.java:425)
[17:21:53 WARN]: 	at java.net.Socket.<init>(Socket.java:241)
[17:21:53 WARN]: 	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)
[17:21:53 WARN]: 	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
[17:21:53 WARN]: 	... 24 more
#2

Try making sure that your Database username has full access / permissions to the database first. This is the most common source of connection failures when using scripts.

#3

Remote MySQL connections are not available for free accounts.

#4

oh, thanks :slight_smile:

#5

I have the same problem, I asked if buying a plan could have a connection from outside but they sent me to the forum. Does anyone know if paying for the hosting you can use a java netbeans mysql connector and connect from a program created from there?

#6

Sure premium will allow.