mySQL windows client authentication

[ampersx1]

Hi there,

I'm wondering if anyone out there uses a mySQL client to connect to their x10 database. About two weeks ago I was using HeidiSQL fine, but for the last two or so days it hasn't been authenticating. I have included my PC in the remote hosts option in cPanel.

I am using the following details
Network type: TCP/IP
IP: 198.91.81.2
user: ampersx1
password: <my account password>
port: 3306

The HeidiSQL logs is:
/* Connecting to 198.91.81.2 via MySQL (TCP/IP), username ampersx1, using password: Yes ... */
/* SQL Error (2003) in statement #0: Can't connect to MySQL server on '198.91.81.2' (10060) */

Is anyone else using a mySQL windows client to mange their database? I just tried mySQL Workbench and with the same details it failed on "test connection", or has something changed to the way we should be connecting to the x10 databases?

 

[essellar]

Remote MySQL connections (inbound or outbound) are not permitted on Free Hosting servers; you can only use the literal string "localhost" to connect. If you were EVER able to get a remote MySQL client working, it was because of a temporary configuration error which has since been fixed.

 

[bdistler]

the IP you show is for a free-hosting server - all x10hosting's free-hosting accounts - do not have remote MySQL database access (both incoming and outgoing from the account)
you might of had access during the cPanel update - until it was removed

 

[ampersx1]

Ok oh, cool, I didn't know that was not allowed. Thanks for the heads up.

I won't try again.

 

[leafypiggy]

It is allowed on our Premium hosting service.

 

[aporeuro]

so why do I have the choice to add remote servers if I cant use them???

 

[descalzo]

so why do I have the choice to add remote servers if I cant use them???

Because cPanel is a third-party piece of software that does not allow much customization, that is, you cannot remove "choices", even though those "choices" are not offered by the hosting company.