ERRORE BLOCCANTE NEL PANNELLO XAMPP NEL'APERTURA DI MYSQL

di nonnarita il
11 risposte

Periodicamente , in ambiente xampp , nel pannello di controllo di xampp  cliccando su admin di mysql  mi appare il    messaggio sotto evidenziato che mi impedisce di aprire  phpmyadmin e di gestire i miei databases rischiando di perderli se non li ho preventivamente salvati.

In conseguenza di cio' , per poter proseguire i miei lavori sono costretta a disinstallare xampp e reinstallarlo, con notevole perdita di tempo.

Mi potete dare una mano?

Grazie

Rita De Marco

SYSTEMA OPERATIVO: WINDOWS 11

MESSAGGIO:

  07:50:22  [main]            Initializing Control Panel

07:50:22  [main]            Windows Version:  Enterprise  64-bit

07:50:22  [main]            XAMPP Version: 8.2.12

07:50:22  [main]            Control Panel Version: 3.3.0  [ Compiled: Apr 6th 2021 ]

07:50:22  [main]            You are not running with administrator rights! This will work for

07:50:22  [main]            most application stuff but whenever you do something with services

07:50:22  [main]            there will be a security dialogue or things will break! So think

07:50:22  [main]            about running this application with administrator rights!

07:50:22  [main]            XAMPP Installation Directory: "c:\xampp\"

07:50:22  [main]            Checking for prerequisites

07:50:22  [main]            All prerequisites found

07:50:22  [main]            Initializing Modules

07:50:22  [main]            Starting Check-Timer

07:50:22  [main]            Control Panel Ready

07:50:27  [Apache]       Attempting to start Apache app...

07:50:27  [Apache]       Status change detected: running

07:50:33  [mysql]          Attempting to start MySQL app...

07:50:33  [mysql]          Status change detected: running

07:50:38  [mysql]          Status change detected: stopped

07:50:38  [mysql]          Error: MySQL shutdown unexpectedly.

07:50:38  [mysql]          This may be due to a blocked port, missing dependencies,

07:50:38  [mysql]          improper privileges, a crash, or a shutdown by another method.

07:50:38  [mysql]          Press the Logs button to view error logs and check

07:50:38  [mysql]          the Windows Event Viewer for more clues

07:50:38  [mysql]          If you need more help, copy and post this

07:50:38  [mysql]          entire log window on the forums

