I have connected VB.net and mySQL on a the same PC before, but I have no Idea how to connect VB.net to a remote PC(LAN)
I've only changed the server
This is my code. I removed some of the details, but it works on server=localhost
conn = New MySqlConnection()
conn.ConnectionString = "server=[b]192.168.1.4[/b];" & _
"user id=root;" & _
"password=;" & _
"database=system"
Try
conn.Open()
MsgBox("You have control")
conn.Close()
Catch ex As Exception
MsgBox("Connection Failed")
End Try
I have turned off firewalls from both sides, and it keeps returning "Connection Failed"