Bug #89266 Can't connect to mysql in uwp

• Submitted: 16 Jan 2018 15:29
• Modified: 23 Jan 2018 14:00
• Reporter: Wang Vincent
• Status: Unsupported
• Category: Connector / NET
• Severity: S1 (Critical)
• Version: 6.10.5
• OS: Microsoft Windows (Windows 10)
• 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.