Error Start mysql using xampp
Posted by: alonso rey
Date: September 06, 2023 11:36PM
Date: September 06, 2023 11:36PM
Hi all,
i have some trouble issue here,
mysql cannot start error shutdown unexpectedly,
im using xampp ..
here the logs error that i copied from error.log
kindly someone could help to resolve this..
error.log :
2023-09-07 13:15:57 7 [Note] Added new Master_info '2023-09-07 12:24:27 7 [Note] Added new Master_info '2023-09-07 1:18:07 2654 [Warning] Aborted connection 2654 to db: 'gmtd_itop' user: 'admin' host: '' (Got timeout reading communication pack' to hash table
2023-09-07 13:15:57 7 [Note] Reading Master_info: 'master-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005bwarning@005d@0020reading@0020of@0020some@0020master_info@0020entries@0020failed@000d.info' Relay_info:'relay-log-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005bwarning@005d@0020reading@0020of@0020some@0020master_info@0020entries@0020failed@000d.info'
2023-09-07 13:15:57 7 [Note] Initialized Master_info from 'master-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005bwarning@005d@0020reading@0020of@0020some@0020master_info@0020entries@0020failed@000d.info'
2023-09-07 13:15:57 7 [Note] Added new Master_info '2023-09-07 12:24:27 0 [Warning] Reading of some Master_info entries failed
' to hash table
2023-09-07 13:15:57 18 [Note] Master '2023-09-07 12:24:27 0 [Warning] Reading of some Master_info entries failed
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2023-09-07 13:15:57 7 [Note] Started replication for '2023-09-07 12:24:27 0 [Warning] Reading of some Master_info entries failed
'
2023-09-07 13:15:57 19 [Note] Master '2023-09-07 12:24:27 0 [Warning] Reading of some Master_info entries failed
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005bwarning@005d@0020reading@0020of@0020some@0020master_info@0020entries@0020failed@000d.000003' position: 4
2023-09-07 13:15:57 18 [ERROR] Master '2023-09-07 12:24:27 0 [Warning] Reading of some Master_info entries failed
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2023-09-07 13:15:57 7 [Note] Reading Master_info: 'master-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005berror@005d@0020failed@0020to@0020initialize@0020multi@0020master@0020structures@000d.info' Relay_info:'relay-log-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005berror@005d@0020failed@0020to@0020initialize@0020multi@0020master@0020structures@000d.info'
2023-09-07 13:15:57 18 [Note] Master '2023-09-07 12:24:27 0 [Warning] Reading of some Master_info entries failed
': Slave I/O thread killed while connecting to master
2023-09-07 13:15:57 18 [Note] Master '2023-09-07 12:24:27 0 [Warning] Reading of some Master_info entries failed
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-09-07 13:15:57 18 [Note] Master '2023-09-07 12:24:27 0 [Warning] Reading of some Master_info entries failed
': master was :3306
2023-09-07 13:15:57 7 [Note] Initialized Master_info from 'master-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005berror@005d@0020failed@0020to@0020initialize@0020multi@0020master@0020structures@000d.info'
2023-09-07 13:15:57 7 [Note] Added new Master_info '2023-09-07 12:24:27 0 [ERROR] Failed to initialize multi master structures
' to hash table
2023-09-07 13:15:57 20 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Failed to initialize multi master structures
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2023-09-07 13:15:57 7 [Note] Started replication for '2023-09-07 12:24:27 0 [ERROR] Failed to initialize multi master structures
'
2023-09-07 13:15:57 21 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Failed to initialize multi master structures
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005berror@005d@0020failed@0020to@0020initialize@0020multi@0020master@0020structures@000d.000003' position: 4
2023-09-07 13:15:57 20 [ERROR] Master '2023-09-07 12:24:27 0 [ERROR] Failed to initialize multi master structures
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2023-09-07 13:15:57 7 [Note] Reading Master_info: 'master-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005berror@005d@0020aborting@000d.info' Relay_info:'relay-log-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005berror@005d@0020aborting@000d.info'
2023-09-07 13:15:57 20 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Failed to initialize multi master structures
': Slave I/O thread killed while connecting to master
2023-09-07 13:15:57 20 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Failed to initialize multi master structures
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-09-07 13:15:57 20 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Failed to initialize multi master structures
': master was :3306
2023-09-07 13:15:58 7 [Note] Initialized Master_info from 'master-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005berror@005d@0020aborting@000d.info'
2023-09-07 13:15:58 7 [Note] Added new Master_info '2023-09-07 12:24:27 0 [ERROR] Aborting
' to hash table
2023-09-07 13:15:58 22 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Aborting
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2023-09-07 13:15:58 7 [Note] Started replication for '2023-09-07 12:24:27 0 [ERROR] Aborting
'
2023-09-07 13:15:58 23 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Aborting
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005berror@005d@0020aborting@000d.000003' position: 4
2023-09-07 13:15:58 22 [ERROR] Master '2023-09-07 12:24:27 0 [ERROR] Aborting
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2023-09-07 13:15:58 0 [Warning] Reading of some Master_info entries failed
2023-09-07 13:15:58 22 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Aborting
': Slave I/O thread killed while connecting to master
2023-09-07 13:15:58 0 [ERROR] Failed to initialize multi master structures
2023-09-07 13:15:58 22 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Aborting
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-09-07 13:15:58 0 [ERROR] Aborting
2023-09-07 13:15:58 22 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Aborting
': master was :3306
PLZ Help me!
i have some trouble issue here,
mysql cannot start error shutdown unexpectedly,
im using xampp ..
here the logs error that i copied from error.log
kindly someone could help to resolve this..
error.log :
2023-09-07 13:15:57 7 [Note] Added new Master_info '2023-09-07 12:24:27 7 [Note] Added new Master_info '2023-09-07 1:18:07 2654 [Warning] Aborted connection 2654 to db: 'gmtd_itop' user: 'admin' host: '' (Got timeout reading communication pack' to hash table
2023-09-07 13:15:57 7 [Note] Reading Master_info: 'master-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005bwarning@005d@0020reading@0020of@0020some@0020master_info@0020entries@0020failed@000d.info' Relay_info:'relay-log-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005bwarning@005d@0020reading@0020of@0020some@0020master_info@0020entries@0020failed@000d.info'
2023-09-07 13:15:57 7 [Note] Initialized Master_info from 'master-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005bwarning@005d@0020reading@0020of@0020some@0020master_info@0020entries@0020failed@000d.info'
2023-09-07 13:15:57 7 [Note] Added new Master_info '2023-09-07 12:24:27 0 [Warning] Reading of some Master_info entries failed
' to hash table
2023-09-07 13:15:57 18 [Note] Master '2023-09-07 12:24:27 0 [Warning] Reading of some Master_info entries failed
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2023-09-07 13:15:57 7 [Note] Started replication for '2023-09-07 12:24:27 0 [Warning] Reading of some Master_info entries failed
'
2023-09-07 13:15:57 19 [Note] Master '2023-09-07 12:24:27 0 [Warning] Reading of some Master_info entries failed
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005bwarning@005d@0020reading@0020of@0020some@0020master_info@0020entries@0020failed@000d.000003' position: 4
2023-09-07 13:15:57 18 [ERROR] Master '2023-09-07 12:24:27 0 [Warning] Reading of some Master_info entries failed
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2023-09-07 13:15:57 7 [Note] Reading Master_info: 'master-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005berror@005d@0020failed@0020to@0020initialize@0020multi@0020master@0020structures@000d.info' Relay_info:'relay-log-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005berror@005d@0020failed@0020to@0020initialize@0020multi@0020master@0020structures@000d.info'
2023-09-07 13:15:57 18 [Note] Master '2023-09-07 12:24:27 0 [Warning] Reading of some Master_info entries failed
': Slave I/O thread killed while connecting to master
2023-09-07 13:15:57 18 [Note] Master '2023-09-07 12:24:27 0 [Warning] Reading of some Master_info entries failed
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-09-07 13:15:57 18 [Note] Master '2023-09-07 12:24:27 0 [Warning] Reading of some Master_info entries failed
': master was :3306
2023-09-07 13:15:57 7 [Note] Initialized Master_info from 'master-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005berror@005d@0020failed@0020to@0020initialize@0020multi@0020master@0020structures@000d.info'
2023-09-07 13:15:57 7 [Note] Added new Master_info '2023-09-07 12:24:27 0 [ERROR] Failed to initialize multi master structures
' to hash table
2023-09-07 13:15:57 20 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Failed to initialize multi master structures
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2023-09-07 13:15:57 7 [Note] Started replication for '2023-09-07 12:24:27 0 [ERROR] Failed to initialize multi master structures
'
2023-09-07 13:15:57 21 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Failed to initialize multi master structures
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005berror@005d@0020failed@0020to@0020initialize@0020multi@0020master@0020structures@000d.000003' position: 4
2023-09-07 13:15:57 20 [ERROR] Master '2023-09-07 12:24:27 0 [ERROR] Failed to initialize multi master structures
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2023-09-07 13:15:57 7 [Note] Reading Master_info: 'master-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005berror@005d@0020aborting@000d.info' Relay_info:'relay-log-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005berror@005d@0020aborting@000d.info'
2023-09-07 13:15:57 20 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Failed to initialize multi master structures
': Slave I/O thread killed while connecting to master
2023-09-07 13:15:57 20 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Failed to initialize multi master structures
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-09-07 13:15:57 20 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Failed to initialize multi master structures
': master was :3306
2023-09-07 13:15:58 7 [Note] Initialized Master_info from 'master-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005berror@005d@0020aborting@000d.info'
2023-09-07 13:15:58 7 [Note] Added new Master_info '2023-09-07 12:24:27 0 [ERROR] Aborting
' to hash table
2023-09-07 13:15:58 22 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Aborting
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2023-09-07 13:15:58 7 [Note] Started replication for '2023-09-07 12:24:27 0 [ERROR] Aborting
'
2023-09-07 13:15:58 23 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Aborting
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d09@002d07@002012@003a24@003a27@00200@0020@005berror@005d@0020aborting@000d.000003' position: 4
2023-09-07 13:15:58 22 [ERROR] Master '2023-09-07 12:24:27 0 [ERROR] Aborting
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2023-09-07 13:15:58 0 [Warning] Reading of some Master_info entries failed
2023-09-07 13:15:58 22 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Aborting
': Slave I/O thread killed while connecting to master
2023-09-07 13:15:58 0 [ERROR] Failed to initialize multi master structures
2023-09-07 13:15:58 22 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Aborting
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-09-07 13:15:58 0 [ERROR] Aborting
2023-09-07 13:15:58 22 [Note] Master '2023-09-07 12:24:27 0 [ERROR] Aborting
': master was :3306
PLZ Help me!
Subject
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.