Question posted in 
I had installed MAMP on my windows 10 machine. I had then configured the MySQL thru the phpMyAdmin and had installed the WordPress. Later due to certain issues, I had to un-install and re-install the MAMP again. This time Apache started running and I could reach localhost/MAMP/, but when I click on phpMyAdmin, I get the message:
“mysqli_real_connect(): (HY000/2002) No connection could be made
because the target machine actively refused it
…..You should check the host, user name and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server”. I ran the command> MySQL -u root -p status. It asked for a password. On giving the password, I got the following: Error 2003 (HY000) Can't connect to MySQL server on localhost (10061).
Please help with a workaround.
3
Answers
The error was resolved thru re-installation and taking care to disable the installation of MAMP Pro which happens by default.
I usually see the “actively refused” error when I try to connect to a port that the MySQL server is not actually running on. That said, I don’t know why this would happen out of the blue. Maybe you should be using WAMP instead of MAMP?
You could probably troubleshoot this issue remotely with third party tools that have debug logging (MySQLShell through its Application Log)
Check all your Microsoft Redistribute Packages are installed correctly. If the problem exist then use the XAMPP or WAMP for the Windows because MAMP is generally used for the MAC OS.