MySQL shutdown unexpectedly on XAMPP - Server socket created on IP: '::'

user_13674977 0
Viewed 2910

I'm still fairly new to XAMPP and it has been running great until I started work this morning. Here is the error log file information. When I try to start MySQL it turns on and then stops. I'd prefer to not reinstall if needed but can if that's what it takes.

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

And here is the my.ini file.

# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# You can copy this file to
# C:/xampp/mysql/bin/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is C:/xampp/mysql/data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
# password       = your_password 
port=3307
socket="C:/xampp/mysql/mysql.sock"


# Here follows entries for some specific programs 

# The MySQL server
default-character-set=utf8mb4
[mysqld]
port=3307
socket="C:/xampp/mysql/mysql.sock"
basedir="C:/xampp/mysql"
tmpdir="C:/xampp/tmp"
datadir="C:/xampp/mysql/data"
pid_file="mysql.pid"
# enable-named-pipe
key_buffer=16M
xampp mysql
1 Answers

Caution! Please do NOT delete ibdata1 file! First take backup MySQL of folder 'mysql/data'

  1. Take backup all files+folder from folder mysql/data to mysql/data_old_backup

  2. Sometime XAMPP MySQL service stopped working, in my case reason in XAMPP control panel: "Error: MySQL shutdown unexpectedly" with the same error log

Solution:

  1. I have fixed the same issue, copy (+overwrite) all files+folder from xampp/mysql/backup/ into xampp/mysql/data/
  2. You may lost your Mysql root password after step-1, your mysql password is null now.
  3. Now, Copy (+overwrite) file ibdata1 from backup folder from "mysql/data_old_backup/ibdata1" to xampp/mysql/data/
    (because you want to restore all your data)
  4. Start MySQL from XAMPP control panel.

It should work

user_91094180
Related