PDA

View Full Version : Server mysql start up issue


kaylar
08-18-2025, 12:10 AM
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
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.