[Solved] Mysql Remote Connections

[redstone]

Hi,

 

I am trying to use your databases to run a ban database with minecraft. I am using BanManager to do this and the web directory for this is http://creepercraft.epizy.com/Bans/. Whenever I try and connect to the database with the script, it tells me that there was a connection error. I have my minecraft server online and connected to the database so I am wondering if there is a connection limit on the databases. If there is, please could it be upped to about 4 connections as this would allow for multiple systems to check databases for information.

E.g.

A player bans someone in game.

That gets saved to the sql database (connection 1)

A user logs on to the ban database to see their ban (connection 2)

 

This would be helpful as it would allow users to create more complex applications.

[Krydos]

Have you enabled remote mysql connections in cpanel? You didn't state your server or username or domain or anything so here are links for both Johnny and Tommy. Click the one that your account is located on.

 

https://johnny.heliohost.org:2083/frontend/paper_lantern/sql/managehost.html

https://tommy.heliohost.org:2083/frontend/paper_lantern/sql/managehost.html

[Luigi123]

Moved to Customer Service.

[redstone]

It is allowed to have remote connections because the MC server plugin can connect with no issues.

The problem comes when a user tries to access the bans page (here) which connects to the same database.

At the point of posting this, there will always be a connection to the database which is the MC plugin.

Hence why I think this is a problem with the remote connection limit.

 

For future reference, I am on the Johnny server.

 

It works.

It seems I had not set up the wildcards properly.

Thanks!

 

Requesting thread lock.

Edited July 2, 2017 by redstone