to connect from my client to mysql

**scgm_project** · 06-26-2009 03:10 AM

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"

Code:

Imports MySql.Data.MySqlClient  
 
 

Class MainForm Public Sub New()
 

 Me.InitializeComponent()
 
 Dim myConnectionString As String=Nothing

 myConnectionString="database=my_db;datasource=my_name.x10hosting.com;user=my_user;password=my_pw;port=3306"
 Dim myConnection As New MySqlConnection(myConnectionString)
 myConnection.Open() 
End Sub
End Class

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** · 06-26-2009 05:56 AM

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

**xav0989** · 06-26-2009 09:55 AM

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).