database is not working error #2002


  • | 249 points

    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


  • | 356 points

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


  • | 356 points

    Or try this:

    mysqld --tc-heuristic-recover=ROLLBACK
    

  • | 249 points

    @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


  • administrators
    | 46947 points

    @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.


Log in to reply
 

Looks like your connection to Laragon was lost, please wait while we try to reconnect.