Bug #89266 Can't connect to mysql in uwp
Submitted: 16 Jan 2018 15:29 Modified: 23 Jan 2018 14:00
Reporter: Wang Vincent Email Updates:
Status: Unsupported Impact on me:
None 
Category:Connector / NET Severity:S1 (Critical)
Version:6.10.5 OS:Microsoft Windows (Windows 10)
Assigned to: CPU Architecture:Any

[16 Jan 2018 15:29] Wang Vincent
Description:
I'm using uwp to connect my sql server.
But I can't open it. In dbForge or Heidi SQL, the same server and uid works.

public static MySqlConnection CreateMySqlConnection()
        {
            string strConn = String.Format("server={0}; uid={1}; pwd={2}; database={3}",
                strServer, strUserID, strPassword, strDatabase);
            MySqlConnection conn = null;
            try
            {
                conn = new MySqlConnection();
                conn.ConnectionString = strConn;
                conn.Open();
            }
            catch (MySqlException myex)
            {
               
            }
            catch (Exception ex)
            {

            }

            return conn;
        }

How to repeat:
Build a uwp project, using the above code

Mysql 6.10.5
windows 10 16299
vs 15.5.3
[17 Jan 2018 9:27] Wang Vincent
For more info, visit https://github.com/hupo376787/TestMySQLConnection.git
[23 Jan 2018 6:23] Chiranjeevi Battula
Hello Tuomas,

Thank you for the bug report.
As per internal discussion with developers and they confirm that UWP is not supporting.
https://dev.mysql.com/doc/connector-net/en/connector-net-versions.html

Thank you for your interest in MySQL.

Thanks,
Chiranjeevi.
[23 Jan 2018 14:00] Wang Vincent
I'm very upset to hear the news.

Do you have a plan to publish a mysql version for uwp? We(uwp developers) really need it. Thanks,
[29 Jan 2018 5:58] Bradley Grainger
The InnerException indicates that you may be running into this problem: https://github.com/dotnet/corefx/issues/19783

If so, it looks like you may have to wait for .NET Core 2.1.