Re: Can't find plugin: caching_sha2_password in 8.0 RC
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
Subject
Written By
Posted
February 26, 2018 03:06PM
Re: Can't find plugin: caching_sha2_password in 8.0 RC
February 27, 2018 03:29AM
February 27, 2018 01:02PM
February 28, 2018 02:14AM
February 28, 2018 08:16AM
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.