MySQL startet nicht

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

MySQL startet nicht

Postby MFeldhoff » 19. March 2022 09:51

Seit gestern Abend kann ich MySQL nicht mehr öffnen. Im XAMPP Shell wird mir eine endlos lange Fehlermeldung angezeigt, die ich hier gar nicht wiedergeben kann. Daher hier nur der Anfang...
Bin völlig überfordert. Kann mir bitte einer helfen.

05d@0020failed@0020to@0020open@0020the@0020relay@0020log@0020@0027@002e@005cmysql@002drelay@002dbin@002d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d.info' Relay_info:'relay-log-2022@002d03@002d18@002018@003a47@003a49@00207@0020@005berror@005d@0020failed@0020to@0020open@0020the@0020relay@0020log@0020@0027@002e@005cmysql@002drelay@002dbin@002d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d.info'
2022-03-19 9:49:20 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2022@002d03@002d18@002018@003a47@003a49@00207@0020@005berror@005d@0020failed@0020to@0020open@0020the@0020relay@0020log@0020@0027@002e@005cmysql@002drelay@002dbin@002d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d.info', errno 2)
2022-03-19 9:49:20 7 [ERROR] Initialized Master_info from 'master-2022@002d03@002d18@002018@003a47@003a49@00207@0020@005berror@005d@0020failed@0020to@0020open@0020the@0020relay@0020log@0020@0027@002e@005cmysql@002drelay@002dbin@002d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d.info' failed
2022-03-19 9:49:20 7 [ERROR] Connection '2022-03-18 18:47:49 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003' conflicts with existing connection '2022-03-18 18:47:49 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003'
2022-03-19 9:49:20 7 [Note] Reading Master_info: 'master-2022@002d03@002d18@002018@003a47@003a49@00207@0020@005berror@005d@0020could@0020not@0020find@0020target@0020log@0020during@0020relay@0020log@0020initialization@000d.info' Relay_info:'relay-log-2022@002d03@002d18@002018@003a47@003a49@00207@0020@005berror@005d@0020could@0020not@0020find@0020target@0020log@0020during@0020relay@0020log@0020initialization@000d.info'
2022-03-19 9:49:20 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2022@002d03@002d18@002018@003a47@003a49@00207@0020@005berror@005d@0020could@0020not@0020find@0020target@0020log@0020during@0020relay@0020log@0020initialization@000d.000023' (relay_log_pos 4)
2022-03-19 9:49:20 7 [ERROR] Could not find target log during relay log initialization
2022-03-19 9:49:20 7 [ERROR] Initialized Master_info from 'master-2022@002d03@002d18@002018@003a47@003a49@00207@0020@005berror@005d@0020could@0020not@0020find@0020target@0020log@0020during@0020relay@0020log@0020initialization@000d.info' failed
2022-03-19 9:49:20 7 [ERROR] Connection '2022-03-18 18:47:49 7 [ERROR] Could not find target log during relay log initi' conflicts with existing connection '2022-03-18 18:47:49 7 [ERROR] Could not find target log during relay log initializ'tion
2022-03-19 9:49:20 7 [Note] Reading Master_info: 'master-2022@002d03@002d18@002018@003a47@003a49@00207@0020@005berror@005d@0020initialized@0020master_info@0020from@0020@0027master@002d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@00.info' Relay_info:'relay-log-2022@002d03@002d18@002018@003a47@003a49@00207@0020@005berror@005d@0020initialized@0020master_info@0020from@0020@0027master@002d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@00.info'
2022-03-19 9:49:20 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2022@002d03@002d18@002018@003a47@003a49@00207@0020@005berror@005d@0020initialized@0020master_info@0020from@0020@0027master@002d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@00.info', errno 2)
2022-03-19 9:49:20 7 [ERROR] Initialized Master_info from 'master-2022@002d03@002d18@002018@003a47@003a49@00207@0020@005berror@005d@0020initialized@0020master_info@0020from@0020@0027master@002d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@0040003d@00.info' failed
2022-03-19 9:49:20 7 [ERROR] Connection '2022-03-18 18:47:49 7 [ERROR] Initialized Master_info from 'master-@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d' conflicts with existing connection '2022-03-18 18:47:49 7 [ERROR] Initialized Master_info from 'master-@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d'
2022-03-19 9:49:20 7 [Note] Reading Master_info: 'master-2022@002d03@002d18@002018@003a47@003a49@00207@0020@005berror@005d@0020connection@0020@0027@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@000d@0027@0020conflicts@0020with@0020existing@0020connection@0020@0027@003d@0.info' Relay_info:'relay-log-2022@002d03@002d18@002018@003a47@003a49@00207@0020@005berror@005d@0020connection@0020@0027@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@000d@0027@0020conflicts@0020with@0020existing@0020connection@0020@0027@003d@0.info'
2022-03-19 9:49:20 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2022@002d03@002d18@002018@003a47@003a49@00207@0020@005berror@005d@0020connection@0020@0027@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@000d@0027@0020conflicts@0020with@0020existing@0020connection@0020@0027@003d@0.info', errno 2)
2022-03-19 9:49:20 7 [ERROR] Initialized Master_info from 'master-2022@002d03@002d18@002018@003a47@003a49@00207@0020@005berror@005d@0020connection@0020@0027@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@003d@000d@0027@0020conflicts@0020with@0020existing@0020connection@0020@0027@003d@0.info' failed
2022-03-19 9:49:20 7 [Note] Added new Master_info '2022-03-18 18:47:49 7 [ERROR] Connection '==========================' to hash tableh existing connection '=====================================
MFeldhoff
 
Posts: 6
Joined: 16. February 2022 17:25
XAMPP version: 3.2.4
Operating System: Windows11

Re: MySQL startet nicht

Postby Altrea » 19. March 2022 11:53

Probiere bitte mal folgendes, das hat bei anderen schon zum Erfolg bei genau diesem Problem geführt:

Öffne den Ordner "\xampp\mysql\data\"
Lösche die Datei "multi-master.info"
Lösche alle Dateien deren Dateiname beginnt mit: "master-"
Lösche alle Dateien deren Dateiname beginnt mit: "mysql_relay-bin-"
Lösche alle Dateien deren Dateiname beginnt mit: "relay-log-"
Lösche alle Dateien deren Dateiname beginnt mit: "ib_logfile"
Lösche alle Dateien deren Dateiname beginnt mit: "aria_log."

Versuche nun MariaDB zu starten.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11933
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: MySQL startet nicht

Postby MFeldhoff » 19. March 2022 14:48

Wow, hat geklappt.
DANKE für Deine schnelle und hilfreiche Antwort. :-)
MFeldhoff
 
Posts: 6
Joined: 16. February 2022 17:25
XAMPP version: 3.2.4
Operating System: Windows11


Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 95 guests