11 Risposte

  • Si arresta mysql...

    Mostra mysql_error.log

  • Purtroppo non posso più fare questo tipo di controllo;

     ho dovuto disinstallare e reinstallare xampp perche' avevo urgenza di lavorare .

    Dovesse succedere un'altra volta mi potete dire in quale cartella trovare il file mysql_err.log?

    Grazie

    Rita

  • Nel pannello di controllo di XAMPP accanto al servizio MySQL, clicca sul pulsante "Logs" (o qualcosa del genere)

    oppure
    Accedi alla cartella di installazione di XAMPP (es. /opt/lampp/ su Linux o C:\xampp\ su Windows).
    Naviga nella directory mysql/data (o simile).
    Trova i file di log come error.log o mysql.log. Il percorso esatto dipende dalla configurazione di installazione e dalla versione di MySQL.

    oppure
    apri la cartella xampp e dalla cartella cerca "log" abilitando la ricerca anche alle sottocartelle.

  • Grazie , lo faro' senz'altro

    Rita

  • Buongiorno,

    ho aperto il mysql .log e questo è l'errore che mi propone

    2025-10-21 12:14:02 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 19716
    2025-10-21 12:14:02 0 [Note] mysqld.exe: Aria engine: starting recovery
    recovered pages: 0% 100% (0.0 seconds); 
    2025-10-21 12:14:02 0 [Note] mysqld.exe: Aria engine: recovery done
    2025-10-21 12:14:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2025-10-21 12:14:02 0 [Note] InnoDB: Uses event mutexes
    2025-10-21 12:14:02 0 [Note] InnoDB: Compressed tables use zlib 1.3
    2025-10-21 12:14:02 0 [Note] InnoDB: Number of pools: 1
    2025-10-21 12:14:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
    2025-10-21 12:14:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
    2025-10-21 12:14:02 0 [Note] InnoDB: Completed initialization of buffer pool
    2025-10-21 12:14:02 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=152797001
    2025-10-21 12:14:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
    2025-10-21 12:14:02 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
    2025-10-21 12:14:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2025-10-21 12:14:02 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2025-10-21 12:14:02 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
    2025-10-21 12:14:02 0 [Note] InnoDB: Waiting for purge to start
    2025-10-21 12:14:03 0 [Note] InnoDB: 10.4.32 started; log sequence number 152797010; transaction id 8294
    2025-10-21 12:14:03 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
    2025-10-21 12:14:03 0 [Note] Plugin 'FEEDBACK' is disabled.
    2025-10-21 12:14:03 0 [Note] Server socket created on IP: '::'.

    dov'è l'errore ?

    Grazie

    Saluti

  • Questo log non presenta errori...

    che messaggio di errori hai?

  • IL MYSQL SI E' BLOCCATO DI NUOVO 

    QUESTO APPRE SUL PANNELLO DI CONTROLLO:

    1:05:19  [main]     Initializing Control Panel
    11:05:19  [main]     Windows Version:  Enterprise  64-bit
    11:05:19  [main]     XAMPP Version: 8.2.12
    11:05:19  [main]     Control Panel Version: 3.3.0  [ Compiled: Apr 6th 2021 ]
    11:05:19  [main]     You are not running with administrator rights! This will work for
    11:05:19  [main]     most application stuff but whenever you do something with services
    11:05:19  [main]     there will be a security dialogue or things will break! So think 
    11:05:19  [main]     about running this application with administrator rights!
    11:05:19  [main]     XAMPP Installation Directory: "c:\xampp\"
    11:05:19  [main]     Checking for prerequisites
    11:05:22  [main]     All prerequisites found
    11:05:22  [main]     Initializing Modules
    11:05:22  [main]     Starting Check-Timer
    11:05:22  [main]     Control Panel Ready
    11:05:26  [Apache]     Attempting to start Apache app...
    11:05:26  [Apache]     Status change detected: running
    11:05:36  [mysql]     Attempting to start MySQL app...
    11:05:36  [mysql]     Status change detected: running
    11:05:37  [mysql]     Status change detected: stopped
    11:05:37  [mysql]     Error: MySQL shutdown unexpectedly.
    11:05:37  [mysql]     This may be due to a blocked port, missing dependencies, 
    11:05:37  [mysql]     improper privileges, a crash, or a shutdown by another method.
    11:05:37  [mysql]     Press the Logs button to view error logs and check
    11:05:37  [mysql]     the Windows Event Viewer for more clues
    11:05:37  [mysql]     If you need more help, copy and post this
    11:05:37  [mysql]     entire log window on the forums
    11:18:00  [main]     Executing "services.msc"

    E QUESTO E' IL CONTENUTO DI MYSQL ERROR LOG:

    2025-11-18 11:05:36 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 15164
    2025-11-18 11:05:36 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2025-11-18 11:05:36 0 [Note] InnoDB: Uses event mutexes
    2025-11-18 11:05:36 0 [Note] InnoDB: Compressed tables use zlib 1.3
    2025-11-18 11:05:36 0 [Note] InnoDB: Number of pools: 1
    2025-11-18 11:05:36 0 [Note] InnoDB: Using SSE2 crc32 instructions
    2025-11-18 11:05:36 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
    2025-11-18 11:05:36 0 [Note] InnoDB: Completed initialization of buffer pool
    2025-11-18 11:05:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=164890830
    2025-11-18 11:05:36 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
    2025-11-18 11:05:36 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
    2025-11-18 11:05:36 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2025-11-18 11:05:36 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2025-11-18 11:05:36 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
    2025-11-18 11:05:36 0 [Note] InnoDB: Waiting for purge to start
    2025-11-18 11:05:36 0 [Note] InnoDB: 10.4.32 started; log sequence number 164890839; transaction id 13674
    2025-11-18 11:05:36 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
    2025-11-18 11:05:36 0 [Note] Plugin 'FEEDBACK' is disabled.
    2025-11-18 11:05:36 0 [Note] Server socket created on IP: '::'.

    VORREI CAPIRE PERCHE' QUESTO BLOCCO AVVIENE IN MODO RANDOM.

    GRAZIE SE MI SPIEGATE IL PERCHE'

    CIAO RITA

  • Questa è la questione:

    11:05:19  [main]     You are not running with administrator rights! This will work for
                                     most application stuff but whenever you do something with services
                                     there will be a security dialogue or things will break! So think 
                                     about running this application with administrator rights!

    Qui trovi la soluzione:

    https://stackoverflow.com/questions/18022809/how-can-i-solve-error-mysql-shutdown-unexpectedly

    leggi tutto prima di metterci mani.

    18/11/2025 - nonnarita ha scritto:

    VORREI CAPIRE PERCHE' QUESTO BLOCCO AVVIENE IN MODO RANDOM.

    probabilmente hai un problema di porta.

  • Xampp si avvia....

    11:05:36  [mysql]     Attempting to start MySQL app...
    11:05:36  [mysql]     Status change detected: running

    dialoga con mysql.... che fa questo:

    2025-11-18 11:05:36 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 15164
    2025-11-18 11:05:36 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2025-11-18 11:05:36 0 [Note] InnoDB: Uses event mutexes
    2025-11-18 11:05:36 0 [Note] InnoDB: Compressed tables use zlib 1.3
    2025-11-18 11:05:36 0 [Note] InnoDB: Number of pools: 1
    2025-11-18 11:05:36 0 [Note] InnoDB: Using SSE2 crc32 instructions
    2025-11-18 11:05:36 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
    2025-11-18 11:05:36 0 [Note] InnoDB: Completed initialization of buffer pool
    2025-11-18 11:05:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=164890830
    2025-11-18 11:05:36 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
    2025-11-18 11:05:36 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
    2025-11-18 11:05:36 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2025-11-18 11:05:36 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2025-11-18 11:05:36 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
    2025-11-18 11:05:36 0 [Note] InnoDB: Waiting for purge to start
    2025-11-18 11:05:36 0 [Note] InnoDB: 10.4.32 started; log sequence number 164890839; transaction id 13674
    2025-11-18 11:05:36 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
    2025-11-18 11:05:36 0 [Note] Plugin 'FEEDBACK' is disabled.
    2025-11-18 11:05:36 0 [Note] Server socket created on IP: '::'.

    e dopo un secondo ritorna su xampp che dice:

    11:05:37  [mysql]     Status change detected: stopped
    11:05:37  [mysql]     Error: MySQL shutdown unexpectedly.
    11:05:37  [mysql]     This may be due to a blocked port, missing dependencies, 
    11:05:37  [mysql]     improper privileges, a crash, or a shutdown by another method.
    11:05:37  [mysql]     Press the Logs button to view error logs and check
    11:05:37  [mysql]     the Windows Event Viewer for more clues
    11:05:37  [mysql]     If you need more help, copy and post this
    11:05:37  [mysql]     entire log window on the forums
    11:18:00  [main]     Executing "services.msc"

    controlla questo cambiamento imposto da mysql diverso da xampp:

    18/11/2025 - nonnarita ha scritto:

    2025-11-18 11:05:36 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
    2025-11-18 11:05:36 0 [Note] InnoDB: Completed initialization of buffer pool
    2025-11-18 11:05:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=164890830

    18/11/2025 - nonnarita ha scritto:

    2025-11-18 11:05:36 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.

    cambia le impostazioni dal pannello di xampp, segui il link.

    probabilmente se riavvii il servizio mysql tutto funziona.

  • Ma se lanci solo il MySql sta su o si spegne?

Devi accedere o registrarti per scrivere nel forum
11 risposte