[ Unity ] MariaDB 연결

1. Connection

string serverInfo = $"Server={IP};"
            + $" Database={TableName};"
            + $" Uid={ID};"
            + $" Pwd={PW};"
            + $" Port={PORT};"
            + $" CharSet=utf8;";

public MySqlConnection connection;
connection = new MySqlConnection(serverInfo);
connection.Open();

 

2. Command (SELECT)

string SQL_command = string.Format(@"SELECT User_name, User_Password FROM user_info WHERE User_name='{0}' AND User_Password = '{1}';", id, password);
MySqlCommand cmd = new MySqlCommand(SQL_command, connection);
public MySqlDataReader reader = cmd.ExecuteReader();

Debug.Log((string)reader["User_Name"].ToString()); // 속성명
Debug.Log((string)reader["User_Password"].ToString()); // 속성명

* HeidiSQL에서 사용자 권한 설정 필요