to connect from my client to mysql

[scgm_project]

hi

I would like to connect with a client created in vb.net from myself from my PC to the my DB mysql on my domain into x10hosting​

I have already put this % in the control panel for "Remote MySQL"​

[SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]Imports [/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2][COLOR=#000000]MySql.Data.MySqlClient[/COLOR][/SIZE]  
 
 

[SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]Class [/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2][COLOR=#000000]MainForm[/COLOR][/SIZE] [LEFT][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]Public Sub New[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2]()[/SIZE][/LEFT]

 

[LEFT][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff] Me[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2][COLOR=#000000].InitializeComponent()[/COLOR][/SIZE]
 
[LEFT][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff] Dim [/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2]myConnectionString [/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]As [/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2][COLOR=#6f002f][SIZE=2][COLOR=#6f002f]String[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2]=[/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]Nothing[/COLOR][/SIZE][/COLOR][/SIZE]

[SIZE=2][COLOR=#000000] myConnectionString="database=my_db;datasource=my_name.x10hosting.com;user=my_user;password=my_pw;port=3306"[/COLOR][/SIZE]
[LEFT][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff] Dim [/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2][COLOR=#000000]myConnection [/COLOR][/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]As New [/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2][COLOR=#000000]MySqlConnection(myConnectionString)[/COLOR][/SIZE]
[SIZE=2] myConnection.Open()[/SIZE] 
[SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]End Sub[/COLOR][/SIZE][/COLOR][/SIZE]
[SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]End Class[/COLOR][/SIZE][/COLOR][/SIZE] [/LEFT]
[/LEFT]


[/LEFT]

but it dont connect...​

WHY?​

tks:dunno:​

Edit:

Nobody has the same problem?

The free version of x10hosting allows remote connection from a client?

I am stuck and I need an answer to my question!!

thanks Staff!​

 

[galaxyAbstractor]

you can't, it's blocked by the firewall

 

[xav0989]

Remote MySQL connections are blocked for security purpose. However, I've created a set of PHP scripts that enable some functionality of remote mysql connections. As my site is currently having some problems, I can't show it up to you. However, I can post the details on the thread. And since I only coded a php client for the set of scripts, you will have to create the client yourself (I will give you advices if you ask for).