Unity连接MySql

环境

Unity:2021.3.6f1c1
MySql:8.0.33
MySql.Data.dll:6.10.9

准备

1. 安装MySql
2. 使用Nuget或其他方式下载MySql.Data.dll,版本6.10.9。(.NETFramework 4.5.2 No dependencies.)
3. dll导入Unity,放置在Plugins文件夹内
4. 此电脑右键管理，服务中找到MySql，确保服务启动

示例

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

public class MySqlTest : MonoBehaviour
{
    MySqlConnection mySqlConnection;

    private void Start()
    {
    	//连接mysql 
    	//设置连接地址 端口 数据库名 用户名 密码
        mySqlConnection = new MySqlConnection("server=localhost;port=3306;database=sakila;user=root;password=root;");
        try
        {
            mySqlConnection.Open();
            //查询actor表
            MySqlCommand command = new MySqlCommand("select * from actor", mySqlConnection);
            MySqlDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                testData.Add((reader[0], reader[1], reader[2], reader[3]).ToString());
            }
        }
        catch (System.Exception e)
        {
            Debug.LogError("连接失败：" + e.Message);
        }
        mySqlConnection.Close();
    }

    List<string> testData = new List<string>() { Capacity = 200 };
    Vector2 scrollPosition;
    private void OnGUI()
    {
    	//显示actor表格数据
        if (testData.Count > 0)
        {
            scrollPosition = GUILayout.BeginScrollView(scrollPosition);
            var length = testData.Count;
            for (int i = 0; i < length; i++)
            {
                GUILayout.Label(testData[i]);
            }
            GUILayout.EndScrollView();
        }
    }
}