0
I worked with wamp server for over a month and every thing was great.
Recently I had some chinese viruses that made me take some actions including deleting them from the registry. When I tried to connect to my wamp server, It turned green, and after I tried to login to the phpMyAdmin, I got an error -
mysqli_real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it.
This is my Apache error log:
[Thu Nov 24 14:06:25.908515 2016] [auth_digest:notice] [pid 2464:tid 576] AH01757: generating secret for digest authentication ...
[Thu Nov 24 14:06:25.971016 2016] [mpm_winnt:notice] [pid 2464:tid 576] AH00455: Apache/2.4.23 (Win64) PHP/5.6.25 configured -- resuming normal operations
[Thu Nov 24 14:06:25.971016 2016] [mpm_winnt:notice] [pid 2464:tid 576] AH00456: Apache Lounge VC14 Server built: Jul 1 2016 11:43:51
[Thu Nov 24 14:06:25.971016 2016] [core:notice] [pid 2464:tid 576] AH00094: Command line: 'c:\\wamp64\\bin\\apache\\apache2.4.23\\bin\\httpd.exe -d C:/wamp64/bin/apache/apache2.4.23'
[Thu Nov 24 14:06:26.002265 2016] [mpm_winnt:notice] [pid 2464:tid 576] AH00418: Parent: Created child process 6844
[Thu Nov 24 14:06:27.002269 2016] [auth_digest:notice] [pid 6844:tid 464] AH01757: generating secret for digest authentication ...
[Thu Nov 24 14:06:27.049144 2016] [mpm_winnt:notice] [pid 6844:tid 464] AH00354: Child: Starting 64 worker threads.
[Thu Nov 24 14:14:09.243534 2016] [mpm_winnt:notice] [pid 2464:tid 576] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[Thu Nov 24 14:14:11.255647 2016] [mpm_winnt:notice] [pid 6844:tid 464] AH00364: Child: All worker threads have exited.
[Thu Nov 24 14:14:11.291651 2016] [mpm_winnt:notice] [pid 2464:tid 576] AH00430: Parent: Child process 6844 exited successfully.
[Thu Nov 24 14:14:12.192703 2016] [auth_digest:notice] [pid 3084:tid 580] AH01757: generating secret for digest authentication ...
[Thu Nov 24 14:14:12.239706 2016] [mpm_winnt:notice] [pid 3084:tid 580] AH00455: Apache/2.4.23 (Win64) PHP/5.6.25 configured -- resuming normal operations
[Thu Nov 24 14:14:12.239706 2016] [mpm_winnt:notice] [pid 3084:tid 580] AH00456: Apache Lounge VC14 Server built: Jul 1 2016 11:43:51
[Thu Nov 24 14:14:12.239706 2016] [core:notice] [pid 3084:tid 580] AH00094: Command line: 'c:\\wamp64\\bin\\apache\\apache2.4.23\\bin\\httpd.exe -d C:/wamp64/bin/apache/apache2.4.23'
[Thu Nov 24 14:14:12.242706 2016] [mpm_winnt:notice] [pid 3084:tid 580] AH00418: Parent: Created child process 6848
[Thu Nov 24 14:14:12.950746 2016] [auth_digest:notice] [pid 6848:tid 408] AH01757: generating secret for digest authentication ...
[Thu Nov 24 14:14:12.992750 2016] [mpm_winnt:notice] [pid 6848:tid 408] AH00354: Child: Starting 64 worker threads.
php error log
[24-Nov-2016 12:06:24 UTC] No error - Only to create the file
[24-Nov-2016 12:08:05 UTC] PHP Warning: mysqli_connect(): (HY000/2002): No connection could be made because the target machine actively refused it.
in C:\wamp64\www\dbconnect.php on line 7
[24-Nov-2016 12:08:05 UTC] PHP Stack trace:
[24-Nov-2016 12:08:05 UTC] PHP 1. {main}() C:\wamp64\www\index.php:0
[24-Nov-2016 12:08:05 UTC] PHP 2. include() C:\wamp64\www\index.php:3
[24-Nov-2016 12:08:05 UTC] PHP 3. include() C:\wamp64\www\home.php:8
[24-Nov-2016 12:08:05 UTC] PHP 4. mysqli_connect() C:\wamp64\www\dbconnect.php:7
[24-Nov-2016 12:18:30 UTC] PHP Warning: mysqli_connect(): (HY000/2002): No connection could be made because the target machine actively refused it.
in C:\wamp64\www\dbconnect.php on line 7
[24-Nov-2016 12:18:30 UTC] PHP Stack trace:
[24-Nov-2016 12:18:30 UTC] PHP 1. {main}() C:\wamp64\www\branch.php:0
[24-Nov-2016 12:18:30 UTC] PHP 2. include_once() C:\wamp64\www\branch.php:3
[24-Nov-2016 12:18:30 UTC] PHP 3. include() C:\wamp64\www\home.php:8
[24-Nov-2016 12:18:30 UTC] PHP 4. mysqli_connect() C:\wamp64\www\dbconnect.php:7
What can I do?
I tried to reinstall my wamp server.
Thanks!
Your Apache log doesn't really have anything useful. Look a at the PHP error log and it's likely that the database (MySQL) is either not running or not accepting the connection. So have a look at those logs as well. – Seth – 2016-11-24T12:55:42.870
is it ok now..? – Jolie Anton – 2016-11-24T13:02:11.510
You can see that the error is triggered from
dbconnect.php
. Did you check whenever MySQL is up and running? Are you able to use a direct connection tool like the MySQL Workbench or themysql
command line interface to connect to the database? – Seth – 2016-11-24T13:04:01.203