Fehler: MySQL wurde unerwartet beendet

Irgendwelche Probleme mit XAMPP für Windows? Dann ist hier genau der richtige Ort um nachzufragen.

Fehler: MySQL wurde unerwartet beendet

Postby toni69 » 10. April 2021 13:55

Hallo in die Runde...

MySQL lässt sich plötzlich nicht mehr starten. Ich habe einige Topics zu diesem Thema gelesen und habe über den Shell-Button auch diesen Befehl abgesetzt:
mysqld --defaults-file=mysql\bin\my.ini --standalone --console

Ich hoffe, ihr könnt mir helfen...
Beste Grüße, Toni

Hier ist das Ergebnis:

Setting environment for using XAMPP for Windows.
Toni Standard@TONI-PC c:\xampp
# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2021-04-10 14:49:42 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2021-04-10 14:49:42 0 [Note] mysqld (mysqld 10.4.17-MariaDB) starting as process 6388 ...
InnoDB: using atomic writes.
2021-04-10 14:49:42 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-04-10 14:49:42 0 [Note] InnoDB: Uses event mutexes
2021-04-10 14:49:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-04-10 14:49:42 0 [Note] InnoDB: Number of pools: 1
2021-04-10 14:49:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-04-10 14:49:42 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-04-10 14:49:42 0 [Note] InnoDB: Completed initialization of buffer pool
2021-04-10 14:49:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-04-10 14:49:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-04-10 14:49:42 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-04-10 14:49:42 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-04-10 14:49:42 0 [Note] InnoDB: 10.4.17 started; log sequence number 26534732; transaction id 31575
2021-04-10 14:49:42 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-04-10 14:49:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-04-10 14:49:42 0 [Note] Server socket created on IP: '::'.
2021-04-10 14:49:42 0 [Note] InnoDB: Buffer pool(s) load completed at 210410 14:49:42
2021-04-10 14:49:42 7 [Note] Reading Master_info: 'master-2021@002d04@002d07@002020@003a00@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2021@002d04@002d07@002020@003a00@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-04-10 14:49:42 7 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem.
2021-04-10 14:49:42 7 [Note] Initialized Master_info from 'master-2021@002d04@002d07@002020@003a00@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-04-10 14:49:42 7 [Note] Added new Master_info '2021-04-07 20:00:24 0 [Note] Reading of all Master_info entries succ' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4ntries succeeded
2021-04-10 14:49:42 7 [Note] Started replication for '2021-04-07 20:00:24 0 [Note] Reading of all Master_info entries su'ceeded
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2021-04-10 14:49:42 7 [Note] Reading Master_info: 'master-2021@002d04@002d07@002020@003a00@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2021@002d04@002d07@002020@003a00@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
': Slave I/O thread killed while connecting to master:24 0 [Note] Reading of all Master_info entries succeeded
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d04@002d07@002020@003a00@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000020' position: 4
': Slave I/O thread exiting, read up to log 'FIRST', position 4e] Reading of all Master_info entries succeeded
2021-04-10 14:49:42 7 [Note] Initialized Master_info from 'master-2021@002d04@002d07@002020@003a00@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table9:42 7 [Note] Added new Master_info '2021-04-07 20:00:24 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4 hash table
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2021-04-10 14:49:42 7 [Note] Started replication for '2021-04-07 20:00:24 0 [Note] Added new Master_info '' to hash tabl'
': Slave I/O thread killed while connecting to master0:24 0 [Note] Added new Master_info '' to hash table
2021-04-10 14:49:42 7 [Note] Reading Master_info: 'master-2021@002d04@002d07@002020@003a00@003a24@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2021@002d04@002d07@002020@003a00@003a24@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d04@002d07@002020@003a00@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000020' position: 4
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Added new Master_info '' to hash table
2021-04-10 14:49:42 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2021@002d04@002d07@002020@003a00@003a24@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000001' (relay_log_pos 4)
2021-04-10 14:49:42 7 [ERROR] Could not find target log during relay log initialization
2021-04-10 14:49:42 7 [ERROR] Initialized Master_info from 'master-2021@002d04@002d07@002020@003a00@003a24@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' failed
2021-04-10 14:49:42 7 [Note] Added new Master_info '2021-04-07 20:00:24 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready fo' to hash table
2021-04-10 14:49:42 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info' Relay_info:'relay-log-version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2021-04-10 14:49:42 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2021-04-10 14:49:42 7 [Note] Added new Master_info 'Version: '10.4.17-MariaDB' socket: '' port: 3306 mariadb.org bina' to hash table
2021-04-10 14:49:42 12 [Note] Master 'Version: '10.4.17-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2021-04-10 14:49:42 12 [ERROR] Master 'Version: '10.4.17-MariaDB' socket: '' port: 3306 mariadb.org binary distributi': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2021-04-10 14:49:42 7 [Note] Started replication for 'Version: '10.4.17-MariaDB' socket: '' port: 3306 mariadb.org bi'ary distribution
2021-04-10 14:49:42 12 [Note] Master 'Version: '10.4.17-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread killed while connecting to master
2021-04-10 14:49:42 0 [Warning] Reading of some Master_info entries failed
2021-04-10 14:49:42 13 [Note] Master 'Version: '10.4.17-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000012' position: 4
2021-04-10 14:49:42 12 [Note] Master 'Version: '10.4.17-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread exiting, read up to log 'FIRST', position 4
2021-04-10 14:49:42 0 [ERROR] Failed to initialize multi master structures
2021-04-10 14:49:42 0 [ERROR] Aborting
Warning: Memory not freed: 256

