Unable to connect to SQL

[globalkn]

Hello there,

I'm having some trouble here, basically I am unable to connect to the SQL server using this "xo6.x10hosting.com". Am i doing anything wrong?
If so, then what IP should I use?
I also tried to add the IP in Remote Hosts which was "176.57.188.201" but the result still was same, server responds: Connection to database failed.

So its like this

#define SQL_IP "http://xo6.x10hosting.com"
#define SQL_NAME "******"
#define SQL_PASSWORD "*******"
#define SQL_DB "******"
#endif
#define SQL_TABLE "******"

Btw I'm sure that SQL_DB and SQL_TABLE, also SQL_NAME are correctly written, so as password. Its only the IP tho.


Thanks.

 

[Anna]

For SQL_IP you should have localhost. Having a full weburl won't work in that scenario.

Remote mysql is not available at all if that is what you are trying to do, it is blocked on firewall level.

 

[globalkn]

So you mean, use SQL_IP "localhost" only?

 

[Anna]

Yes

 

[globalkn]

I already tried that too, even my coder said that it won't work and it didn't.

#define SQL_IP "localhost"
#define SQL_NAME "globalkn"
#define SQL_PASSWORD "******"
#define SQL_DB "globalkn_mod"
#endif
#define SQL_TABLE "globalkn_mod"

SQL_NAME I suppose is same as User.

 

[Anna]

SQL_NAME would be the user you created in the controlpanel and assigned to the database, usually in the form of user_dbname.

 

[globalkn]

As I mentioned, it didn't work. only writing "localhost" is meaningless.

Also, by saying "Remote mysql is not available at all" I hope you don't mean like sending queries to SQL and receiving results.

 

[caftpx10]

By "remote," they mean that only PHP scripts under the same server (including under your account) can connect to the database with the MySQL user you had set up, belonging to the same server. You cannot use remote database management software on your PC to access the database nor can you connect to databases that aren't hosted by that server (in this case, it's restricted to localhost and that only).

 

[sobakix2]

Remote mysql is not available at all if that is what you are trying to do, it is blocked on firewall level.

If that 'remote mysql' option was unavailable in the CP, I bet that would have saved folks a lot of head scratching