CODEWITHSUNDEEP
mysqllaragon
mastewal tekile
mastewal tekile

Reputation: 9

mysqld: can not open shared library 'C:\laragon\bin\mysql\m...\component_reference_model.dll

I'm working on MySQL with Laragon and I get MySQL failed error suddenly this is the error log i have get from mysqld.log

2023-09-20T13:59:40.351257Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-09-20T13:59:40.351310Z 0 [System] [MY-010116] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld (mysqld 8.0.30) starting as process 4224
2023-09-20T13:59:40.396159Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-09-20T13:59:40.638227Z 1 [ERROR] [MY-013882] [InnoDB] Missing redo log file .\#innodb_redo\#ib_redo6 (with start_lsn = 19656704).
2023-09-20T13:59:40.639105Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-09-20T13:59:40.724721Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-09-20T13:59:40.729858Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-09-20T13:59:40.730488Z 0 [ERROR] [MY-010119] [Server] Aborting

error I get from Laragon

and my phpmyadmin says

mysqli::real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it

I have tried by reinstalling MySQL and laragon. Do you have any other solutions?

Upvotes: 0

Views: 1156

Answers (2)

Abdulaziz Hamdan
Abdulaziz Hamdan

Reputation: 373

Your issue is not with the mySQL itself, but with the way laragon's first initialization of MySQL on the first time.

I resolved mine by doing the following:

  1. Go to your Laragon Root -> Data
  2. You'll find a mysql-8 folder -> Rename it by adding "_backup"
  3. Back to Laragon -> Stop and Start All again, and you'll see a new folder mysql-8 is created by Laragon's MySQL service.
  4. Voila, you should be able to connect and access your Localhost DB.

Credit goes to Bang Irfan

Upvotes: 0

Abdul karim
Abdul karim

Reputation: 1

C:\laragon\data\mysql-8 just change mysqlld file it will solve the problem take it from any person or download full MySQL 100% working if you change the file just replace your old one

Upvotes: 0

Related Questions