Problem with Xampp and MYSQL

IG Growth

BANNED - Account Sold by Owner
Joined
Jul 2, 2019
Messages
416
Reaction score
304
I would like help on this as I have searched the internet and so far I have not found a solution.

Xampp starts normally, I installed Wordpress locally to make a website for a client. I start apache and MYSQL and it works fine for a while but then all of a sudden it stops loading things and I am almost sure it is MYSQL as it won't let me enter Phpmyadmin when this happens and I have to close and reopen Xampp several times so that work again.

When this happens the browser keeps loading saying "Waiting for available connector" and never finishes loading

mysql_error.log
Code:
2020-09-19 11:43:03 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-09-19 11:43:03 0 [Note] InnoDB: Uses event mutexes
2020-09-19 11:43:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-09-19 11:43:03 0 [Note] InnoDB: Number of pools: 1
2020-09-19 11:43:03 0 [Note] InnoDB: Using generic crc32 instructions
2020-09-19 11:43:03 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-09-19 11:43:03 0 [Note] InnoDB: Completed initialization of buffer pool
2020-09-19 11:43:04 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=9195714
2020-09-19 11:43:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-09-19 11:43:05 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-09-19 11:43:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-09-19 11:43:05 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-09-19 11:43:05 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-09-19 11:43:05 0 [Note] InnoDB: Waiting for purge to start
2020-09-19 11:43:05 0 [Note] InnoDB: 10.4.14 started; log sequence number 9195723; transaction id 12813
2020-09-19 11:43:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-09-19 11:43:05 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-09-19 11:43:06 0 [Note] Server socket created on IP: '::'.
2020-09-19 11:43:11 0 [Note] Reading of all Master_info entries succeeded
2020-09-19 11:43:11 0 [Note] Added new Master_info '' to hash table
2020-09-19 11:43:11 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.4.14-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
2020-09-19 11:43:11 0 [Note] InnoDB: Buffer pool(s) load completed at 200919 11:43:11

error.log in Apache
Code:
[Sat Sep 19 11:11:09.068235 2020] [mpm_winnt:crit] [pid 2740:tid 264] AH02538: Child: Parent process exited abruptly. Child process is ending
[Sat Sep 19 11:42:58.246434 2020] [ssl:warn] [pid 5484:tid 252] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sat Sep 19 11:42:58.472447 2020] [core:warn] [pid 5484:tid 252] AH00098: pid file C:/xampp/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Sat Sep 19 11:42:58.475447 2020] [ssl:warn] [pid 5484:tid 252] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sat Sep 19 11:42:59.640514 2020] [mpm_winnt:notice] [pid 5484:tid 252] AH00455: Apache/2.4.46 (Win64) OpenSSL/1.1.1g PHP/7.4.10 configured -- resuming normal operations
[Sat Sep 19 11:42:59.641514 2020] [mpm_winnt:notice] [pid 5484:tid 252] AH00456: Apache Lounge VC15 Server built: Aug  4 2020 11:50:23
[Sat Sep 19 11:42:59.641514 2020] [core:notice] [pid 5484:tid 252] AH00094: Command line: 'c:\\xampp\\apache\\bin\\httpd.exe -d C:/xampp/apache'
[Sat Sep 19 11:42:59.643514 2020] [mpm_winnt:notice] [pid 5484:tid 252] AH00418: Parent: Created child process 13232
[Sat Sep 19 11:43:00.233547 2020] [ssl:warn] [pid 13232:tid 264] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sat Sep 19 11:43:00.370555 2020] [ssl:warn] [pid 13232:tid 264] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sat Sep 19 11:43:00.564566 2020] [mpm_winnt:notice] [pid 13232:tid 264] AH00354: Child: Starting 150 worker threads.

Any idea what it could do? Thank you very much!
 
Offtopic, but why don't you try using WSL instead of Xampp/wamp (if you are on Win 10 that is)? It's native to Win 10, so it is much faster. It is also dead accurate in terms of compatibility, if you are going to host in a linux server.

On topic, double check if you have the correct .net framework if required, and your mysql port(3306)/Apache (port 80. Skype is famous for using it) is not being used by another program.
 
Offtopic, but why don't you try using WSL instead of Xampp/wamp (if you are on Win 10 that is)? It's native to Win 10, so it is much faster. It is also dead accurate in terms of compatibility, if you are going to host in a linux server.

On topic, double check if you have the correct .net framework if required, and your mysql port(3306)/Apache (port 80. Skype is famous for using it) is not being used by another program.
Thank you very much for the answer man, I have Windows 7 installed and so far I have not tried Wamp Server. I didn't have any Net Framework installed on my PC so I downloaded the latest version.

I see that there is a little interference with an Apache port and a system process called "System" although I really don't know if this is normal.

I can say that I have NordVPN installed, it is closed but it always keeps its process open, I do not know if that could be what causes the MYSQL connection intermittence problem
 
Thank you very much for the answer man, I have Windows 7 installed and so far I have not tried Wamp Server. I didn't have any Net Framework installed on my PC so I downloaded the latest version.

I see that there is a little interference with an Apache port and a system process called "System" although I really don't know if this is normal.

I can say that I have NordVPN installed, it is closed but it always keeps its process open, I do not know if that could be what causes the MYSQL connection intermittence problem
Hmm try this thread
Code:
https://stackoverflow.com/questions/21279442/xampp-mysql-not-starting-attempting-to-start-mysql-service/41664326
Does your Apache run fine?

As for NordVPN, it probably adds a tap adapter for connection. That's probably why it is there in the process list. I may be wrong. Also, it shouldn't really have a problem with mysql.
 
Hmm try this thread
Code:
https://stackoverflow.com/questions/21279442/xampp-mysql-not-starting-attempting-to-start-mysql-service/41664326
Does your Apache run fine?

As for NordVPN, it probably adds a tap adapter for connection. That's probably why it is there in the process list. I may be wrong. Also, it shouldn't really have a problem with mysql.
Thank you very much for the help man!, I think the problem has been solved since it has not failed since I installed Net Framework. I have checked the netstat and the system process of port 443 disappeared
 
I think using a ready-made script/panel will always make the things easier for you,
try aaPanel, VestaPanel or any other free alternative, I was facing many problems when doing things manually
 
Back
Top