I'm just trying to connect vb.net application to my cpanel web host space's mysql database.
I got some idea from internet and tryied. But It doesn't work for me. If you know about this help me. I think it was great help for others too.
my whole code is this :
Public Class Form1
Dim dr As MySqlDataReader
Dim con As New MySqlConnection
Dim da As New MySqlDataAdapter
Dim ds As New DataSet
Dim cmd As New MySqlCommand
Dim query As String
Public dt As DataTable
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
con.ConnectionString = "server=//220.127.116.11;Port=3306; User ID=xyz; password=#1dFs@#gc53; database=testonline"
Catch ex As Exception
however this say : "Unable to connect to ant specified host"