How to Connect to Online MYSQL Database?

[naseeh]

Hi, i am trying to create a program to show the table data added in my website mysql database :V
i have watched couple of youtube video's trying to figure out how to connect, none of them seems to work for me :v

This is what i got so far :V

Imports System.Data.SqlClient
Imports MySql.Data.MySqlClient

Public Class Form1
Dim con As New MySqlConnection
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
con.ConnectionString = "server=ftp.x.com; Port=port; userid=user; password=pass; database=table"
con.Open()
MsgBox("sucess")

End Sub

End Class

[jmcilhinney]

Is your MySQL server configured to allow direct connections from the internet? That is considered a security risk and not enabled by default.

[naseeh]

So to "Remote Database Access Hosts" i add my own ip address?

The error i get from running the program is, Same error as before i guess

An unhandled exception of type 'System.TimeoutException' occurred in MySql.Data.dll

[naseeh]

Still needing help with this :v

[techgnome]

well, you never really answered the question... is the database server even accessible from the outside? Most hosts don't allow their database servers to be connected from the outside world. Usually (if they are half-way decent) will have the database servers sitting behind a fire wall. You need to know this info before we can go any further.

-tg

[naseeh]

Well i found this in their forum so, i think it is :v
my website is on arvixe

How can I connect to my MSSQL database remotely?
Posted by Arvand Sabetian (Import) on 20 July 2009 04:52 AM
To connect to your MSSQL database remotely, please use a client that is capable of communicating with our MSSQL 2008 server on the TCP protocol. A free client is provided by Microsoft at: http://www.microsoft.com/downloads/d...displaylang=en

We recommend using Microsoft SQL Server 2008 Management Studio (link above) as many other tutorials and knowledgebase articles are written around supporting this free client by Microsoft. Only the 2008 version will be able to connect to our MSSQL servers. If you have the 2005 version, please upgrade. The 2008 client is backwards compatible with 2005 servers so you will still be able to connect to your MSSQL 2005 servers with the 2008 version.

[techgnome]

MYSql or MSSQL? MSSQL usually means SQL Server... which is NOT MySQL... so that right there might be the problem.

So, really, the first thing you need to decide is WHAT database system you're actually trying to talk to.

-tg

[naseeh]

hmm they do allow it

Do you allow remote MySQL access?
Posted by Arvand Sabetian (Import) on 26 December 2008 09:10 AM
Yes.

On our ASP plans, you can simply connect to the mysql server on port 3306 with the correct credentials. For hostname, simply use your domain name or the hostname of the server you are on (included in the setup email)

On our linux plans, you would need to add your IP (or the IP of the host connecting to the database) under the "Remote MySQL" section of the control panel. If your IP changes, you can input '%' which is a wildcard for any IP to have the ability to connect to your databases.

if this is not the answer ur looking for, help me out a little bit x.x
i just manage the database via cpanel > phpmyadmin