by edmundotrc » 06. November 2023 22:36
Hello everybody
I been creating a website using Wordpress Elementor Pro during the last two months, and I been using XAMPP Control Panel v3.3.0 (Apache & mysql) since the beginning)
only had couple issues that I don't consider that important, except for one two days ago.
The thing is that I was getting some messages while login into Wordpress (https://localhost/wordpress-6.3/wordpress/wp-login) saying that the URL was NOT secure, then
I had the idea of getting a CSR for SSL, etc. but before doing that I said to myself, maybe I should partially change (modify) the "site URL" (NOT Wordpress URL) and I went to
the Wordpress ... panel/settings and modified the URL this way ... form: "https://localhost/wordpress-6.3/wordpress" ... to: "https://localhost/wordpress-63/wordpress"
saved and logout from Wordpress and restarted XAMPP ... and since that moment mysql is NOT coming-up ... always generating the following in XAMPP console ...
==========================================================================
3:39:05 PM [mysql] Status change detected: running
3:39:07 PM [mysql] Status change detected: stopped
3:39:07 PM [mysql] Error: MySQL shutdown unexpectedly.
3:39:07 PM [mysql] This may be due to a blocked port, missing dependencies,
3:39:07 PM [mysql] improper privileges, a crash, or a shutdown by another method.
3:39:07 PM [mysql] Press the Logs button to view error logs and check
3:39:07 PM [mysql] the Windows Event Viewer for more clues
3:39:07 PM [mysql] If you need more help, copy and post this
3:39:07 PM [mysql] entire log window on the forums
==========================================================================
I tried multiple things after reading different opinion even in Wordpress library, like possible problems with ... the port, firewall, etc. and any of those seems the root problem.
After coming to this site, I found the following recommendation in order to obtain more information about the problem ... and I did run from XAMPP shell
mysqld --defaults-file=mysql\bin\my.ini --standalone --console
I obtained a really long result (a bunch of information), which I believe that an expert in your side could understand, decipher and recommend a solution.
==============================================================================================================================================================================
# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2023-11-06 15:16:07 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.
2023-11-06 15:16:07 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 24252
2023-11-06 15:16:07 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-06 15:16:07 0 [Note] InnoDB: Uses event mutexes
2023-11-06 15:16:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-06 15:16:07 0 [Note] InnoDB: Number of pools: 1
2023-11-06 15:16:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-06 15:16:07 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-06 15:16:07 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-06 15:16:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-06 15:16:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-06 15:16:07 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-06 15:16:07 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-06 15:16:07 0 [Note] InnoDB: Waiting for purge to start
2023-11-06 15:16:07 0 [Note] InnoDB: 10.4.28 started; log sequence number 725568084; transaction id 617731
2023-11-06 15:16:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-06 15:16:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-06 15:16:07 0 [Note] Server socket created on IP: '::'.
2023-11-06 15:16:07 0 [Note] InnoDB: Buffer pool(s) load completed at 231106 15:16:07
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master.info' Relay_info:'relay-log.info'
2023-11-06 15:16:07 7 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MariaDB server acts as a replica and has its hostname changed. Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem.
2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master.info'
2023-11-06 15:16:07 7 [Note] Added new Master_info '' to hash table
2023-11-06 15:16:07 8 [Note] Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 42023-11-06 15:16:07 8 [ERROR] 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-11-06 15:16:07 7 [Note] Started replication for ''
2023-11-06 15:16:07 8 [Note] Slave I/O thread killed while connecting to master
2023-11-06 15:16:07 9 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin.000013' position: 4
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2023-11-06 15:16:07 8 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-11-06 15:16:07 8 [Note] master was :3306
2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master-2023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table6:07 7 [Note] Added new Master_info '2023-11-05 0:13:11 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
2023-11-06 15:16:07 7 [Note] Started replication for '2023-11-05 0:13:11 0 [Note] Added new Master_info '' to hash tabl'
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000003' position: 4
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00200@003a13@003a11@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 master3:11 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Added new Master_info '' to hash table
': master was :3306 10 [Note] Master '2023-11-05 0:13:11 0 [Note] Added new Master_info '' to hash table
2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master-2023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 0:13:11 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.2023-11-06 15:16:07 12 [ERROR] Master '2023-11-05 0:13:11 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
2023-11-06 15:16:07 7 [Note] Started replication for '2023-11-05 0:13:11 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready 'or connections.
': Slave I/O thread killed while connecting to master3:11 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000013' position: 4
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e28@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@002e28@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] c:\xampp\mysql\bin\mysqld.exe: ready for connections.': master was :3306 12 [Note] Master '2023-11-05 0:13:11 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e28@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2023-11-06 15:16:07 7 [Note] Added new Master_info 'Version: '10.4.28-MariaDB' socket: '' port: 3306 mariadb.org bina' to hash table
2023-11-06 15:16:07 14 [Note] Master 'Version: '10.4.28-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2023-11-06 15:16:07 14 [ERROR] Master 'Version: '10.4.28-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
2023-11-06 15:16:07 7 [Note] Started replication for 'Version: '10.4.28-MariaDB' socket: '' port: 3306 mariadb.org bi'ary distribution
2023-11-06 15:16:07 15 [Note] Master 'Version: '10.4.28-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@002e28@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000013' position: 4
... CUT SOMETHING HERE
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bwarning@005d@0020neither@0020@002d@002drelay@002dlog@0020nor@0020@002d@002drelay@002dlog@002dindex@0020were@0020used@003b@0020so@0020replication@0020may@0020break@0020when@0020this@0020mariadb@0020server@0020acts@0020as@0020a@0020replica@0020and@0020has@0020it.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bwarning@005d@0020neither@0020@002d@002drelay@002dlog@0020nor@0020@002d@002drelay@002dlog@002dindex@0020were@0020used@003b@0020so@0020replication@0020may@0020break@0020when@0020this@0020mariadb@0020server@0020acts@0020as@0020a@0020replica@0020and@0020has@0020it.info'
2023-11-06 15:16:07 16 [Note] Master '2023-11-05 1:15:33 7 [Note] Reading Master_info: 'master.info' Relay_info:'relay': Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bwarning@005d@0020neither@0020@002d@002drelay@002dlog@0020nor@0020@002d@002drelay@002dlog@002dindex@0020were@0020used@003b@0020so@0020replication@0020may@0020break@0020when@0020this@0020mariadb@0020server@0020acts@0020as@0020a@0020replica@0020and@0020has@0020it.info', errno 38)
2023-11-06 15:16:07 16 [Note] Master '2023-11-05 1:15:33 7 [Note] Reading Master_info: 'master.info' Relay_info:'relay': master was :3306
2023-11-06 15:16:07 7 [ERROR] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bwarning@005d@0020neither@0020@002d@002drelay@002dlog@0020nor@0020@002d@002drelay@002dlog@002dindex@0020were@0020used@003b@0020so@0020replication@0020may@0020break@0020when@0020this@0020mariadb@0020server@0020acts@0020as@0020a@0020replica@0020and@0020has@0020it.info' failed
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:33 7 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MariaDB server acts as a replica and has its hostname changed. Please us' to hash table
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002einfo@0027@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002einfo@0027@000d.info'
2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002einfo@0027@000d.info'
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:33 7 [Note] Initialized Master_info from 'master.in' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4m 'master.info'
': 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-11-06 15:16:07 7 [Note] Started replication for '2023-11-05 1:15:33 7 [Note] Initialized Master_info from 'master.'nfo'
': Slave I/O thread killed while connecting to master5:33 7 [Note] Initialized Master_info from 'master.info'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002einfo@0027@000d.000009' position: 4
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Initialized Master_info from 'master.info'
': master was :3306 18 [Note] Master '2023-11-05 1:15:33 7 [Note] Initialized Master_info from 'master.info'
': Error in Log_event::read_log_event(): 'Event truncated', data_len: 824188981, event_type: 45 hash table
2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table6:07 7 [Note] Added new Master_info '2023-11-05 1:15:33 7 [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
2023-11-06 15:16:07 7 [Note] Started replication for '2023-11-05 1:15:33 7 [Note] Added new Master_info '' to hash tabl'
': Slave I/O thread killed while connecting to master5:33 7 [Note] Added new Master_info '' to hash table
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000009' position: 4
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005bnote@005d@0020slave@0020i@002fo@0020thread@003a@0020start@0020asynchronous@0020replication@0020to@0020master@0020@0027@0040@003a3306@0027@0020in@0020log@0020@0027@0027@0020at@0020position@00204@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005bnote@005d@0020slave@0020i@002fo@0020thread@003a@0020start@0020asynchronous@0020replication@0020to@0020master@0020@0027@0040@003a3306@0027@0020in@0020log@0020@0027@0027@0020at@0020position@00204@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Added new Master_info '' to hash table
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005bnote@005d@0020slave@0020i@002fo@0020thread@003a@0020start@0020asynchronous@0020replication@0020to@0020master@0020@0027@0040@003a3306@0027@0020in@0020log@0020@0027@0027@0020at@0020position@00204@000d.info', errno 38)
'
... CUT SOMETHING HERE ...
': Slave I/O thread killed while connecting to master5:33 7 [Note] Started replication for ''
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00209@0020@005bnote@005d@0020slave@0020sql@0020thread@0020initialized@002c@0020starting@0020replication@0020in@0020log@0020@0027first@0027@0020at@0020position@00200@002c@0020relay@0020log@0020@0027@002e@005cmysql@002drelay@002dbin@002e000003@0027@0020position@003a@00204@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a33@00209@0020@005bnote@005d@0020slave@0020sql@0020thread@0020initialized@002c@0020starting@0020replication@0020in@0020log@0020@0027first@0027@0020at@0020position@00200@002c@0020relay@0020log@0020@0027@002e@005cmysql@002drelay@002dbin@002e000003@0027@0020position@003a@00204@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Started replication for ''
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a33@00209@0020@005bnote@005d@0020slave@0020sql@0020thread@0020initialized@002c@0020starting@0020replication@0020in@0020log@0020@0027first@0027@0020at@0020position@00200@002c@0020relay@0020log@0020@0027@002e@005cmysql@002drelay@002dbin@002e000003@0027@0020position@003a@00204@000d.info', errno 38)
': master was :3306 22 [Note] Master '2023-11-05 1:15:33 7 [Note] Started replication for ''
2023-11-06 15:16:07 7 [ERROR] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00209@0020@005bnote@005d@0020slave@0020sql@0020thread@0020initialized@002c@0020starting@0020replication@0020in@0020log@0020@0027first@0027@0020at@0020position@00200@002c@0020relay@0020log@0020@0027@002e@005cmysql@002drelay@002dbin@002e000003@0027@0020position@003a@00204@000d.info' failed
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:33 9 [Note] Slave SQL thread initialized, starting ' to hash tablelog 'FIRST' at position 0, relay log '.\mysql-relay-bin.000003' position: 4
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005berror@005d@0020slave@0020i@002fo@003a@0020fatal@0020error@003a@0020invalid@0020@0028empty@0029@0020username@0020when@0020attempting@0020to@0020connect@0020to@0020the@0020master@0020server@002e@0020connection@0020attempt@0020terminated@002e@0020internal@0020mar.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005berror@005d@0020slave@0020i@002fo@003a@0020fatal@0020error@003a@0020invalid@0020@0028empty@0029@0020username@0020when@0020attempting@0020to@0020connect@0020to@0020the@0020master@0020server@002e@0020connection@0020attempt@0020terminated@002e@0020internal@0020mar.info'
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005berror@005d@0020slave@0020i@002fo@003a@0020fatal@0020error@003a@0020invalid@0020@0028empty@0029@0020username@0020when@0020attempting@0020to@0020connect@0020to@0020the@0020master@0020server@002e@0020connection@0020attempt@0020terminated@002e@0020internal@0020mar.info', errno 38)
2023-11-06 15:16:07 7 [ERROR] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005berror@005d@0020slave@0020i@002fo@003a@0020fatal@0020error@003a@0020invalid@0020@0028empty@0029@0020username@0020when@0020attempting@0020to@0020connect@0020to@0020the@0020master@0020server@002e@0020connection@0020attempt@0020terminated@002e@0020internal@0020mar.info' failed
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:33 8 [ERROR] Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593' to hash table
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002d2023@0040002d11@0040002d05@00400020@004000200@0040003a13@0040003a11@004000200@00400020@0040005bnote@0040005d@00400020added@00400020new@00400020master_info@00400020@00400027@00400027@00400020to@0040.info' R
... CUT SOMETHING HERE ...
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Slave I/O thread killed while connecting to master
': master was :3306 24 [Note] Master '2023-11-05 1:15:33 8 [Note] Slave I/O thread killed while connecting to master
2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005bnote@005d@0020slave@0020i@002fo@0020thread@0020exiting@002c@0020read@0020up@0020to@0020log@0020@0027first@0027@002c@0020position@00204@000d.info'
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:33 8 [Note] Slave I/O thread exiting, read up to lo' to hash tabletion 4
2023-11-06 15:16:07 26 [Note] Master '2023-11-05 1:15:33 8 [Note] Slave I/O thread exiting, read up to log 'FIRST', pos': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2023-11-06 15:16:07 26 [ERROR] Master '2023-11-05 1:15:33 8 [Note] Slave I/O thread exiting, read up to log 'FIRST', po': 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-11-06 15:16:07 7 [Note] Started replication for '2023-11-05 1:15:33 8 [Note] Slave I/O thread exiting, read up to 'og 'FIRST', position 4
2023-11-06 15:16:07 26 [Note] Master '2023-11-05 1:15:33 8 [Note] Slave I/O thread exiting, read up to log 'FIRST', pos': Slave I/O thread killed while connecting to master
2023-11-06 15:16:07 27 [Note] Master '2023-11-05 1:15:33 8 [Note] Slave I/O thread exiting, read up to log 'FIRST', pos': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005bnote@005d@0020slave@0020i@002fo@0020thread@0020exiting@002c@0020read@0020up@0020to@0020log@0020@0027first@0027@002c@0020position@00204@000d.000009' position: 4
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005bnote@005d@0020master@0020was@0020@003a3306@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005bnote@005d@0020master@0020was@0020@003a3306@000d.info'
2023-11-06 15:16:07 26 [Note] Master '2023-11-05 1:15:33 8 [Note] Slave I/O thread exiting, read up to log 'FIRST', pos': Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-11-06 15:16:07 26 [Note] Master '2023-11-05 1:15:33 8 [Note] Slave I/O thread exiting, read up to log 'FIRST', pos': master was :3306
2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005bnote@005d@0020master@0020was@0020@003a3306@000d.info'
' to hash table6:07 7 [Note] Added new Master_info '2023-11-05 1:15:33 8 [Note] master was :3306
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at 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
'023-11-06 15:16:07 7 [Note] Started replication for '2023-11-05 1:15:33 8 [Note] master was :3306
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005bnote@005d@0020master@0020was@0020@003a3306@000d.000009' position: 4
': Slave I/O thread killed while connecting to master5:33 8 [Note] master was :3306
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a34@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002d2023@0040002d11@0040002d05@00400020@004000200@0040003a13@0040003a11@004000200@00400020@0040005bnote@0040005d@00400020added@00400020new@00400020master_info@00400020@00400027@00400027@0040002.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a34@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002d2023@0040002d11@0040002d05@00400020@004000200@0040003a13@0040003a11@004000200@00400020@0040005bnote@0040005d@00400020added@00400020new@00400020master_info@00400020@00400027@00400027@0040002.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] master was :3306
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a34@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002d2023@0040002d11@0040002d05@00400020@004000200@0040003a13@0040003a11@004000200@00400020@0040005bnote@0040005d@00400020added@00400020new@00400020master_info@00400020@00400027@00400027@0040002.info', errno 38)
... CUT SOMETHING HERE ...
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020killed@0020while@0020.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020killed@0020while@0020.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Reading of all Master_info entries succeeded
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020killed@0020while@0020.info', errno 38)
': master was :3306 30 [Note] Master '2023-11-05 1:15:34 0 [Note] Reading of all Master_info entries succeeded
2023-11-06 15:16:07 7 [ERROR] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020killed@0020while@0020.info' failed
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:34 14 [Note] Master 'Version: '10.4.28-MariaDB' so' to hash tableread killed while connecting to master
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a34@00200@0020@005berror@005d@0020adding@0020new@0020entry@0020@0027@0027@0020to@0020master_info@0020failed@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a34@00200@0020@005berror@005d@0020adding@0020new@0020entry@0020@0027@0027@0020to@0020master_info@0020failed@000d.info'
2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a34@00200@0020@005berror@005d@0020adding@0020new@0020entry@0020@0027@0027@0020to@0020master_info@0020failed@000d.info'
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:34 0 [ERROR] Adding new entry '' to master_info fai' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4ter_info 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-11-06 15:16:07 7 [Note] Started replication for '2023-11-05 1:15:34 0 [ERROR] Adding new entry '' to master_info f'iled
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d11@002d05@0020@00201@003a15@003a34@00200@0020@005berror@005d@0020adding@0020new@0020entry@0020@0027@0027@0020to@0020master_info@0020failed@000d.000009' position: 4
': Slave I/O thread killed while connecting to master5:34 0 [ERROR] Adding new entry '' to master_info failed
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4ROR] Adding new entry '' to master_info failed
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002.info', errno 38)
': master was :3306 32 [Note] Master '2023-11-05 1:15:34 0 [ERROR] Adding new entry '' to master_info failed
2023-11-06 15:16:07 7 [ERROR] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002.info' failed
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:34 14 [Note] Master 'Version: '10.4.28-MariaDB' so' to hash tableread exiting, read up to log 'FIRST', position 4
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a34@00200@0020@005berror@005d@0020aborting@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a34@00200@0020@005berror@005d@0020aborting@000d.info'
2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a34@00200@0020@005berror@005d@0020aborting@000d.info'
' to hash table6:07 7 [Note] Added new Master_info '2023-11-05 1:15:34 0 [ERROR] Aborting
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at 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
'023-11-06 15:16:07 7 [Note] Started replication for '2023-11-05 1:15:34 0 [ERROR] Aborting
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d11@002d05@0020@00201@003a15@003a34@00200@0020@005berror@005d@0020aborting@000d.000009' position: 4
': Slave I/O thread killed while connecting to master5:34 0 [ERROR] Aborting
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020master@0020was@0020@003a3306@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020master@0020was@0020@003a3306@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4ROR] Aborting
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020master@0020was@0020@003a3306@000d.info', errno 38)
': master was :3306 34 [Note] Master '2023-11-05 1:15:34 0 [ERROR] Aborting
2023-11-06 15:16:07 7 [ERROR] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020master@0020was@0020@003a3306@000d.info' failed
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:34 14 [Note] Master 'Version: '10.4.28-MariaDB' so' to hash table33066 mariadb.org binary distribution
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002011@0020@005berror@005d@0020master@0020@00272023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020error@0020in@0020log_event@003a@003aread_log_event@0028@0029@003a.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a34@002011@0020@005berror@005d@0020master@0020@00272023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020error@0020in@0020log_event@003a@003aread_log_event@0028@0029@003a.info'
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a34@002011@0020@005berror@005d@0020master@0020@00272023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020error@0020in@0020log_event@003a@003aread_log_event@0028@0029@003a.info', errno 38)
2023-11-06 15:16:07 7 [ERROR] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002011@0020@005berror@005d@0020master@0020@00272023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020error@0020in@0020log_event@003a@003aread_log_event@0028@0029@003a.info' failed
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:34 11 [ERROR] Master '2023-11-05 0:13:11 0 [Note] ': Error in Log_event::read_log_event(): 'Event truncated', data_len: 824188981, even' to hash table
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002011@0020@005berror@005d@0020master@0020@00272023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020error@0020reading@0020relay@0020log@0020event@003a@0020slave@0020sql@0.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a34@002011@0020@005berror@005d@0020master@0020@00272023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020error@0020reading@0020relay@0020log@0020event@003a@0020slave@0020sql@0.info'
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a34@002011@0020@005berror@005d@0020master@0020@00272023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020error@0020reading@0020relay@0020log@0020event@003a@0020slave@0020sql@0.info', errno 38)
2023-11-06 15:16:07 7 [ERROR] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002011@0020@005berror@005d@0020master@0020@00272023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020error@0020reading@0020relay@0020log@0020event@003a@0020slave@0020sql@0.info' failed
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:34 11 [ERROR] Master '2023-11-05 0:13:11 0 [Note] ' to hash tableg relay log event: slave SQL thread aborted because of I/O error
2023-11-06 15:16:07 0 [Warning] Reading of some Master_info entries failed
2023-11-06 15:16:07 0 [ERROR] Failed to initialize multi master structures
2023-11-06 15:16:07 0 [ERROR] Aborting
=============================================================================================================================================================================
Sorry for lengthy log. (Your system only allows 60,000 and this log is over 85,000) NOT sure I cut (eliminated) part of the vital info.
Please, let me know if there a way to obtain more precise information for a solution.
I am really behind in finishing this website project, and I am stuck now!
I read that seems like that none of you use remote services to help, but I do have the Zoom utility where I can create a session and opened (share) to someone who my able to help.
Thank you in advance!