Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

xampp mysql Failed to initialize multi master structures

Tags:

mysql

xampp

I installed xampp on windows and it worked.

Today when i try to start mysql service it returns this error and i can't run mysql

2020-01-05 17:10:07 17 [Note] Master '2020-01-04 19:28:32 23 [Warning] Checking table:   '.\htmarket\users'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2020@002d01@002d04@002019@003a28@003a32@002023@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005chtmarket@005cusers@[email protected]' position: 4
2020-01-05 17:10:07 16 [ERROR] Master '2020-01-04 19:28:32 23 [Warning] Checking table:   '.\htmarket\users'
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2020-01-05 17:10:07 0 [Warning] Reading of some Master_info entries failed
2020-01-05 17:10:07 16 [Note] Master '2020-01-04 19:28:32 23 [Warning] Checking table:   '.\htmarket\users'
': Slave I/O thread killed while connecting to master
2020-01-05 17:10:07 0 [ERROR] Failed to initialize multi master structures
2020-01-05 17:10:07 16 [Note] Master '2020-01-04 19:28:32 23 [Warning] Checking table:   '.\htmarket\users'
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-01-05 17:10:07 0 [ERROR] Aborting

what's wrong with mysql?

like image 915
Seyyed Mohammad Hosseini Avatar asked Jan 05 '20 13:01

Seyyed Mohammad Hosseini


1 Answers

I had the same issue, just delete the multi-master.info and all the garbage it created after the error and restart the mysql.

It worked for me.

like image 160
Syed Avatar answered Sep 19 '22 12:09

Syed