MySQL Forums
Forum List  »  Newbie

Re: Can't find plugin: caching_sha2_password in 8.0 RC
Posted by: Georgi Kodinov
Date: February 27, 2018 03:29AM

Hi,
Care to share your exact configuration ?

FYI, on the server side the caching_sha256 is an "internal" (a.k.a. statically linked) plugin.

This is how I check if the plugin is present (hint: it always is, but may not be active):

mysql> select * from information_schema.plugins where plugin_name = 'caching_sha2_password'\G
*************************** 1. row ***************************
PLUGIN_NAME: caching_sha2_password
PLUGIN_VERSION: 1.0
PLUGIN_STATUS: ACTIVE
PLUGIN_TYPE: AUTHENTICATION
PLUGIN_TYPE_VERSION: 1.2
PLUGIN_LIBRARY: NULL
PLUGIN_LIBRARY_VERSION: NULL
PLUGIN_AUTHOR: Oracle
PLUGIN_DESCRIPTION: Caching sha2 authentication
PLUGIN_LICENSE: GPL
LOAD_OPTION: FORCE
1 row in set (0.01 sec)

If that's the case with your installation too then you can do:

mysql> CREATE USER foo IDENTIFIED WITH 'caching_sha2_password';
Query OK, 0 rows affected (0.12 sec)

mysql> SHOW CREATE USER foo\G
*************************** 1. row ***************************
CREATE USER for foo@%: CREATE USER 'foo'@'%' IDENTIFIED WITH 'caching_sha2_password' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT
1 row in set (0.00 sec)

And, if the caching_sha2_password is the default plugin (as it is in 8.0) you can omit the IDENTIFIED WITH part and still get the same result

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.