Question

Help Setting Up mySQL Database

So I run a minecraft server network called GulchNetwork. I am currently setting up a vote for coins system, with the coins, players are able to purchase in-game items/ranks throughout any of the gamemodes. Each gamemode has it’s own server, so obviously each server would need to get its information on how many coins each player has from a mySQL database. I’m a noob with this though, this is my first time setting one up. I have bought a droplet, I have set this in the config file of the plugin I’m using (NetworkCoins).

MySQL: Host: (the droplet ip) Port: 3306 DbName: network_coins Username: root Password: (root password, correct)

I have everything filled out correctly, put the plugin gets this error. 07.03 04:39:21 [Server] WARN at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321) 07.03 04:39:21 [Server] WARN at me.josh.networkcoins.NetworkCoins.onEnable(NetworkCoins.java:72) 07.03 04:39:21 [Server] WARN at me.josh.networkcoins.NetworkCoins.openConnection(NetworkCoins.java:98) 07.03 04:39:21 [Server] WARN at java.sql.DriverManager.getConnection(Unknown Source) 07.03 04:39:21 [Server] WARN at java.sql.DriverManager.getConnection(Unknown Source) 07.03 04:39:21 [Server] WARN at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) 07.03 04:39:21 [Server] WARN at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) 07.03 04:39:21 [Server] WARN at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) 07.03 04:39:21 [Server] WARN at java.lang.reflect.Constructor.newInstance(Unknown Source) 07.03 04:39:21 [Server] WARN at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) 07.03 04:39:21 [Server] WARN at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) 07.03 04:39:21 [Server] WARN at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 07.03 04:39:21 [Server] WARN at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) 07.03 04:39:21 [Server] WARN at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) 07.03 04:39:21 [Server] WARN at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) 07.03 04:39:21 [Server] WARN at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) 07.03 04:39:21 [Server] WARN at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334) 07.03 04:39:21 [Server] WARN at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343) 07.03 04:39:21 [Server] WARN at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) 07.03 04:39:21 [Server] WARN at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) 07.03 04:39:21 [Server] WARN at java.lang.reflect.Constructor.newInstance(Unknown Source) 07.03 04:39:21 [Server] WARN at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) 07.03 04:39:21 [Server] WARN at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) 07.03 04:39:21 [Server] WARN at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 07.03 04:39:21 [Server] INFO The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. 07.03 04:39:21 [Server] WARN com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure 07.03 04:39:19 [Server] INFO Successfully registered /coins as your custom command 07.03 04:39:19 [Server] INFO Enabling NetworkCoins v0.5

If anybody could please help me with this, it would be greatly appreciated, for this is high priority for my server network.

Show comments

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

Hey there,

Normally MySQL listens on 127.0.0.1 by default for security purposes. It does not listen on the Droplet IP unless you change the bind-address to 0.0.0.0 to listen on all interfaces in the /etc/my.cnf file.

Happy coding,

Jon Schwenn Platform Support Specialist DigitalOcean