when I start apache MySQL server, I get error " (HY000/2002): No connection could be made because the target machine actively refused it."

Question

after the start apache server, i could not access PHPMyAdmin. when i try to access i get an error and auto-stop MySQL server.


 - mysqli_real_connect(): (HY000/2002): No connection could be made
   because the target machine actively refused it.
 - Connection for controluser as defined in your configuration failed.
   mysqli_real_connect(): (HY000/2002): No connection could be made
   because the target machine actively refused it.
 - phpMyAdmin tried to connect to the MySQL server, and the server
   rejected the connection..

how can i solve this error

Possible duplicate of [#2002 - No connection could be made because the target machine actively refused it](https://stackoverflow.com/questions/17707961/2002-no-connection-could-be-made-because-the-target-machine-actively-refused) — Areg, Oct 22 '19 at 07:21

score 0 · Accepted Answer · edited Jul 15 '20 at 07:36

0

Add below line under config.inc.php

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

edited Jul 15 '20 at 07:36

Tschallacka

27,901
14
88
133

answered Jul 15 '20 at 06:49

Priyesh Shukla

16
7

Can you explain this answer? What is this doing? What is the root problem that caused the user to be in this situation? – Eric Hepperle - CodeSlayer2010 Mar 30 '21 at 19:57

score 0 · Answer 2 · answered Dec 09 '22 at 06:39

0

If you are on Windows os and the above solution does not work, just check if your mysql is running with "netstat -ano" command, if the services are not running just try starting the mysql service.

answered Dec 09 '22 at 06:39

Saad

105
1
12

when I start apache MySQL server, I get error " (HY000/2002): No connection could be made because the target machine actively refused it."

2 Answers2