connect to database online?

[PiaYANG]

Hi Everyone , I have my old app dev from VB.net 2012 , Now I want it connect to database online, How can I do it ?
I use Cpanel for DB Cloud and in my app , I use mysql.data.dll version 6.9.8

 

[jdelano]

Typically your hosting dashboard will give you the connection info for the database. It might also indicate the version of a MySQL driver that is required for the version of MySQL Server that is running.

The connection string might look like:
dim cnStr As String = "Server=[ip_address];Port=3306;Database=[cpanel database name];Uid=[mysql user];Pwd=[user password];"
dim con As New MySqlConnection(cnStr)
con.open()