Page 1 of 1

Support for new default authentication plugin in mysql 8.0

Posted: Tue 01 May 2018 21:03
by KW
Does your component support the new authentication plugin?

caching_sha2_password is the default authentication plugin rather than mysql_native_password

https://dev.mysql.com/doc/refman/8.0/en ... ation.html


I tried to log into a new installation but received the following error:

InvalidOperationException: Unknown authentication plugin 'caching_sha2_password'.

Using Version 8.10.1061.0

Re: Support for new default authentication plugin in mysql 8.0

Posted: Wed 02 May 2018 11:14
by Pinturiccio
At the moment dotConnect for MySQL does not support MySQL 8.0 and caching_sha2_password. We will investigate the possibility to support it and post here about the results as soon as possible.

Re: Support for new default authentication plugin in mysql 8.0

Posted: Fri 25 May 2018 16:05
by Pinturiccio
We have supported the authentication plugin, caching_sha2_password. However, we have not fully supported MySQL 8.0 yet. Thus, some MySQL 8.0 features can be not supported. If you get some issues with MySQL 8.0 please notify us.

New build of dotConnect for MySQL 8.10.1152 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/mysql/download.html (trial version) or from Customer Portal (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=37214