mysql 8 new authentication plugin

[amsm]

hi,
does Roundcube currently support new default authentication plugin "caching_sha2_password" in mysql 8.0 ?
if not, is this support planned in future version ?
Adam.

[JohnDoh]

It looks like there is no support for this in PHP yet. See https://bugs.php.net/bug.php?id=76243

[amsm]

mysql 8 documentation says that:

PHP: the X DevAPI PHP extension (mysql_xdevapi) supports caching_sha2_password.

(https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password)

It seems that this php extension Mysql_xdevapi works pretty well.
http://docs.php.net/mysql_xdevapi

[Devinney]

It looks like payday loans success story and there is no support for this in PHP yet. See https://bugs.php.net/bug.php?id=76243

Are you expecting much more support and info in the future, John?

[JohnDoh]

I found that PHP bug report with a quick search I don't know any more than that. For it to work in Roundcube I think support would need to be added into PDO.