MySql handle raised an exception in 'PlayerDatabase v1.6.2' plugin (MySqlException: Authentication method 'caching_sha2_password' not supported by any of the available plugins.)

Hi Bazim,
This is an issue on the database end and not related to the plugin, you will need to enable legacy authentication method to your MySQL database server configuration.

I recommend adding default_authentication_plugin = mysql_native_password to opendb

Alternatively, give me the project on github and I'll make a change.

This is not part of the plugin code, perhaps the Oxide MySQL connector itself. Check out the Oxide repo for that

I am having problems using this plugin. I setup a new MySQL server 8.0.28, added a user for my oxide servers, made sure authentication type was set to standard, mysql_native_password. Could I get some help with this, please.

Errors:

MySql handle raised an exception in 'PlayerDatabase v1.6.2' plugin (MySqlException: Authentication method 'caching_sha2_password' not supported by any of the available plugins.)
  at MySql.Data.MySqlClient.Authentication.AuthenticationPluginManager.GetPlugin (System.String method) [0x0001d] in <8d7380b3d3cf4bd8be324c584f371b44>:0                                                                     0b/s in, 0b/s out
  at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.GetPlugin (System.String method, MySql.Data.MySqlClient.NativeDriver driver, System.Byte[] authData) [0x0001f] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.NativeDriver.Authenticate (System.String authMethod, System.Boolean reset) [0x00029] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.NativeDriver.Open () [0x002c4] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.Driver.Open () [0x0000b] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x0004d] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.MySqlConnection.Open () [0x0016c] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x00059] in <7a75fa05cbc04391919cf072f240bf30>:0
MySql handle raised an exception in 'PlayerDatabase v1.6.2' plugin (MySqlException: Authentication method 'caching_sha2_password' not supported by any of the available plugins.)
  at MySql.Data.MySqlClient.Authentication.AuthenticationPluginManager.GetPlugin (System.String method) [0x0001d] in <8d7380b3d3cf4bd8be324c584f371b44>:0                                                                     0b/s in, 0b/s out
  at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.GetPlugin (System.String method, MySql.Data.MySqlClient.NativeDriver driver, System.Byte[] authData) [0x0001f] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.NativeDriver.Authenticate (System.String authMethod, System.Boolean reset) [0x00029] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.NativeDriver.Open () [0x002c4] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.Driver.Open () [0x0000b] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x0004d] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.MySqlConnection.Open () [0x0016c] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x00059] in <7a75fa05cbc04391919cf072f240bf30>:0
MySql handle raised an exception in 'PlayerDatabase v1.6.2' plugin (MySqlException: Authentication method 'caching_sha2_password' not supported by any of the available plugins.)
  at MySql.Data.MySqlClient.Authentication.AuthenticationPluginManager.GetPlugin (System.String method) [0x0001d] in <8d7380b3d3cf4bd8be324c584f371b44>:0                                                                     0b/s in, 0b/s out
  at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.GetPlugin (System.String method, MySql.Data.MySqlClient.NativeDriver driver, System.Byte[] authData) [0x0001f] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.NativeDriver.Authenticate (System.String authMethod, System.Boolean reset) [0x00029] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.NativeDriver.Open () [0x002c4] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.Driver.Open () [0x0000b] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x0004d] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.MySqlConnection.Open () [0x0016c] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x00059] in <7a75fa05cbc04391919cf072f240bf30>:0
Couldn't get columns. Database might be corrupted.
MySql handle raised an exception in 'PlayerDatabase v1.6.2' plugin (MySqlException: Authentication method 'caching_sha2_password' not supported by any of the available plugins.)
  at MySql.Data.MySqlClient.Authentication.AuthenticationPluginManager.GetPlugin (System.String method) [0x0001d] in <8d7380b3d3cf4bd8be324c584f371b44>:0                                                                     0b/s in, 0b/s out
  at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.GetPlugin (System.String method, MySql.Data.MySqlClient.NativeDriver driver, System.Byte[] authData) [0x0001f] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.NativeDriver.Authenticate (System.String authMethod, System.Boolean reset) [0x00029] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.NativeDriver.Open () [0x002c4] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.Driver.Open () [0x0000b] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x0004d] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at MySql.Data.MySqlClient.MySqlConnection.Open () [0x0016c] in <8d7380b3d3cf4bd8be324c584f371b44>:0
  at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x00059] in <7a75fa05cbc04391919cf072f240bf30>:0
Unloaded plugin Player Database v1.6.2 by Reneb / Maintained by FakeNinja​

The authentication method is set by the MySQL database side, not the plugin.

All of this, "I setup a new MySQL server 8.0.28, added a user for my oxide servers, made sure authentication type was set to standard, mysql_native_password." Was done on the mysql side, not the plugin side. And the plugin still says the authentication error, caching_sha2_password