Xampp - MySql and Windows 10 error

[ionut2022p]

Hello,
I'm using Xampp control panel v3.3.0 with php 7.4.27 on my new fresh installed Windows10.
Sometimes is working ok, but in 80% cases, mysql don't work.
If i click on stop mysql i have error There may be an error, return code: and if i visit my localhost and open my website, is loading, i count last time 5minutes and i close browser.

I changed port in mysql from 3306 to 3307, i remove skype, nothing.
Ex: i'm working to my website in Joomla, is ok, i click on new page buffff .... i need to restart laptop one -2 times to work again.. but after time, the same.

I disabled firewall, nothing.

Do you have any ideea?
Windows 10 in new for 5days, no many programs, is i5with 6gb ram, only licence software installed.
i tried:
- change port for mysql
- removed skype
- firewall disabled
- delete ibtmp1 from data-mysql
- i also tried to delete all from data
- from task manager i put hight to priority

is an issue from xampp?

[Altrea]

Hi,

I changed port in mysql from 3306 to 3307, i remove skype, nothing.

Stop doing this. Skype has nothing to do with the MariaDB Port. Don't change the Port at all, this is not helpful.

i tried:
- change port for mysql
- removed skype
- firewall disabled
- delete ibtmp1 from data-mysql
- i also tried to delete all from data
- from task manager i put hight to priority

You are just trying random unrelated stuff.

First we need to identify the real issue. So the next time the problem occurs we need some information:

• full xampp control panel log window contents
• mysql_error.log contents

In some cases there is no helpful message in these logs to identify the issue.
So please try to start MariaDB as console application too.

Open the XAMPP Shell by clicking the Shell Button in your XAMPP control panel.
Execute the following command and tell us what what the full response is

Code: Select all

mysqld --defaults-file=mysql\bin\my.ini --standalone --console

[ionut2022p]

Hi,
Thanks,
Command i need to run in cmd or in xampp console?
Ps. I will put port back

[Altrea]

In the XAMPP Shell

[ionut2022p]

Thank you
https://prnt.sc/25sxmxr

https://prnt.sc/25sxkij

[Altrea]

I cannot see any Screenshots by these URLs.
Can you show them somewhere else?

[ionut2022p]

[Altrea]

The console application log can be ignored. This log is useless if MariaDB is already running. MariaDB seems to be started fine this time.
You still have running MariaDB on port 3307. Have you changed the port for MariaDB in the XAMPP control panel configs too?

[ionut2022p]

Yes but not working.

I saw that folder data from mysql is read only, so i unchecked and hope to be better.
Let you know

Thanks

[ionut2022p]

Apache is ok, no problem, only mysql
Click on Stop mysql


the same after few hours

[ionut2022p]

Here is log mysql but from 22:30 to 00:00 was ok
2022-01-03 22:30:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-01-03 22:30:54 0 [Note] InnoDB: Uses event mutexes
2022-01-03 22:30:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-01-03 22:30:54 0 [Note] InnoDB: Number of pools: 1
2022-01-03 22:30:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-01-03 22:30:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-01-03 22:30:54 0 [Note] InnoDB: Completed initialization of buffer pool
2022-01-03 22:30:54 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=98982008
2022-01-03 22:30:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-01-03 22:30:56 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-01-03 22:30:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-01-03 22:30:56 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-01-03 22:30:56 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-01-03 22:30:56 0 [Note] InnoDB: Waiting for purge to start
2022-01-03 22:30:56 0 [Note] InnoDB: 10.4.22 started; log sequence number 98982017; transaction id 36753
2022-01-03 22:30:56 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool
2022-01-03 22:30:56 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-01-03 22:30:56 0 [Note] Server socket created on IP: '::'.

[Altrea]

Now MariaDB is running on port 3306 again? I have no idea what you are doing...

[ionut2022p]

I put on 3306 port and was ok. no probem.
Nothing did just install on windows, on clean windows and was ok 1 2 days. nothing installed this time or any change.
If i restart laptop few times, then mysql is ok but if i start to work, in few minutes or 1 2 hours with luck, i can't stop mysql, as you can see.
I tried to change port because of that issue, but the same.

[ionut2022p]

Maybeis because of windows 10 or anti-virus?
I see data from mysql is only read check. I uncheck but after one second is check back.

[Altrea]

what do you mean it is read only? for which user?
i don't know. it can be anything. But you said this is anclean fresh installed windows machine.