mysql - 无法连接到网络mysql数据库

Question

我正在构建一个 Windows 应用商店应用程序，该应用程序旨在与位于本地网络服务器上的 MySql 数据库进行交互。我正在使用 MySQL 连接器/net RT 进行连接(适用于我的测试本地主机数据库)，问题是由于某种原因我无法连接到网络数据库；尽管我可以与具有相同连接字符串的不同 Win32 应用程序建立成功连接。我禁用了防火墙，我在主机上创建了一个新用户以从我的 AP 访问，等等。有人可以告诉我我做错了什么吗？

C#

using MySQL.Data.MySqlClient;
using Windows.UI.Popups;

MySqlConnection connection = new MySqlConnection("server=1.1.1.1;port=3306;database=mydb;uid=user;password=****;");
try{
    connection.Open();
    connection.Close();
}
catch (MySqlException e){
    MessageDialog md = new MessageDialog(e.ToString());
    md.ShowAsync();
}

//异常:打开连接失败

Answer 1

这就是我的连接方式。希望有帮助

Imports MySql.Data.MySqlClient
Public Class ClassMySqlConnect
Public Shared SQLConnect As String = "Server=YOURSERVERADDRESS; User Id=YOURID; Password=YOURPASSWORD;Database=YOURDATABASENAME"
Public Function connect(ByVal PlayerID As String) As String


    Dim SQLConnection = New MySqlConnection
    SQLConnection.ConnectionString = SQLConnect
    Try
        If SQLConnection.State = ConnectionState.Closed Then
            SQLConnection.Open()
            'Return "Sucessfully Connected to MySql Database"
        Else
            SQLConnection.Open()
            ' Return "Connection is closed"
        End If
    Catch ex As Exception
        ' Return ex.ToString()
    End Try



    Dim SQLStatement As String = "INSERT INTO Toons (PlayerID) Values('" + PlayerID + "')"
    Dim cmd As New MySqlCommand
    With cmd
        .CommandText = SQLStatement
        .CommandType = CommandType.Text
        .Connection = SQLConnection
        .ExecuteNonQuery()
    End With

    Return "successfully saved"

End Function

End Class