jtrahair

It is installed already. I have a new domain which I installed it on.

This is a test procedure which looks up invoice 77 from the table of invoices which II wrote using VB.net. The error happens within the program on the line marked with <<<, ie. connMySQL.Open().

(Assume that all other items are in place and that when my laptop’s IP address is registered with the MySQL database everything works just fine. Obviously, the connection string has been modified for you to see, and that the xxx etc. are replaced by valid and working settings. I never use qwerty as a password!)

Dim strSQL As String = ""
        Dim connMySQL As New MySqlConnection
        Dim strResults As String = ""

        Try
	    'Set connection string:
            connMySQL.ConnectionString = "server=160.xxx.xxx.xxx;Port=3306; user id=i1234_wp1; password=qwerty; database=i1234_wp1;"

            connMySQL.Open()  <<<< error happens here.

            'Look up a test record, say invoice number 77:
            Dim cmd As New MySqlCommand
            cmd.Connection = connMySQL

            strSQL = "SELECT * FROM Invoices WHERE InvoiceNumberInt = 77
            cmd.CommandText = strSQL

            Dim myData As MySqlDataReader
            myData = cmd.ExecuteReader
            If myData.HasRows = 0 Then
                MsgBox("!")
            Else
                While myData.Read
                    'Display some of the data from invoice 77:
                    strResults = strResults & myData.GetValue(0).GetType.ToString & " " & myData.GetName(0) & " " & myData.GetValue(0) & vbCrLf
                    strResults = strResults & myData.GetValue(1).GetType.ToString & " " & myData.GetName(1) & " " & myData.GetValue(1) & vbCrLf
                    'etc.
                    strResults = strResults & myData.FieldCount & vbCrLf
                    strResults = strResults & vbCrLf
                End While
            End If
            myData.Close()
            cmd.Connection.Close()

            MsgBox(strResults)

        Catch ex As Exception
            MsgBox(ex.Message, vbExclamation, mCompanyName)
        End Try

So, are we saying that the WordPress database doesn’t mind what IP address wants to connect to it, so my Monday morning scenario won’t happen? (See above.)

Thanks, tsure. The MySQL/phpMyAdmin page shows 2 databases – the one I created and a WordPress database eg. i12345_wp1. Both are described as localhost in phpMyAdmin.
The customer will HTTP the server – how would it pass the SQL string and how will it pass back the data returned?
Thanks again.

WordPress is on a new domain set up and hosted by godaddy.