由于 mysql_native_password 错误，AIQUM OCIE 服务无法启动
适用于
- Active IQ Unified Manager (AIQUM) 9.16+
- Windows 平台
问题
- 停止服务后，ocie服务的重新启动挂起并且未完成
- 由于 HTTP 错误 404，无法访问 AIQUM Web GUI
- 错误
server.log：
Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=localhost)(port=3306)(type=master) : Client does not support authentication protocol requested by server. plugin type was = 'mysql_native_password'
at org.mariadb//org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73) [mariadb-java-client.jar:]
at org.mariadb//org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192) [mariadb-java-client.jar:]
at org.mariadb//org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1346) [mariadb-java-client.jar:]
at org.mariadb//org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:634) [mariadb-java-client.jar:]
at org.mariadb//org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150) [mariadb-java-client.jar:]
at org.mariadb//org.mariadb.jdbc.Driver.connect(Driver.java:89) [mariadb-java-client.jar:]
- 在 MySQL 中运行以下查询，显示 jboss 用户设置为使用 mysql_native_password 身份验证协议插件：
mysql> select Host,User,plugin,password_last_changed from mysql.user;
+-----------+------------------+-----------------------+-----------------------+
| Host | User | plugin | password_last_changed |
+-----------+------------------+-----------------------+-----------------------+
| localhost | jboss | mysql_native_password | 2023-03-29 16:17:40 |
| localhost | mysql.infoschema | caching_sha2_password | 2023-03-29 12:20:19 |
| localhost | mysql.session | caching_sha2_password | 2023-03-29 12:20:19 |
| localhost | mysql.sys | caching_sha2_password | 2023-03-29 12:20:19 |
| localhost | root | mysql_native_password | 2023-03-29 12:21:19 |
+-----------+------------------+-----------------------+-----------------------+
5 rows in set (0.00 sec)