none
mySQL - the database you're trying to connect to doesn't support encryption RRS feed

  • Question

  • Hi,

    We've installed the requisite connector but everytime we try to connect to our mySQL datasource (using Database access, not windows) we get the above error. When click "ok" to accept unencrypted it just returns the same error.

    We've managed to connect to this mySQL instance using odbc (although it had to be version 3.51 due to the verson of the mySQL instance we're connecting to) but using Power Query it won't play ball.

    Are there any settings we need to look at for older versions of mySQL (like we did for the odbc connector)?

    Thanks


    Mike Dobing

    Wednesday, November 26, 2014 3:50 PM

Answers

  • Hi Curt,

    I've managed to get round this now following on from my reply earlier.

    After googling on the error we found via the power query trace (thanks for that!) I found a forum discussion on the mysql site that suggested using an older version of the .net connector that supported the old pre 4.1 authentication protocol. The link is shown below:

    http://forums.mysql.com/read.php?38,593423,593431#msg-593431

    I installed the 6.4.6 connector (http://dev.mysql.com/downloads/file.php?id=410732) and we can now connect successfully.

    Thanks for your assistance on this.

    Mike


    Mike Dobing

    • Marked as answer by Mike Dobing Monday, December 1, 2014 10:08 AM
    Monday, December 1, 2014 9:39 AM

All replies

  • Which versions of MySQL and the MySQL ADO.NET driver are you using?
    Thursday, November 27, 2014 12:11 AM
  • Hi,

    The MYSQL version is 5.095 and the .net connector is 6.9.5.

    Thanks

    Mike


    Mike Dobing

    Thursday, November 27, 2014 10:03 AM
  • What we do is to make the connection string say "SslMode=Required" when encryption is specified and "SslMode=Preferred" when it is turned off. I haven't found any indication that there's a minimum version of the database required to support these, but your version of MySQL seems pretty recent anyway.

    Can you turn on tracing from the Options menu on the Power Query ribbon and then retry the connection? Afterwards, there should be some kind of underlying database exception in the trace file which would tell us what is actually going on. If you prefer, you can use the "Send a Frown" feature to send us the trace files.

    Sunday, November 30, 2014 1:12 PM
  • Hi Curt

    Thanks for getting back to me. By using the trace functionality you highlighted I was able to identify the error, and I now recall this is the reason we had to use the old 3.51 odbc connector for this instance.

    Basically it's to do with the "4.1 password" setting (I'm a SQL Server guy by trade so learning MySQL as I go) - and the error contained in the log is below:

    "Microsoft.Mashup.Container.NetFX40.exe Error: 0 : Authentication with old password no longer supported, use 4.1 style passwords." (we are connecting via a database login, not AD)

    I've found examples on how to get round this in .net code, but not sure if/how this can be done in Power Query?

    As before any assistance is greatly appreciated.

    Thanks


    Mike Dobing

    • Marked as answer by Mike Dobing Monday, December 1, 2014 9:40 AM
    • Unmarked as answer by Mike Dobing Monday, December 1, 2014 10:08 AM
    Monday, December 1, 2014 9:16 AM
  • Hi Curt,

    I've managed to get round this now following on from my reply earlier.

    After googling on the error we found via the power query trace (thanks for that!) I found a forum discussion on the mysql site that suggested using an older version of the .net connector that supported the old pre 4.1 authentication protocol. The link is shown below:

    http://forums.mysql.com/read.php?38,593423,593431#msg-593431

    I installed the 6.4.6 connector (http://dev.mysql.com/downloads/file.php?id=410732) and we can now connect successfully.

    Thanks for your assistance on this.

    Mike


    Mike Dobing

    • Marked as answer by Mike Dobing Monday, December 1, 2014 10:08 AM
    Monday, December 1, 2014 9:39 AM
  • Thanks @Mike. 

    Your solution of downloading mysql-connector-net-6.4.6.msi at http://dev.mysql.com/downloads/file.php?id=410732 worked.  

    Note for others: if you already have a version higher than 6.4.6, you will need to uninstall the mysql-connector program first before you install the mysql-connector-net-6.4.6.

    ERic

    Wednesday, April 8, 2015 3:13 AM