Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to connect W10 Universal App with MySQL database

I'm writing my first Windows 10 Universal App that operates on MySql database. I used code from this guide (It's for Windows 8 store apps):

https://blogs.oracle.com/MySqlOnWindows/entry/how_to_using_connector_net

But when I try to open connection with my database I get error:

An exception of type 'System.NotImplementedException' occurred in >MySql.Data.RT.dll but was not handled in user code

Additional information: SSL not supported in this WinRT release.

public class DBconnector
{
    static string server = "127.0.0.1";
    static string database = "hurtownia";
    static string user = "root";
    static string pswd = "root";

    public static bool login(string email, string password)
    {
        string connectionString = "Server = " + server + ";database = " + database + ";uid = " + user + ";password = " + pswd + ";";
        using (MySqlConnection connection = new MySqlConnection(connectionString))
        {
            connection.Open();
            MySqlCommand checkLogin = new MySqlCommand("select password_hash, password_salt from users where email = \""+email+"\"",connection);
            using (MySqlDataReader reader = checkLogin.ExecuteReader())
            {
                reader.Read();
                string hash = reader.GetString("password_hash");
                string salt = reader.GetString("password_salt");

                bool result = passwordGenerator.compare(password, hash, salt);

                if (result)
                    return true;
                else
                    return false;
            }
        }
    }
}

So, my question is how to fix that and correctly connect to MySql database in Windows 10 Universal App.

like image 283
Bartosz Karpiński Avatar asked Sep 07 '15 15:09

Bartosz Karpiński


People also ask

How do I connect to a MySQL database?

To Connect to a MySQL Database Expand the Drivers node from the Database Explorer. Right-click the MySQL (Connector/J driver) and choose Connect Using.... The New Database Connection dialog box is displayed. In the Basic Setting tab, enter the Database's URL <HOST>:<PORT>/<DB> in the corresponding text field.

How do I start MySQL GUI in Windows?

Launching MySQL Workbench on Windows. To start MySQL Workbench on Windows select Start, Programs, MySQL and then select MySQL Workbench. The MySQL Workbench version number is displayed followed by a usage message and then the options.

Does MySQL have a GUI?

Database GUIs have been created in order to make it easy to manage MySQL databases visually, without having to manually type SQL commands. GUIs make the processes of designing, creating, and administering databases easier and more convenient.


1 Answers

Add ";SslMode=None" to your connection string

like image 182
sLedgem Avatar answered Nov 13 '22 02:11

sLedgem