Can't connect to external server (MySQL)

[xUltimate]

Recently I tried to access my external server to use my MTA server's MySQL on it and it fails to connect, I am unsure why though.

Here is my settings file (Note: I have taken out parts for security purposes only)

<setting name="@sql.user" value="----" /> 
<setting name="@sql.password" value="----" /> 
<setting name="@sql.database" value="----_mtasa" /> 
<setting name="@sql.hostname" value="174.121.95.47" /> 
<setting name="@sql.port" value="3306" /> 

I have User, Password, and Database entered correctly, its either the hostname or the port that is throwing it off.

[dzek (varez)]

mysql database are REJECTING ALL CONNECTIONS from internet by default!

it's a protection - only local computers can access it.

go into your hoster control panel - there should be some options to allow remote connections (at all or from specific IP's).

also - remote mysql is slow

[Stratospheria]

you can select an option to allow remote connections when you intall your MySQL Server

[knash94]

  varez said:

mysql database are REJECTING ALL CONNECTIONS from internet by default!

it's a protection - only local computers can access it.

go into your hoster control panel - there should be some options to allow remote connections (at all or from specific IP's).

also - remote mysql is slow

Very laggy too, I would reccomend not using remote mysql from mta and ask your host if they can set you up an sql server. (If you have a host that is), I was trying this a few weeks back. Was too laggy, kept crashing the server too.

[xUltimate]

It's only temporary, I'm only using it to test my server that I have not connected to MTA for users to join, I use it to test my new UCP and such, we're having trouble getting the server to run on the hosting server but we'll fix it sometime soon.