by Scheuermann » 21. February 2021 09:33
Hallo Altrea!
Danke für die Antwort!
Habe getan was du verlang hast. Das Ergebnis ist jedoch mehrere Seiten lang und ich kann es hier nicht posten.
Als Anfang werde ich dir die ersten Zeilen hier reinstellen und wenn du noch mehr Infos brauchst dann kommt der Rest einzeln.
2021-02-21 9:21:29 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-02-21 9:21:29 0 [Note] mysqld (mysqld 10.4.14-MariaDB) starting as process 13096 ...
InnoDB: using atomic writes.
2021-02-21 9:21:29 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-02-21 9:21:29 0 [Note] InnoDB: Uses event mutexes
2021-02-21 9:21:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-21 9:21:29 0 [Note] InnoDB: Number of pools: 1
2021-02-21 9:21:29 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-02-21 9:21:29 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-02-21 9:21:29 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-21 9:21:29 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-02-21 9:21:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-21 9:21:29 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-02-21 9:21:29 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-02-21 9:21:29 0 [Note] InnoDB: Waiting for purge to start
2021-02-21 9:21:29 0 [Note] InnoDB: 10.4.14 started; log sequence number 790344797; transaction id 230108
2021-02-21 9:21:29 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-02-21 9:21:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-02-21 9:21:29 0 [Note] Server socket created on IP: '::'.
2021-02-21 9:21:29 0 [Note] InnoDB: Buffer pool(s) load completed at 210221 9:21:29
2021-02-21 9:21:29 7 [Note] Reading Master_info: 'master-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-02-21 9:21:29 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-02-21 9:21:29 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000006' (relay_log_pos 4)
2021-02-21 9:21:29 7 [ERROR] Binlog has bad magic number; It's not a binary log file that can be used by this version of MySQL
2021-02-21 9:21:29 7 [ERROR] Initialized Master_info from 'master-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' failed
2021-02-21 9:21:29 7 [Note] Added new Master_info '2021-02-14 16:18:00 0 [Note] Reading of all Master_info entries succ' to hash table
2021-02-21 9:21:29 7 [Note] Reading Master_info: 'master-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2021-02-21 9:21:29 7 [Note] Initialized Master_info from 'master-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table1:29 7 [Note] Added new Master_info '2021-02-14 16:18:00 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4hash table
2021-02-21 9:21:29 7 [Note] Started replication for '2021-02-14 16:18:00 0 [Note] Added new Master_info '' to hash tabl'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000027' position: 4
': 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-02-21 9:21:29 7 [Note] Reading Master_info: 'master-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
': Slave I/O thread killed while connecting to master:00 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread exiting, read up to log 'FIRST', position 4e] Added new Master_info '' to hash table
2021-02-21 9:21:29 7 [Note] Initialized Master_info from 'master-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2021-02-21 9:21:29 7 [Note] Added new Master_info '2021-02-14 16:18:00 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready fo' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4xe: ready for connections.
2021-02-21 9:21:29 7 [Note] Started replication for '2021-02-14 16:18:00 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready 'or connections.
2021-02-21 9:21:29 10 [ERROR] Master '2021-02-14 16:18:00 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections': 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-02-21 9:21:29 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e14@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@002e14@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d02@002d14@002016@003a18@003a00@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000027' position: 4
': Slave I/O thread killed while connecting to master8:00 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
2021-02-21 9:21:29 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e14@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2021-02-21 9:21:29 7 [Note] Added new Master_info 'Version: '10.4.14-MariaDB' socket: '' port: 3306 mariadb.org bina' to hash table
2021-02-21 9:21:29 12 [Note] Master 'Version: '10.4.14-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2021-02-21 9:21:29 12 [ERROR] Master 'Version: '10.4.14-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-02-21 9:21:29 7 [Note] Started replication for 'Version: '10.4.14-MariaDB' socket: '' port: 3306 mariadb.org bi'ary distribution
2021-02-21 9:21:29 13 [Note] Master 'Version: '10.4.14-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@002e14@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000027' position: 4
2021-02-21 9:21:29 12 [Note] Master 'Version: '10.4.14-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread killed while connecting to master
2021-02-21 9:21:29 7 [Note] Reading Master_info: 'master-2021@002d02@002d14@002016@003a18@003a20@00209@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cmhf@005czxmcw_content@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' Relay_info:'relay-log-2021@002d02@002d14@002016@003a18@003a20@00209@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cmhf@005czxmcw_content@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info'
2021-02-21 9:21:29 12 [Note] Master 'Version: '10.4.14-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread exiting, read up to log 'FIRST', position 4
2021-02-21 9:21:29 7 [ERROR] Error reading master configuration