Raised This Month: $300 Target: $400
 75% 

SQL Connection Failed: [2059]: Authentication plugin 'caching_sha2_password' cannot b


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Kris Kristensen
Junior Member
Join Date: May 2020
Old 05-13-2020 , 08:03   SQL Connection Failed: [2059]: Authentication plugin 'caching_sha2_password' cannot b
Reply With Quote #1

SQL Connection Failed: [2059]: Authentication plugin 'caching_sha2_password' cannot be loaded: The specified module could not be found.

I guess this error is due to the new auth model in mysql 8.x

Is there a way to use the new mysql auth model in sourcemod, or do I have to revert back to native_password support (not recommended by the way)?

https://dev.mysql.com/doc/refman/8.0...ntication.html

Best
Kris

Last edited by Kris Kristensen; 05-13-2020 at 08:21.
Kris Kristensen is offline
asherkin
SourceMod Developer
Join Date: Aug 2009
Location: OnGameFrame()
Old 05-13-2020 , 08:21   Re: SQL Connection Failed: [2059]: Authentication plugin 'caching_sha2_password' cann
Reply With Quote #2

You need to use native_password, there are no plans to add caching_sha2_password support to SM's MySQL module currently.
__________________
asherkin is offline
Kris Kristensen
Junior Member
Join Date: May 2020
Old 05-13-2020 , 08:22   Re: SQL Connection Failed: [2059]: Authentication plugin 'caching_sha2_password' cann
Reply With Quote #3

ok thanks asherkin
Kris Kristensen is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 16:28.


Powered by vBulletin®
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Theme made by Freecode