MySQL don't start

[storman]

Hello

I'm using xampp latest version on Windows 10 64 bit PC. Xampp was working just fine for along period since installation. Suddenly, MySQL can't be started and keeps shutting down.

I receive this message from the control panel

Code: Select all

8:00:59 PM  [mysql]    Attempting to start MySQL app...
8:00:59 PM  [mysql]    Status change detected: running
8:01:03 PM  [mysql]    Status change detected: stopped
8:01:03 PM  [mysql]    Error: MySQL shutdown unexpectedly.
8:01:03 PM  [mysql]    This may be due to a blocked port, missing dependencies,
8:01:03 PM  [mysql]    improper privileges, a crash, or a shutdown by another method.
8:01:03 PM  [mysql]    Press the Logs button to view error logs and check
8:01:03 PM  [mysql]    the Windows Event Viewer for more clues
8:01:04 PM  [mysql]    If you need more help, copy and post this
8:01:04 PM  [mysql]    entire log window on the forums


and this is the error log

Code: Select all

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

any help?

thanks in advance

[storman]

using Xampp latest version

[Oluwataye]

Same challange i'm facing. Please i need solution to the problems above. Why would almost all beginners faced with same challange. Its discouraging, someone profer solution to the above stated problem. Thanks

[ronwoodtd]

My MySQL won't start either. Here is the log:

2020-06-12 12:23:46 13200 [Note] Plugin 'FEDERATED' is disabled.
2020-06-12 12:23:46 2578 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2020-06-12 12:23:46 13200 [Note] InnoDB: Using atomics to ref count buffer pool pages
2020-06-12 12:23:46 13200 [Note] InnoDB: The InnoDB memory heap is disabled
2020-06-12 12:23:46 13200 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-12 12:23:46 13200 [Note] InnoDB: Memory barrier is not used
2020-06-12 12:23:46 13200 [Note] InnoDB: Compressed tables use zlib 1.2.3
2020-06-12 12:23:46 13200 [Note] InnoDB: Not using CPU crc32 instructions
2020-06-12 12:23:46 13200 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2020-06-12 12:23:46 13200 [Note] InnoDB: Completed initialization of buffer pool
2020-06-12 12:23:46 13200 [Note] InnoDB: Highest supported file format is Barracuda.
2020-06-12 12:23:46 13200 [Note] InnoDB: 128 rollback segment(s) are active.
2020-06-12 12:23:46 13200 [Note] InnoDB: Waiting for purge to start
2020-06-12 12:23:46 13200 [Note] InnoDB: 5.6.21 started; log sequence number 1665504
2020-06-12 12:23:46 13200 [Note] Server hostname (bind-address): '*'; port: 3306
2020-06-12 12:23:46 13200 [Note] IPv6 is available.
2020-06-12 12:23:46 13200 [Note] - '::' resolves to '::';
2020-06-12 12:23:46 13200 [Note] Server socket created on IP: '::'.
2020-06-12 12:23:46 13200 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2020-06-12 12:23:46 13200 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2020-06-12 12:23:46 13200 [ERROR] Aborting

2020-06-12 12:23:46 13200 [Note] Binlog end
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'partition'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_METRICS'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_CMP'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_TRX'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'InnoDB'
2020-06-12 12:23:46 13200 [Note] InnoDB: FTS optimize thread exiting.
2020-06-12 12:23:46 13200 [Note] InnoDB: Starting shutdown...
2020-06-12 12:23:48 13200 [Note] InnoDB: Shutdown completed; log sequence number 1665514
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'BLACKHOLE'
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'ARCHIVE'
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'MRG_MYISAM'
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'MyISAM'
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'MEMORY'
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'CSV'
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'sha256_password'
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'mysql_old_password'
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'mysql_native_password'
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'binlog'
2020-06-12 12:23:48 13200 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

Can anyone help please?