[ComYOU]

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;")
MySqlConnection.Open()

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!")
        Else
            accountName = UsernameTextBox.Text
            Form1.Show()
            Me.Close()
        End If

        MsgBox("Error connecting to server.", MsgBoxStyle.Exclamation)
        UsernameTextBox.Text = ""
        PasswordTextBox.Text = ""

Thanks.

[d3iti]

Hello,

Free accounts do not allow external connections to the databases.

[ComYOU]

Originally Posted by d3iti

Hello,

Free accounts do not allow external connections to the databases.

Ah OK, but if I purchase the hosting they will be allowed?

[d3iti]

For questions about premium accounts, we recommend that you visit http://hosting24.com.

They are the ones who manage the premium service, and they are best able to inform you about the features of premium accounts.

[ComYOU]

Alright, thanks for the quick replies!

[Aaf]

It is indeed a problem that you can't test what the payed services would be using the free service, as they block aspects like external database access. All they need to do is let you enter a trusted IP address, which is probably what they do on the payed site, as I saw described on other sites.
I know you can't be too demanding on a free service, and they will put some limits, but it does make it difficult to decide if what you are planning to build will work.
The monthly fee may be low, but only if you commit to it for years. A lot of money if it doesn't work out.

[ShocK]

http://www.hosting24.com/

Money back guarantee

Try out our services without any risk. If during the first 30 days you decide that our services do not fit your needs, you may cancel the account and receive a full refund

[Aaf]

Well, yes, that is PROMISED. As on page http://www.000webhost.com/free-mysql-hosting it is promised that the latest version of phpMyAdmin (which would be 3.5) is available. But all that is there is 2.11, and when you try to run the latest version, which turns out to use "SHOW DATABASES" (which is a completely standard and legitimate statement to find out the name of the databases you have access to, even if it is only 1 out of 1000), resulting in a 'slow query' messages being sent to your email (which you find out at the moment your site appears to have disappeared, and you want to send a message to inquire what has happened)).
So, I am not feeling so secure entrusting my money.

PS: Being treated well, maybe not pampered, but fairly, can give you trust in a company. To being arm-wrestled into paying for a service where 80% of the features are superfluous to your needs makes you rethink your plans.

[ShocK]

I can only speak from my own experience but dealing with 000webhost and dealing with hosting24 is like dealing with two seperate companies. one is a free service that needs to update it's ToS and what it advertises. The other is a professional service that does what it says on the tin (for me anyway) Any problems and they've always answered extremely quickly (live chat helps) and they've always informed me if anythings amiss, usually before I've noticed myself.
As for 30 day money back schemes, if it wasn't true I think they would have been sued by now and put out of business.

[Aaf]

Thank you. You may very well be right. But if whoever runs hosting24 has any say in what happens on 000web, they may better pull some strings, as they are doing them a disservice. If they are really separate, then I would in their case try to distance themselves as far from 000web as they could.