Support MySQL 8.4

[exileed]

trafficstars

I've changed the method for resetting the root user password in MySQL 8+ since mysql_native_password is no longer enabled by default. Link https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html

Now, versions of MySQL 8.* are correctly identified.

[tmace85]

Hi Guys,

thanks for your awsome work. i would appreciate if this got released in near future :) I´ve successully tested with mysql 8.4 and ubuntu 24.04.

Let me know if i can assist.

Cheers Tim

[GitHanter]

We also need to add mysql_native_password=ON config for version 8.4, if this config missing, when you grant privilege "*.*:ALL", you will encounter Plugin 'mysql_native_password' is not loaded error But maybe we need other workaround, because this will be removed in version 9