I've created a VB application that has a login form, and I was hoping I'd be able to use the MySQL databases on the free hosting as a test before purchasing full hosting.
Unfortunately it's not letting me connect to the database?
I thought it might be a problem with my application at first but then I tried MySQL Administrator 1.2.17, but when I try I get this Error.
Picture of the error:
I'm pretty sure I'm filling it in correctly, Server Host: mysql3.000webhost.com; Port: 3306; Username: MYUSER; Password: PASSWORD.
Picture of the MySQL Admin
Is there anything you can suggest? I've looked at some MySQL threads but they said the problem is with the hosting so I thought I'd ask here before making ANOTHER thread on an alternative forum.
If needed, the code I'm using in my application to try and connect to the database is;
MySqlConnection = New MySqlConnection
MySqlConnection.ConnectionString = ("server=mysql3.000webhost.com; user=user; password=password; database=DATABASE;")
Dim MyAdapter As New MySqlDataAdapter
Dim SqlQuery = "SELECT * From Users WHERE Username='" & UsernameTextBox.Text & "'And Password='" & PasswordTextBox.Text & "';"
Dim Command As New MySqlCommand
Command.Connection = MySqlConnection
Command.CommandText = SqlQuery
MyAdapter.SelectCommand = Command
Dim MyData As MySqlDataReader
MyData = Command.ExecuteReader
If MyData.HasRows = 0 Then
MsgBox("Error - Wrong login info!")
accountName = UsernameTextBox.Text
MsgBox("Error connecting to server.", MsgBoxStyle.Exclamation)
UsernameTextBox.Text = ""
PasswordTextBox.Text = ""