EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)
-   -   Server mysql start up issue (https://www.eqemulator.org/forums/showthread.php?t=44391)

kaylar 08-18-2025 12:10 AM

Server mysql start up issue
 
Server type: MySQL
Server version: 8.4.6 - MySQL Community Server - GPL
Protocol version: 10

When I try to start the server I get this sql error

World | Error | Connect Connection [default] Failed to connect to database Error [#1045: Plugin caching_sha2_password could not be loaded: The specified module could not be found. Library path is 'caching_sha2_password.dll']

Is mysql version incompatible?

SELECT User, Host, authentication_string FROM mysql.user WHERE User = 'eqemu';

User char(32)
eqemu
Select_priv enum -- N Y
Insert_priv enum -- N Y
Update_priv enum -- N Y
Delete_priv enum -- N Y
Create_priv enum -- N Y
Drop_priv enum -- N Y
Reload_priv enum -- N Y
Shutdown_priv enum -- N Y
Process_priv enum -- N Y
File_priv enum -- N Y
Grant_priv enum -- N Y
References_priv enum -- N Y
Index_priv enum -- N Y
Alter_priv enum -- N Y
Show_db_priv enum -- N Y
Super_priv enum -- N Y
Create_tmp_table_priv enum -- N Y
Lock_tables_priv enum -- N Y
Execute_priv enum -- N Y
Repl_slave_priv enum -- N Y
Repl_client_priv enum -- N Y
Create_view_priv enum -- N Y
Show_view_priv enum -- N Y
Create_routine_priv enum -- N Y
Alter_routine_priv enum -- N Y
Create_user_priv enum -- N Y
Event_priv enum -- N Y
Trigger_priv enum -- N Y
Create_tablespace_priv enum -- N Y
ssl_type enum --
ssl_cipher blob
Binary - do not edit (0 B)
No file chosen (Max: 64KiB)
x509_issuer blob
Binary - do not edit (0 B)
No file chosen (Max: 64KiB)
x509_subject blob
Binary - do not edit (0 B)
No file chosen (Max: 64KiB)
max_questions int unsigned
0
max_updates int unsigned
0
max_connections int unsigned
0
max_user_connections int unsigned
0
plugin char(64)
caching_sha2_password

TonyO 08-20-2025 12:38 PM

I encountered this problem, too.
My SQL server is "Ver 8.0.43 for Win64 on x86_64 (MySQL Community Server - GPL)"

To work around this, I set the eqemu user to use mysql_native_password.
If I recall correctly, the command is
Code:

ALTER USER 'eqemu'@'%' IDENTIFIED WITH mysql_native_password BY 'YourPeqPassword';
flush privileges;

eqemu is the only user that needed the native password plugin. All other accounts use SHA2.


All times are GMT -4. The time now is 01:34 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.