Novahq.net Forum - Connecting to Database

Hi guys im working on a chat app, i watched the video got the source code and nothing worked lol.

Anyways after some time and code change i got it working mostly properly on xampp. The DB works as do the tables....i imported it to my web hosted server but can't connect no matter what i try...

Whats need to go from xampp to my hosted phpmyadmin?
Yes i left the root and no password as i didn't want to post my details, but i did change them.

Code:



Imports System.IO

Imports System.Security.Cryptography

Imports MySql.Data.MySqlClient



Module DataModule1

    Public con As New MySqlConnection("server=localhost" & My.Settings.Host & "; user=root" & My.Settings.User & "; password=" & My.Settings.Pass & "; database=chat_db " & My.Settings.dbName)



    Public usernamefriend As String

    Public Sub Connect()

        If con.State = ConnectionState.Open Then

            con.Close()

            con.Open()

        Else

            con.Open()

        End If

    End Sub



    Public Function login(username As String, password As String)

        Connect()

        Dim cmd As New MySqlCommand("select * from users where username = @username and password = @password", con)

        cmd.Parameters.AddWithValue("@username", username)

        cmd.Parameters.AddWithValue("@password", password)

        Dim dt As New DataTable

        Dim dr As MySqlDataReader = cmd.ExecuteReader

        dt.Load(dr)

        Return dt

    End Function