
Xampp Warning: mysqli_connect(): (HY000/2002): No connection
- or -
Post a project like this£20(approx. $27)
- Posted:
- Proposals: 8
- Remote
- #3516833
- Expired
Customer Support/ Application Developer / Translation Services / Technical Troubleshooting (Apps, Windows and Mac)
Versatile Senior Technology Consultant | 10+ Years of Expertise in Web & Mobile Development | Proficient in Salesforce,PHP, AWS, Azure, NodeJs, ReactJs,React-Native, Flutter
6871952534740651377615373556678990132952064792336860134





Description
Experience Level: Entry
I was running a php page which was extracting information from different tables and adding rows to a new table (120,000 rows). The page stopped running and changed to a sql error message. I cannot remember exactly what it was, but something about Windows and usually there should be no more than one connection to the server database. After refreshing the page, it worked again for approx. 1 minute and then the same error. I stopped apache and sql. And now I get the following error when trying to access localhost.
Warning: mysqli_connect(): (HY000/2002): No connection could be made because the target machine actively refused it in C:\xampp\htdocs\csni\login\functions\db.php on line 3
Warning: mysqli::__construct(): (HY000/2002): No connection could be made because the target machine actively refused it in C:\xampp\htdocs\csni\includes\database_config.php on line 8
Connection failed: No connection could be made because the target machine actively refused it
MySQL errorlog:
2022-02-16 11:59:10 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-16 11:59:10 0 [Note] InnoDB: Uses event mutexes
2022-02-16 11:59:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-16 11:59:10 0 [Note] InnoDB: Number of pools: 1
2022-02-16 11:59:10 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-16 11:59:10 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-02-16 11:59:10 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-16 11:59:10 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=12963438225
2022-02-16 11:59:10 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-16 11:59:10 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-02-16 11:59:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-16 11:59:10 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-16 11:59:10 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-02-16 11:59:10 0 [Note] InnoDB: Waiting for purge to start
2022-02-16 11:59:10 0 [Note] InnoDB: 10.4.19 started; log sequence number 12963438234; transaction id 1699199
2022-02-16 11:59:10 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-02-16 11:59:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-16 11:59:10 0 [Note] Server socket created on IP: '::'.
Warning: mysqli_connect(): (HY000/2002): No connection could be made because the target machine actively refused it in C:\xampp\htdocs\csni\login\functions\db.php on line 3
Warning: mysqli::__construct(): (HY000/2002): No connection could be made because the target machine actively refused it in C:\xampp\htdocs\csni\includes\database_config.php on line 8
Connection failed: No connection could be made because the target machine actively refused it
MySQL errorlog:
2022-02-16 11:59:10 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-16 11:59:10 0 [Note] InnoDB: Uses event mutexes
2022-02-16 11:59:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-16 11:59:10 0 [Note] InnoDB: Number of pools: 1
2022-02-16 11:59:10 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-16 11:59:10 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-02-16 11:59:10 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-16 11:59:10 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=12963438225
2022-02-16 11:59:10 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-16 11:59:10 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-02-16 11:59:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-16 11:59:10 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-16 11:59:10 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-02-16 11:59:10 0 [Note] InnoDB: Waiting for purge to start
2022-02-16 11:59:10 0 [Note] InnoDB: 10.4.19 started; log sequence number 12963438234; transaction id 1699199
2022-02-16 11:59:10 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-02-16 11:59:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-16 11:59:10 0 [Note] Server socket created on IP: '::'.

Adrian M.
99% (36)Projects Completed
29
Freelancers worked with
28
Projects awarded
30%
Last project
22 Apr 2025
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
My first question here. You can connect to the dtatabase and an look via phpmyadmin like interface. From here only I can debug the real cause of problem. Using some sql queries. If it is db problem like data corruption.
There is very least posibility - some firewall blocking or some port conflict due to php , some update which changed security policy.
So first plz answer to my query above then only I will be able to bid -
Hi Adrian,
I believe its caused by security settings, are you sure its a xampp or mysql error ?
10128201012722
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies