Connecting to Database

[~BLÃÐE~]

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.

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