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

Question

When I was trying to connect my phpmyadmin on my XAMPP, it gave an error:

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

Can any help me to resolve it?

You can open your xampp with administrative right means Run as administrator and then start Apache after that run MySQL it works if you haven't any other issue.. — Sonpal singh Sengar, Jul 23 '21 at 17:01

score 21 · Answer 1 · answered Apr 17 '19 at 18:19

21

Okay, so i tried all of the answers and none of them worked. If you are using different port than 3306 for MySQL you need to specify it in config.inc.php.

So since i was using port 3308, my solution was adding the following line in config.inc.php:

$cfg['Servers'][$i]['port'] = 3308;

add it right bellow the user, password or extension lines.

answered Apr 17 '19 at 18:19

Celestial

913
1
9
17

1

Thanks alot man. You literally saved my time after wasting so much time. – heisenberg Mar 05 '20 at 13:19
Yes this is the answer . I ve been trying for days. Thanks mate! I really appreciate it. – Sina Cengiz May 14 '20 at 20:21

score 10 · Answer 2 · answered Aug 18 '18 at 13:00

10

Go to

C:\Users\YourUser\AppData\Local\Temp

Delete all the files.It will work.

answered Aug 18 '18 at 13:00

Mohammed Tahair Pasha

125
1
3

Worked for me. Have multiple installations of mysql, which must have caused the issue. – Dmitriy Kravchuk Jan 15 '19 at 04:47

score 8 · Answer 3 · answered Mar 18 '14 at 07:05

8

Go to :

xampp/phpmyadmin/config.inc.php

open the file config.inc.php Go to line no:31

$cfg['Servers'][$i]['controluser'] = 'pma';

Change the line to :

$cfg['Servers'][$i]['controluser'] = 'root';

Restart your system.

Reference

answered Mar 18 '14 at 07:05

Pradip Kharbuja

3,442
6
29
50

Thanks pradip which u have posted u r answer very helped me. – Nagaraju Kasa Mar 22 '17 at 05:51

score 7 · Answer 4 · answered Jul 19 '13 at 11:40

7

If your operating system is Windows 7:

go to control panel -> Administrative Tools -> Services
find mysql then right-click, click start

If your operating system is Linux (Ubuntu):

in terminal type this command: sudo /etc/init.d/mysql start

Good Luck

answered Jul 19 '13 at 11:40

abe

624
8
14

I get this error when I start mysql from services app. Windows could not start the mysql service on Local Computer. Error 1067: The process terminated unexpectedly. – Thompson Oct 24 '14 at 15:59

score 5 · Answer 5 · answered Jul 01 '18 at 05:23

5

Please go to c:\xampp\tmp folder and delete all the files. It works for me may help you.

answered Jul 01 '18 at 05:23

hamidreza samsami

409
5
4

score 3 · Answer 6 · edited May 05 '15 at 17:18

3

Please try changing connect_type in your config.inc.php from 'tcp' to 'http'. This file exists in the phpMyAdmin top level directory.

Existing line looks like this:

$cfg['Servers'][$i]['connect_type'] = 'tcp';

New line should be looking like this:

$cfg['Servers'][$i]['connect_type'] = 'http';

edited May 05 '15 at 17:18

Raceimaztion

9,494
4
26
41

answered Apr 28 '14 at 06:34

Gumption Technologies

49
1
5

Thanks u r answer has been used for me. – Nagaraju Kasa Mar 22 '17 at 05:50

andreas nilsson · Answer 7 · 2015-05-19T16:36:59.270

2

Assuming you're trying to connect to http://localhost/phpmyadmin.

From XAMPP control panel start both the Apache module and the MySQL module.

edited May 19 '15 at 16:36

answered May 12 '15 at 08:11

andreas nilsson

21
4

This worked for me, must be another issue for the OP – Oct 27 '15 at 21:06

score 2 · Answer 8 · edited Oct 24 '16 at 11:29

2

Instead of localhost, type this in your address bar localhost:<PORT> (e.g. localhost:88)

edited Oct 24 '16 at 11:29

Eugene Obrezkov

2,910
2
17
34

answered Oct 24 '16 at 09:10

akshay ahir

51
5

score 1 · Answer 9 · answered Jun 10 '15 at 15:39

1

Sometimes if you delete your temporary files in windows in

C:\Windows\Temp

and

C:\Users\YourUser\AppData\Local\Temp

it works.

answered Jun 10 '15 at 15:39

Natalie

186
1
1
9

Thanks. This worked for me. I have two installs of xampp (one with php 5.6 and the other 7.1) and the error was shown to me after changing from one phpmyadmin (xampp php 7.1) to the other (xampp php5). After clearing the %SystemRoot%\Temp folder, all were good again. – Cubakos Mar 17 '18 at 17:06

score 0 · Answer 10 · answered Dec 14 '20 at 14:29

Check if your MySql service is running or not.

You can check it by searching Services in Start and then check the status of mysql80 service. If your service is not running then start service by right clicking on it and then Start.

Or you can use CMD.

Open Command Prompt as administrator and then run net start mysql80.

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

10 Answers10

Linked

Related