cant use custom mysql DNS

[moraru]

inter_athena:

 

// Global SQL settings
// overridden by local settings when the hostname is defined there
// (currently only the login-server reads/obeys these settings)
sql.db_hostname: mysql.nixiweb.com
sql.db_port: 3306
sql.db_username: u492019762_test
sql.db_password: test
sql.db_database: u492019762_test
sql.codepage:

// MySQL Character SQL server
char_server_ip: mysql.nixiweb.com
char_server_port: 3306
char_server_id: u492019762_test
char_server_pw: test
char_server_db: u492019762_test

// MySQL Map SQL Server
map_server_ip: mysql.nixiweb.com
map_server_port: 3306
map_server_id: u492019762_test
map_server_pw: test
map_server_db: u492019762_test

// MySQL Log SQL Database
log_db_ip: mysql.nixiweb.com
log_db_port: 3306
log_db_id: u492019762_logs
log_db_pw: test
log_db_db: u492019762_logs
log_codepage:
log_login_db: loginlog

 

 

I need to move all db and web from vps to some other host, fluxCP works well but server fails to conect to mysql.nixiweb.com, is not a rong pass or user error it just cant conect to the DNS.All my other php projects works well with nixiweb.com

 

any advice please

 

 

[Winz]

i believe you are hosting the MySQL db server on 000webhost.com or something like that right, (idhostinger, or others). They provide the free database server and you can use it, BUT it only works on localhost. what I mean is they do not open the 3306 port.

 

If you have a MySQL Manager (MySQL Workbench, QueryBrowser, Server Administrator, or others), and ask to connect to your free MySQL server, connection will be always rejected unless you pay for the premium services.

indo?

[Emistry]

are you sure the DNS is the correct one ? 

[moraru]

are you sure the DNS is the correct one ? 

yeah, hoster only gives non ip dns for mysql. My other php webs works well with mysql_connect('mysql.nixiweb.com', 'user', 'pass'). if with php works no know why with c# should not. maybe is rathena accepts only ip dns, no know...fluxCP works with this dns too.

Edited October 10, 2014 by moraru

[moraru]

i believe you are hosting the MySQL db server on 000webhost.com or something like that right, (idhostinger, or others). They provide the free database server and you can use it, BUT it only works on localhost. what I mean is they do not open the 3306 port.

 

If you have a MySQL Manager (MySQL Workbench, QueryBrowser, Server Administrator, or others), and ask to connect to your free MySQL server, connection will be always rejected unless you pay for the premium services.

indo?

I think your right, now I noticed that most of the web host providers including payd ones dosent allow external mysql conections and only with their internal hosting space I guess to avoid all sorts of scripts or attacks at ur database, thanks you.

Edited October 10, 2014 by moraru