database is not working error #2002

8lbiasian

hello, i have some problem after i restart my pc

now its show me this error
when i open phpmyadmin or any web app
#2002 - No connection could be made because the target machine actively refused it. — The server is not responding (or the local server's socket is not correctly configured).

from cmder i got this

C:\Users\Eng Ahmed>mysql
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061 "Unknown error")

i try to reinstall laragon but still same issue. i dono if i move the files to another PC it will work or know, but i need to solve this issue.

waiting for your reply

Mocking Bird

@8lbiasian: How about reinstall Laragon to another location?

Mocking Bird

Or try this:

mysqld --tc-heuristic-recover=ROLLBACK

8lbiasian

@Mocking-Bird said in database is not working error #2002:

@8lbiasian: How about reinstall Laragon to another location?

actually i just install laragon in different PC and copy the data folder from there and replace it with current data folder then its work

@Mocking-Bird said in database is not working error #2002:

Or try this:

mysqld --tc-heuristic-recover=ROLLBACK

i will save this for next issue ^^ thanks for help

but exactly what is the reason of this error ?! and why happen

leokhoa

@8lbiasian :
Sometimes, MySQL is running in a transaction but users shutdown it suddenly.
The mysqld --tc-heuristic-recover=ROLLBACK will help rollback and recover MySQL.