how to have an woking theforgottenserver 1.2 due to a prob of mysql and sha2?

[epsilon2]

i am using a win 11 development environment with uniserverz.

a fresh install gives me an error when starting theforgotten server:

MySQL Error Message: Plugin caching_sha2_password could not be loaded: Das angegebene Modul wurde nicht gefunden. Library path is 'caching_sha2_password.dll'

i can change on latest uniserverz mysql due to

ALTER USER 'yourusername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'youpassword';

than forgottenserver is working but phpmyadmin not.

i need both programs working as development engine. any idea?

Post automatically merged: Dec 27, 2023

solved

i used

ALTER USER 'yourusername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'youpassword';

with

C:\Program Files\MySQL\MySQL Server 8.0\bin> mysql -u root -p
Enter password: *********

and a own user for the theforgottenserver database with mysql_native_password

 

[Tampek]

Can you explain me where i do that :

C:\Program Files\MySQL\MySQL Server 8.0\bin> mysql -u root -p
Enter password: *********

 

[PuszekLDZ]

Can you explain me where i do that :

C:\Program Files\MySQL\MySQL Server 8.0\bin> mysql -u root -p
Enter password: *********

i think its from console...

like prompt for CMD " c: "

there is

C:\Program Files\MySQL\MySQL Server 8.0\bin>

and he write command

mysql -u root -p

 

[King Yoshi]

Has anyone actually explained how to fix this? where to go, what to change. None of the above worked for me. Chasing this issue for weeks now.

 

[Allynn]

Has anyone actually explained how to fix this? where to go, what to change. None of the above worked for me. Chasing this issue for weeks now.

If you are, testing things, on your computer, offline, just use Xampp.
Patience for weeks, is very and too much consuming, use programs, systems, which are tested and worked ; )

 

[King Yoshi]

If you are, testing things, on your computer, offline, just use Xampp.
Patience for weeks, is very and too much consuming, use programs, systems, which are tested and worked ; )

I am trying to get the server to open, wont open for offline testing nor online, so me and my buddy can test together. I am not seeing anything to get past this issue, in my previous ot's long ago, i have never had this issue occur

 

[Allynn]

I am trying to get the server to open, wont open for offline testing nor online, so me and my buddy can test together. I am not seeing anything to get past this issue, in my previous ot's long ago, i have never had this issue occur

Go to my profil, and let's meet on discord.