Jump to content

SQL Auth Help

Pending 2.1.4

RobJ

Hello I just get this 

[PlayerRanks] Authentication method 'caching_sha2_password' not supported by any of the available plugins.

Share this comment


Link to comment

I just solved this for my situation. Because I upgraded my linux mint 19.3 to 20, it also upgrades my mysql 5.7 to 8.xx, thus changing the default authentication method to  'caching_sha2_password' from  'mysql_native_password'. 

 

To fix this I added the line under the [mysqld] section of mysqld.cnf :

default-authentication-plugin=mysql_native_password

IDK what it is for windows machines but I believe adding it to the my.cnf also works for both. 

Basically it's whatever file it runs that has the [mysqld] section.

So the higher security databases can still use the newer  'caching_sha2_password' method while lower security like ranks data stuff can still login.

 

Edited by Snivel

Share this comment


Link to comment
1.1m

Downloads

Total number of downloads.

5.4k

Customers

Total customers served.

77.7k

Files Sold

Total number of files sold.

1.5m

Payments Processed

Total payments processed.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.