Toni Standard@TONI-PC c:\xampp
#
toni69
 
Posts: 3
Joined: 10. April 2021 13:45
XAMPP version: XAMPP v3.2.4
Operating System: Windows 10

Re: Fehler: MySQL wurde unerwartet beendet

Postby toni69 » 12. April 2021 08:01

Update zum geposteten Problem.

Das Problem ist gelöst. Ich bekam Hilfe.
Hier ist die Lösung, vielleicht hilft sie anderen genauso wie mir...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Versuche den in XAMPP enthaltenen MySQL-Sicherungsordner zu verwenden.
Versuche folgendes:

Benenne den Ordner mysql / data in mysql / data_old um (Du kannst einen beliebigen Namen verwenden).
Erstelle einen neuen Ordner mysql / data
Kopiere den Inhalt von mysql / backup in den neuen Ordner mysql / data
Kopiere alle Datenbankordner in mysql / data_old nach mysql / data
(Überspringen der Ordner mysql, performance_schema und phpmyadmin von data_old)
Kopiere abschließend die Datei ibdata1 aus mysql / data_old und ersetze sie im Ordner mysql / data

Starte MySQL über das XAMPP-Kontrollfeld
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Instead, first try using the MySQL backup folder which is included with XAMPP. So do the next:

Rename the folder mysql/data to mysql/data_old (you can use any name)
Create a new folder mysql/data
Copy the content that resides in mysql/backup to the new mysql/data folder
Copy all your database folders that are in mysql/data_old to mysql/data
(skipping the mysql, performance_schema, and phpmyadmin folders from data_old)
Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder

Start MySQL from XAMPP control panel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Voila, bei mir hat das geholfen. Wünsche viel Erfolg...
toni69
 
Posts: 3
Joined: 10. April 2021 13:45
XAMPP version: XAMPP v3.2.4
Operating System: Windows 10

Re: Fehler: MySQL wurde unerwartet beendet

Postby camouflage1984 » 24. April 2021 21:49

Hi toni69,

ich hatte das gleiche Problem und dein Lösungsweg hat bei mir auch funktioniert!

Danke.
camouflage1984
 
Posts: 1
Joined: 24. April 2021 21:45
XAMPP version: 7.4.11 & 8.0.2
Operating System: win 10 pro

Re: Fehler: MySQL wurde unerwartet beendet

Postby toni69 » 26. April 2021 06:36

camouflage1984 wrote:Hi toni69,

ich hatte das gleiche Problem und dein Lösungsweg hat bei mir auch funktioniert!

Danke.


Das freut mich, camouflage :)

Beste Grüße, Toni
toni69
 
Posts: 3
Joined: 10. April 2021 13:45
XAMPP version: XAMPP v3.2.4
Operating System: Windows 10


Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 35 guests