Jump to content
We've made dark mode the default preference to protect your eyes! You can change this at anytime below. ×
Search In
  • More options...
Find results that contain...
Find results in...
RobJ

SQL Auth Help

Pending 2.1.4

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

About Us

Codefling is a forward-thinking platform for developers to share and monetize their work from plugins to game assets and everything in-between.

2,128 files sold to 250 customers and $28,069 of payments processed this year!

×
×
  • 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.