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->con = new PDO("mysql:host=".$this->host.";dbname=".$this->db,$this->user,$this->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.

sorry i don't know what is that. where can i locate that sir? — user3406220
– user3406220, Commented Mar 20, 2014 at 4:08
Either there's no MySQL server running on the host, or the port is being blocked by a firewall. Either way, this isn't a problem with your program, it's something the server administrator needs to fix. — Barmar
– Barmar, Commented Mar 20, 2014 at 4:09
If you're running this on your local machine try rebooting. MySQL is refusing your connection attempts exactly as the error messages are saying. — JBES
– JBES, Commented Mar 20, 2014 at 4:12

RiggsFolly · Accepted Answer · 2016-12-04 14:46:56Z

56

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

edited Dec 4, 2016 at 14:46

answered Mar 20, 2014 at 9:10

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mickmackusa · Accepted Answer · 2018-01-03 00:27:45Z

18

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.

edited Jan 3, 2018 at 0:27

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

answered Jan 2, 2018 at 23:22

ntthushara

3713 silver badges5 bronze badges

Comments

igorM · Accepted Answer · 2015-05-28 17:41:43Z

12

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.

answered May 28, 2015 at 17:41

igorM

1561 gold badge2 silver badges6 bronze badges

2 Comments

KillABug Over a year ago

Yes 8889 would be a MAC specific port no for Mysql(or configured to that),under wamp its generally 3306.

user3707264 Over a year ago

Exactly you need to use port 3306 on Windows, I had the same error when copying my .env file from production to the local machine.

qazisajjadakbar · Accepted Answer · 2021-01-21 10:31:12Z

2

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.

answered Jan 21, 2021 at 10:31

qazisajjadakbar

2752 silver badges3 bronze badges

Comments

David Saint · Accepted Answer · 2017-01-20 12:15:12Z

1

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

answered Jan 20, 2017 at 12:15

David Saint

295 bronze badges

Comments

Ngugi Kiarie · Accepted Answer · 2020-11-12 06:43:01Z

1

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

answered Nov 12, 2020 at 6:43

Ngugi Kiarie

1,45613 silver badges9 bronze badges

Comments

Nithiyakumar K · Accepted Answer · 2017-03-18 12:43:12Z

0

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.

edited Mar 18, 2017 at 12:43

answered Jun 9, 2016 at 10:48

Nithiyakumar K

283 silver badges12 bronze badges

1 Comment

RiggsFolly Over a year ago

Thats a good way to destroy all your INNODB databases. So dont do this unless you understand that

israelnojr · Accepted Answer · 2019-04-08 06:19:39Z

0

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

answered Apr 8, 2019 at 6:19

israelnojr

1

1 Comment

ZF007 Over a year ago

(runnung = running). Your answer is incomplete. (what to do with sq?) Please update. Keep in mind this answer is already given and question itself is 5 years old. OP might have moved on.

Sunny Ojo · Accepted Answer · 2019-12-27 11:00:35Z

0

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

answered Dec 27, 2019 at 11:00

Sunny Ojo

12 bronze badges

Comments

Oluwatobiloba · Accepted Answer · 2020-04-02 05:01:26Z

0

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

answered Apr 2, 2020 at 5:01

Oluwatobiloba

1221 silver badge7 bronze badges

Comments

Raj · Accepted Answer · 2020-05-20 14:13:27Z

0

if you are using XAMPP and WAMP together in the same machine add sql server port number

<connection>
                <host><![CDATA[localhost:3390]]></host>
                <username><![CDATA[root]]></username>
                <password><![CDATA[]]></password>
                <dbname><![CDATA[sritoss_1910]]></dbname>
                <initStatements><![CDATA[SET NAMES utf8]]></initStatements>
                <model><![CDATA[mysql4]]></model>
                <type><![CDATA[pdo_mysql]]></type>
                <pdoType><![CDATA[]]></pdoType>
                <active>1</active>
</connection>

answered May 20, 2020 at 14:13

Raj

111 bronze badge

Comments

groenhen · Accepted Answer · 2020-06-10 05:01:49Z

0

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.

edited Jun 10, 2020 at 5:01

groenhen

3,02725 gold badges51 silver badges69 bronze badges

answered Jun 9, 2020 at 19:50

Marin

92 bronze badges

Comments

bonCodigo · Accepted Answer · 2023-05-04 08:36:06Z

0

I had the same problem. 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, but php my admin page was shown perfectly.

Note : if you are using laravel then clear the cache and restart server.

edited May 4, 2023 at 8:36

bonCodigo

14.4k1 gold badge52 silver badges93 bronze badges

answered Aug 3, 2019 at 21:31

user11879072

11

Comments

Muhammad Ahmed · Accepted Answer · 2019-01-21 09:49:10Z

-1

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

answered Jan 21, 2019 at 9:49

Muhammad Ahmed

2251 gold badge4 silver badges12 bronze badges

Comments

educatdrisk · Accepted Answer · 2017-05-23 07:14:29Z

-2

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.

answered May 23, 2017 at 7:14

educatdrisk

571 silver badge4 bronze badges

1 Comment

Michal Boska Over a year ago

That's too specific answer, the question does not even imply the OP is using any kind of virtual machine, the problem why the php app cannot connect to mysql could be a totally different one

Dharman · Accepted Answer · 2025-02-11 15:11:43Z

-3

You have to specify your server port number because if you install multiple XAMPP in your PC then your port number will be different that's why default port number 3306 is not found and it's getting an error. For this, you have to specify your server port number.

'dsn' => 'mysql:host=localhost;port=3307;dbname=yourdbname',

edited Feb 11 at 15:11

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Sep 16, 2020 at 12:34

Mohammed Abir

4314 silver badges6 bronze badges

1 Comment

Nico Haase Jan 30 at 8:25

"you have to specify your server port no" - why? Which part of the error message makes you think that "default port no 3306 is not finding"?

Collectives™ on Stack Overflow

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

16 Answers 16

Comments

Comments

2 Comments

Comments

Comments

Comments

1 Comment

1 Comment

Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

16 Answers 16

Comments

Comments

2 Comments

Comments

Comments

Comments

1 Comment

1 Comment

Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

1 Comment

Linked

Related