Unity——连接mysq数据库

环境：

unity+vs2015

unity设置：edit->Project setting -> player ->API Compatibility Level  变成.NET 2.0

VS设置：.NET Framework 4.5.1

mysql.data.dll一定要从这里下，官网下的不好使 点击打开链接

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



public class conndb : MonoBehaviour {

    public static MySqlConnection dbConnection;
    // static string host = "localhost";  
    //如果是局域网，那么写上本机的局域网IP
    static string host = "localhost";//ip地址，如果是本机则写localhost，如果不是本机，则写安装数据库电脑的ip
    static string id = "root";//数据库的用户名
    static string pwd = "";//数据库的密码
    static string database = "db001";//数据库的名称  这里我的数据库名称为：examsystem

    public static void OpenSql()
    {

        try
        {
            string connectionString = string.Format("Server = {0};port={4};Database = {1}; User ID = {2}; Password = {3};", host, database, id, pwd, "3306");
            dbConnection = new MySqlConnection(connectionString);
            dbConnection.Open();
        }
        catch (Exception e)
        {
            throw new Exception("服务器连接失败，请重新检查是否打开MySql服务。" + e.Message.ToString());

        }

    }
}