rm -rf 88894
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/88894 
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/88894 --early-plugin-load=keyring_file.so --keyring_file_data=/export/umesh/server/binaries/GABuilds/mysql-5.7.20/88894/keyring --core-file --socket=/tmp/mysql_ushastry.sock --port=3307 --log-error=$PWD/88894/log.err 2>&1 &

-- 5.7.20

mysql> show variables like '%keyring%';
+-------------------+-------------------------------------------------------------------+
| Variable_name     | Value                                                             |
+-------------------+-------------------------------------------------------------------+
| keyring_file_data | /export/umesh/server/binaries/GABuilds/mysql-5.7.20/88894/keyring |
+-------------------+-------------------------------------------------------------------+
1 row in set (0.01 sec)

mysql> select plugin_name,plugin_status from information_schema.plugins where plugin_name  like '%keyring%';
+--------------+---------------+
| plugin_name  | plugin_status |
+--------------+---------------+
| keyring_file | ACTIVE        |
+--------------+---------------+
1 row in set (0.00 sec)

mysql> set global keyring_file_data='/tmp/keyring';
Query OK, 0 rows affected (0.00 sec)

mysql> select plugin_name,plugin_status from information_schema.plugins where plugin_name  like '%keyring%';
+--------------+---------------+
| plugin_name  | plugin_status |
+--------------+---------------+
| keyring_file | ACTIVE        |
+--------------+---------------+
1 row in set (0.00 sec)

## Tried below after checking with Vinay

mysql> ALTER INSTANCE ROTATE INNODB MASTER KEY;
ERROR 3185 (HY000): Can't find master key from keyring, please check keyring plugin is loaded.
mysql> show variables like '%keyring%';
+-------------------+--------------+
| Variable_name     | Value        |
+-------------------+--------------+
| keyring_file_data | /tmp/keyring |
+-------------------+--------------+
1 row in set (0.01 sec)

mysql> UNINSTALL PLUGIN keyring_file;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like '%keyring%';
Empty set (0.00 sec)

mysql> select plugin_name,plugin_status from information_schema.plugins where plugin_name  like '%keyring%';
Empty set (0.00 sec)

mysql> INSTALL PLUGIN keyring_file SONAME 'keyring_file.so';
Query OK, 0 rows affected (0.00 sec)


## Confirmed that it looks suspicious, and should have taken new location instead.

mysql> show variables like '%keyring%';
+-------------------+-------------------------------------------------------------------+
| Variable_name     | Value                                                             |
+-------------------+-------------------------------------------------------------------+
| keyring_file_data | /export/umesh/server/binaries/GABuilds/mysql-5.7.20/88894/keyring |
+-------------------+-------------------------------------------------------------------+
1 row in set (0.01 sec)

## Just confirmed that after falling back it works
mysql> ALTER INSTANCE ROTATE INNODB MASTER KEY;
Query OK, 0 rows affected (0.00 sec)

mysql>