Ajutor XAMPP - Mysql - Mutexes and rw_locks use Windows interlocked functions

[Sebastian]

Salut.

De cateva zile, lucrez la un website folosind xampp pe pc-ul meu.
Azi am pornit pc-ul, xampp, ii dau drumul la apache totul ok, incerc sa ii dau drumul la mysql si imi da eroarea atasata mai jos, am atasat si eroare din mysql error log.

Ce am incercat deja sa fac, sa dezactivez antivirus, firewall, sa schimb portul la mysql dar fara succes.
Pe internet am cautat, la fel si pe youtube. Sunt rezolvari dar nu fara sa pierzi datele.
As aprecia daca stie cineva o solutie la problema asta. Multumesc.

19:20:52  [mysql]     Error: MySQL shutdown unexpectedly.
19:20:52  [mysql]     This may be due to a blocked port, missing dependencies,
19:20:52  [mysql]     improper privileges, a crash, or a shutdown by another method.
19:20:52  [mysql]     Press the Logs button to view error logs and check
19:20:52  [mysql]     the Windows Event Viewer for more clues
19:20:52  [mysql]     If you need more help, copy and post this
19:20:52  [mysql]     entire log window on the forums

InnoDB: using atomic writes.
2021-01-10 19:20:51 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-10 19:20:51 0 [Note] InnoDB: Uses event mutexes
2021-01-10 19:20:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-10 19:20:51 0 [Note] InnoDB: Number of pools: 1
2021-01-10 19:20:51 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-10 19:20:51 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-10 19:20:51 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-10 19:20:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-10 19:20:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-10 19:20:51 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-10 19:20:51 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-10 19:20:51 0 [Note] InnoDB: Waiting for purge to start
2021-01-10 19:20:51 0 [Note] InnoDB: 10.4.14 started; log sequence number 237419667; transaction id 148362
2021-01-10 19:20:51 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-10 19:20:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-10 19:20:51 0 [Note] Server socket created on IP: '::'.

 

[AlexH]

Ai incercat sa adaugi codul de mai jos in /etc/my.cnf sau my.ini . Schimba valoarea 256 cu cea care vrei tu.
[mysqld]
max_allowed_packet=2568M
Da click pe config la mysql si cauta 3306 si schimba cu 3308 .
In control panel la Xampp la Service and Port setting cauta mysql si schimba portul cu 3308 .
Inchide tot acum.
Deschide cmd cu drept de administrator si ruleaza
sc delete mysql
Acum deschide Xampp si ar trebui sa functioneze.

 

[Sebastian]

Mersi de raspuns. Am incercat si cele scrise de tine insa nu mi-au fost de ajutor.
Am gasit solutia care este asa:
Trebuia sa copiez acest cod "skip-grant-tables" in mysql/bin/my.ini sub [mysqld] .

Acest cod a functionat fara ca eu sa mai modific portul. Modificarea portului nu m-a ajutat pentru ca portul 3306 nu era ocupat de nici o alta aplicatie. Nu pot sa zic ce inseamna codul de mai sus decat ca m-a ajutat si a functionat. Acum am exportat baza de date si fisierele importante sa nu o patesc a doua oara.