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

Question

I'm trying to connect Android with PHP, MySQL, for that I'm referring this tutorial. I installed WAMP server successfully on my local machine and now I want login to phpmyadmin by entering "http://localhost/phpmyadmin" url in my browser but I'm getting following error-

#2002 - No connection could be made because the target machine actively refused it. — The server is not responding (or the local server's socket is not correctly configured).

For more information, please see the below screenshot-

One more thing I would like to mention here is, after starting Wamp server it shows the icon in Orange colour. I googled n tried almost all available solutions but unable to resolve my issue yet. The strange thing is yesterday it was working successfully but in today morning when I tried to login again I'm getting this error. Please help me to resolve this issue also let me know if I can provide more information for the same. Thank you.

Smells like your MySQL/MariaDB server isn't running. Kan you confirm it *is* running with task manager? — Daan Meijer, Jan 11 '17 at 07:39
@DaanMeijer I started WAMP server and it is running in task manager but showing icon in Orange colour (it should be green) — Dnyanesh M, Jan 11 '17 at 07:45
@DaanMeijer NO. Task Manager not showing MySQL Process running. — Dnyanesh M, Jan 11 '17 at 08:02
@DaanMeijer Can u plz help me how can I solve this problem.? — Dnyanesh M, Jan 11 '17 at 08:04
Sorry, not enough experience with WAMP. Can't help you with this one. — Daan Meijer, Jan 11 '17 at 08:22

score 3 · Answer 1 · answered Jan 11 '17 at 07:44

Case 1 :

One is mysql port not conflict with other application

Case 2 :

Second one is some mysql table We do not continue the crash recovery, because the table may become corrupt if we cannot apply the log records in the InnoDB log to it.

Case 1 : solution

You could go to wamp/bin/mysql/mysql5.x.x / There can find my.config file you can change below mention port number what we change like that. The following options will be passed to all MySQL clients

[client]
password = your_password
port = 3309
socket = /tmp/mysql.sock
and
The MySQL server
[wampmysqld]

As well as you could change php/bin/ folder Php.ini here you could change port number default one 3306 to 3309 like this port = 3309 socket = /tmp/mysql.sock

Case 2 Solution :

Wamp/bin/mysql/mysql5.x.xx/data Here can find the data folder in that your project name appeared open that project and then find the currepted (uses space ID: 43 at filepath: .\myschool\tbl_student.ibd

InnoDB: Error: could not open single-table tablespace file .\myschool\tbl_student.ibd) file then delete it . wamp\bin\mysql\mysql5.6.17\data\myschool here you find the table struce then delete currepted table structure like this extension tbl_student.ibd Logs file you can find wamp/logs folder here you can select MySQL then go down see what the error then you can resolve it .

Courtesy webTutorialsPoint.com and ApacheForum

score 1 · Answer 2 · answered Jan 11 '17 at 07:44

have you configure control panel of your server .. i had same problem then i found it was nothing wrong there

the problem was the other application was using the same port which control panel of my server was trying to access

hope you will find your error ..

good luck

score 0 · Answer 3 · answered Aug 30 '17 at 01:39

0

That's Because mysqld is not running Check it mysqld On \MySQL\bin

answered Aug 30 '17 at 01:39

Ham Za

1

score 0 · Answer 4 · answered Oct 21 '17 at 11:44

if you are using wamp go to ~\wamp\apps\phpmyadmin{version} and open config.inc.php then add $cfg['Servers'][$i]['port'] = '????' bellow $cfg['Servers'][$i]['connect_type'] = 'tcp' in /* Server parameters */ section.

replace ???? with your current port (3306 is default port so if you change the port, write it here)

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

4 Answers4