c# - 连接到本地主机上的 MySQL 失败

Question

所以我尝试向 SQL 数据库添加一条新记录。 MySQL数据库服务器运行在XAMPP上，我将用户名配置为root，密码配置为test。我尝试过“localhost”和“127.0.0.1”作为服务器地址，但它们都不起作用。这是使用:

using System;
using System.Data;
using Gtk;
using MySql.Data;
using MySql.Data.MySqlClient;

当单击按钮时，它会捕获异常并显示错误消息，但我无法弄清楚为什么与服务器的连接失败。

protected void OnAddItemClicked(object sender, EventArgs e)
{
    MySqlConnection connection;
    string server = "localhost";
    string database = "shop";
    string uid = "root";
    string password = "test";
    string connectionString;
    connectionString = "SERVER=" + server + ";" + "DATABASE=" +
    database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";

    connection = new MySqlConnection(connectionString);

    try
    {
        connection.Open();
        if (connection.State == ConnectionState.Open)
        {
            MySqlCommand cmd = new MySqlCommand("INSERT INTO items (ItemName,Price,PriceVAT) values(@ItemName,@Price,@PriceVAT", connection);
            cmd.Parameters.Add("@ItemName", nameEntry.Text);
            cmd.Parameters.Add("@Price", priceEntry.Text);
            cmd.Parameters.Add("@PriceVAT", "1");
            cmd.ExecuteNonQuery();

            MessageDialog md = new MessageDialog(null, DialogFlags.Modal, MessageType.Info, ButtonsType.Ok, "Data entered successfully.");
            md.Run();
            md.Destroy();
        }
        else
        {
            MessageDialog md = new MessageDialog(null, DialogFlags.Modal, MessageType.Info, ButtonsType.Ok, "Database connection failed.");
            md.Run();
            md.Destroy();
        }

    }
    catch (Exception ex)
    {
        MessageDialog md = new MessageDialog(null, DialogFlags.Modal, MessageType.Info, ButtonsType.Ok, "Error occurred, please try again later");
        md.Run();
        md.Destroy();
    }

    connection.Close();
}

Answer 1

如果数据库用户和密码正确，则将您的连接字符串设置为

connectionString  = @"server=" + server  + ";userid=" + uid + ";password="
                       + password + ";database=" + database;

如果您的 mysql 端口不是默认端口(例如 3306)，那么您也可以指定自定义端口号，例如

connectionString = @"server=" + server + ";port=" + port + ";userid=" + uid  + ";password="
                       + password  + ";database=" + database;