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