[Enhancement]: mysql.user表plugin字段默认是ob_native_password，不兼容现有的MySQL工具 || [Enhancement]: The default value of mysql.user table plugin field is ob_native_password, which is not compatible with existing MySQL tools.

Enhancement

OB Verson： 4.3.2.1

mysql.user表的plugin字段，默认是ob_native_password，
哪怕create user时指定 plugin 为mysql_native_password, 依然展示为ob_native_password

这导致有些工具识别不出这个plugin而报错。比如maxscale
mysql库存在的意义就是兼容，建议默认展示为 mysql_native_password

CREATE USER test1 IDENTIFIED WITH mysql_native_password BY 'abc';

SELECT USER, PLUGIN FROM mysql.user WHERE USER='test1';
user plugin

test1 ob_native_password

Enhancement

OB Verson: 4.3.2.1

The plugin field of the mysql.user table defaults to ob_native_password.
Even if the plugin is specified as mysql_native_password when creating user, it is still displayed as ob_native_password.

This causes some tools to fail to recognize the plugin and report an error. For example maxscale
The meaning of mysql library is compatibility. It is recommended to display it as mysql_native_password by default.

CREATE USER test1 IDENTIFIED WITH mysql_native_password BY 'abc';

SELECT USER, PLUGIN FROM mysql.user WHERE USER='test1';
user plugin

test1 ob_native_password

Begin by reproducing the CREATE USER and SELECT USER, PLUGIN statements on OceanBase 4.3.2.1, then trace how the mysql.user plugin value is produced. Check the result against the requested mysql_native_password display and verify that existing MySQL tools such as MaxScale recognize it.