unity连接mysql数据库登录

using UnityEngine;
using System.Collections;
using System.Data;
using MySql.Data;
using MySql.Data.MySqlClient;

public class MySQLConnection : MonoBehaviour
{
    private MySqlConnection connection;
    private string server;
    private string database;
    private string uid;
    private string password;

    // 初始化数据库连接参数
    void Initialize()
    {
        server = "localhost";
        database = "your_database_name";
        uid = "your_username";
        password = "your_password";
        string connectionString = "Server=" + server + ";Database=" + database + ";Uid=" + uid + ";Pwd=" + password + ";";
        connection = new MySqlConnection(connectionString);
    }

    // 连接到数据库
    public void ConnectToDatabase()
    {
        Initialize();
        try
        {
            connection.Open();
            Debug.Log("Connected to MySQL database!");
        }
        catch (MySqlException ex)
        {
            Debug.Log("Error connecting to MySQL database: " + ex.Message);
        }
    }

    // 关闭数据库连接
    public void CloseConnection()
    {
        if (connection != null)
        {
            connection.Close();
            Debug.Log("Disconnected from MySQL database!");
        }
    }
}