you have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transaction

PROBLEM

Your mysql don't work saying smth like:

you have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transaction

or

No connection could be made because the target machine actively refused it.

You have probably shutdown pc when there were some mysql transactions or whatever it was doing.

SOLUTION

Go to mysql bin folder open cmd and type:

mysqld --tc-heuristic-recover=ROLLBACK

Don't forget to restart mysql after this command finished