MySQL Database from home?

[millerwk]

Hello,

How do I connect to my mySQL database using a third party application? I've read in the documentation that I can use port 3306, but I still seem to be missing something. I'm trying to connect to using the following information in Sql Server Management Studio:

Server Type: Database Engine
Server Name: <subdomain>.x10hosting.com:3306
Authentication: Windows Authentication

I'm still fairly new to database admin and would appreciate any help that anyone can provide. Thank you in advance.

 

[lhyman]

You are not allowed remote sql connections on X10 hosting. The only think that can access the sql server in your account is your web apps connecting to localhost. You can run PHP-admin from the control panel if you need to do maintenance....

 

[TechAsh]

I am confirming that lhyman is correct. We do not allow remote access to MySQL databases, if you need to access them you can use the tolls provided in cPanel or install your own MySQL admin tools on your account.

The reason we block remote access is that it was increasing the load on the servers, which degrades performance and makes things worse for everyone.

 

[misson]

Lastly, SQL Server Management Studio is for MSSQL Server, not MySQL. Instead, try phpMyAdmin in cPanel.