Unity3D连接到MySQL错误

问题描述

我正试图让Unity客户端纯粹为读取建立与MySQL服务器的连接.建立连接时出现错误.

I'm trying to get Unity client to establish connection to MySQL server purely for reads. I get an error when the connection is being made.

我的代码:

using UnityEngine;
using System;
using System.Data;
using System.Text;
using System.Collections;
using System.Collections.Generic;
using System.Security.Cryptography;
using MySql.Data;
using MySql.Data.MySqlClient;

public class DatabaseHandler : MonoBehaviour {

    public string host, database, user, password;
    public bool pooling = true;

    private string connectionString;
    private MySqlConnection con = null;
    private MySqlCommand cmd = null;
    private MySqlDataReader rdr = null;

    private MD5 _md5Hash;

    void Awake() {

        DontDestroyOnLoad(this.gameObject);
        connectionString = "Server="+host+";Database="+database+";User ID="+user+";Password="+password+";Pooling=";
        if (pooling){
            connectionString += "true;";
        } else {
            connectionString += "false;";
        }

        try {
            con = new MySqlConnection(connectionString);
            con.Open(); //  THIS is line 47 in the error
            Debug.Log ("Mysql State: " + con.State);
        } catch (Exception e) {
            Debug.Log (e); //  THIS is line 51 in the error
        }

    }
}

错误:

谁能告诉我该错误如何解决?

Can anyone tell me how this error can be fixed?

谢谢！

推荐答案

解决方案:

必须将字符集添加到connnectionString.

Had to add the charset to the connnectionString.

谢谢@Roberto！ :-)

Thank you @Roberto! :-)

这篇关于Unity3D连接到MySQL错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！