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

Question

An error suddenly occurred while I was debugging my code   It has this series of errors regarding the connection to 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- gt con   new PDO  mysql host    this- gt host   dbname    this- gt db  this- gt user  this- gt pass               I don t know what to do since I do not usually get problems like this so I haven t studied much about WAMP   Thank You for your help

User · Answer

I had a similar issue when trying to migrate a Drupal website from one local host to another. From Mac running XAMMP to Windows running WAMP.

This was the error message I kept getting when trying to access the pages of the website.

PDOException: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it. 
in drupal_get_installed_schema_version() (line 155 of C:\wamp\www\chia\includes\install.inc).

In settings.php, I've changed everything correctly, database name, user and password.

$databases = array (
  'default' => 
  array (
    'default' => 
    array (
      'database' => 'mydatabasename',
      'username' => 'mydbusername',
      'password' => 'mydbpass',
      'host' => 'localhost',
      'port' => '8889',
      'driver' => 'mysql',
      'prefix' => '',
    ),
  ),
);

After a couple of hours of mindless google searching I've changed the port to a empty value:

'port' => '',

And after that the site loaded properly.

User · Answer

I ve had the same issue too  I didn t remember to start my WAMPSERVER  and so the connection couldn t be made    All you need to do is to start or restart your WAMPSERVER or your XAMMP again and it will work

User · Answer

I had the same problem  I just deleted all log files in mysql data files like    mysql-relay-bin - 2020 002d     Just these files and it worked  I hope this helps

User · Answer

if you are using XAMPP and WAMP together in the same machine add sql server port number   lt connection gt                   lt host gt  lt   CDATA localhost 3390   gt  lt  host gt                   lt username gt  lt   CDATA root   gt  lt  username gt                   lt password gt  lt   CDATA    gt  lt  password gt                   lt dbname gt  lt   CDATA sritoss 1910   gt  lt  dbname gt                   lt initStatements gt  lt   CDATA SET NAMES utf8   gt  lt  initStatements gt                   lt model gt  lt   CDATA mysql4   gt  lt  model gt                   lt type gt  lt   CDATA pdo mysql   gt  lt  type gt                   lt pdoType gt  lt   CDATA    gt  lt  pdoType gt                   lt active gt 1 lt  active gt   lt  connection gt

User · Answer

All you have to do it insert you exact db details and restart your mysql server

User · Answer

Delete the following files from the directory    wamp bin mysql mysql5 6 17 ib logfile0  wamp bin mysql mysql5 6 17 ib logfile1  wamp bin mysql mysql5 6 17 ibdata1   This solved my problem

User · Answer

Possibly using different Port for MySQL than using in your Code     conn   new PDO  mysql host   SERVER NAME   port 3307 dbname   DB NAME  DB USER  DB PASS     Both ports should be same

User · Answer

Just restart your wamp server and then run php bin magento cache clean

User · Answer

You should restart your Xampp or whatever server you re runnung  make sure sq

User · Answer

Restart your wampServer    that should solve it  and if it doesn t   Resta

User · Answer

dsn    gt   mysql host localhost port 3307 dbname yourdbname

User · Answer

Check whether MySQL server is running at all  If you not run apache server or any server you use  this could happen  After run your local server and refresh the page

User · Answer

Ensure your WAMP Server  or XAMP  is working  i e  the wamp icon should be green

User · Answer

If the WAMP icon is Orange then one of the services has not started    In your case it looks like MySQL has not started as you are getting the message that indicates there is no server running and therefore listening for requests    Look at the mysql log and if that tells you nothing look at the Windows event log  in the Windows - gt  Applications section  Error messages in there are pretty good at identifying the cause of MySQL failing to start   Sometimes this is caused by a my ini file from another install being picked up by WAMPServers MySQL  normally in the  windows or  windows system32 folders  Do a search for  my ini  and  my cnf  and if you find one of these anywhere outside of the  wamp     folder structure then delete it  or at least rename it so it wont be found  Then restart the MySQL service

User · Answer

I was getting this error attempting to run  php artisan migrate   on Windows with a virtual box   vagrant   homestead installation   The documentation said I had to run this command on the virtual machine   This worked     make sure to do it inside your current project folder

User · Answer

I had the same problem and I searched a lot in web but no solution worked for me  finally I noticed by chance that mysql is using port 3308 instead of port 3306 which seems to be default     I changed the port to 3306 and surprisingly it worked          my problem was in connecting php to mysql database  php my admin page was shown perfectly

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

Examples related to php

Examples related to mysql

Examples related to pdo

Examples related to wamp