ERROR SQLSTATE HY000 2002 No connection could be made because the target machine actively refused it

Question

I was debugging my code when a surprising error happened. There are a number of issues with the connection to the database.

ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it.
( ! ) Fatal error: Uncaught exception 'PDOException' with message ' in C:\wamp\www\web\main\users.php on line 15
( ! ) PDOException: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it. in C:\wamp\www\web\main\users.php on line 15

This is the code of where the error is pointing

function __construct()
        {
            $this->con = new PDO("mysql:host=".$this->host.";dbname=".$this->db,$this->user,$this->pass);
        }

Since I don't frequently experience issues like this, I haven't done any research on WAMP, thus I'm not sure what to do. I appreciate you helping me.

Answer 1

One of the services has not begun if the WAMP symbol is orange. Since you are receiving the notice that there is no server operating and thus listening for requests in your situation, it appears that MySQL has not started.

Check the MySQL log first, and if that doesn't reveal anything, check the Windows event log under Windows -> Applications. There are error messages that can help you figure out why MySQL won't start.

Sometimes this is brought on by WAMPServers MySQL picking up a my.ini file from another install, typically in the windows or windows system32 folders. Search for "my.ini" and "my.cnf" and, if you come across either of these files outside of the wamp folder hierarchy, delete or at the very least rename them so they can no longer be found. Restart the MySQL service after that.

I hope this helps you.

Get a further understanding from the SQL Certification Course