mysql error help!

Problems with the Windows version of XAMPP, questions, comments, and anything related.

mysql error help!

Postby Mada » 14. June 2020 09:25

InnoDB: using atomic writes.
2020-06-14 9:02:26 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-14 9:02:26 0 [Note] InnoDB: Uses event mutexes
2020-06-14 9:02:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-14 9:02:26 0 [Note] InnoDB: Number of pools: 1
2020-06-14 9:02:26 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-14 9:02:26 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-14 9:02:26 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-14 9:02:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-14 9:02:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-14 9:02:26 0 [Note] InnoDB: Setting file 'C:\Users\HP\Documents\SITENOVO\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-14 9:02:26 0 [Note] InnoDB: File 'C:\Users\HP\Documents\SITENOVO\mysql\data\ibtmp1' size is now 12 MB.
2020-06-14 9:02:26 0 [Note] InnoDB: Waiting for purge to start
2020-06-14 9:02:26 0 [Note] InnoDB: 10.4.11 started; log sequence number 73966539; transaction id 60785
2020-06-14 9:02:26 0 [Note] InnoDB: Loading buffer pool(s) from C:\Users\HP\Documents\SITENOVO\mysql\data\ib_buffer_pool
2020-06-14 9:02:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-14 9:02:26 0 [Note] Server socket created on IP: '::'.
Mada
 
Posts: 6
Joined: 14. June 2020 09:23
XAMPP version: v3.2.4
Operating System: windows

Re: mysql error help!

Postby Altrea » 14. June 2020 09:54

I don't see an error in this log!?
Maybe you should try again to describe your problem more precisely.
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: 11942
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: mysql error help!

Postby Mada » 14. June 2020 10:04

09:48:25 [mysql] Attempting to start MySQL app...
09:48:25 [mysql] Status change detected: running
09:48:31 [mysql] Status change detected: stopped
09:48:31 [mysql] Error: MySQL shutdown unexpectedly.
09:48:31 [mysql] This may be due to a blocked port, missing dependencies,
09:48:31 [mysql] improper privileges, a crash, or a shutdown by another method.
09:48:31 [mysql] Press the Logs button to view error logs and check
09:48:31 [mysql] the Windows Event Viewer for more clues
09:48:31 [mysql] If you need more help, copy and post this
09:48:31 [mysql] entire log window on the forums
Mada
 
Posts: 6
Joined: 14. June 2020 09:23
XAMPP version: v3.2.4
Operating System: windows

Re: mysql error help!

Postby Mada » 14. June 2020 10:05

my squl doesnt start.. i didn´t do anything
Mada
 
Posts: 6
Joined: 14. June 2020 09:23
XAMPP version: v3.2.4
Operating System: windows

Re: mysql error help!

Postby Altrea » 14. June 2020 10:11

Please try to start MariaDB that way and report back, what you get as response:

  • Open your XAMPP control panel
  • click the Shell Button. If you get asked to create the file for the first time, confirm this.
  • Execute the following command
    Code: Select all
    mysqld --defaults-file=mysql\bin\my.ini --standalone --console
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: 11942
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: mysql error help!

Postby Mada » 14. June 2020 10:23

does it delete my data? i allready created a lot on wordpress..
will it delete?
i have no backup
Mada
 
Posts: 6
Joined: 14. June 2020 09:23
XAMPP version: v3.2.4
Operating System: windows

Re: mysql error help!

Postby Altrea » 14. June 2020 11:28

No, if you strictly follow these instructions, these files do not contain any important database data.
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: 11942
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: mysql error help!

Postby Mada » 14. June 2020 11:43

Setting environment for using XAMPP for Windows.
HP@DESKTOP-0BMUGN0 c:\users\hp\documents\sitenovo
# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2020-06-14 11:43:47 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.
2020-06-14 11:43:47 0 [Note] mysqld (mysqld 10.4.11-MariaDB) starting as process 5160 ...
InnoDB: using atomic writes.
2020-06-14 11:43:47 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-14 11:43:47 0 [Note] InnoDB: Uses event mutexes
2020-06-14 11:43:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-14 11:43:47 0 [Note] InnoDB: Number of pools: 1
2020-06-14 11:43:47 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-14 11:43:47 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-14 11:43:47 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-14 11:43:49 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-14 11:43:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-14 11:43:49 0 [Note] InnoDB: Setting file 'C:\Users\HP\Documents\SITENOVO\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-14 11:43:49 0 [Note] InnoDB: File 'C:\Users\HP\Documents\SITENOVO\mysql\data\ibtmp1' size is now 12 MB.
2020-06-14 11:43:49 0 [Note] InnoDB: 10.4.11 started; log sequence number 73966663; transaction id 60785
2020-06-14 11:43:49 0 [Note] InnoDB: Loading buffer pool(s) from C:\Users\HP\Documents\SITENOVO\mysql\data\ib_buffer_pool
2020-06-14 11:43:49 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-14 11:43:49 0 [Note] Server socket created on IP: '::'.
2020-06-14 11:43:49 0 [Note] InnoDB: Buffer pool(s) load completed at 200614 11:43:49
2020-06-14 11:43:49 7 [Note] Reading Master_info: 'master-2020@002d06@002d13@0020@00207@003a47@003a17@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2020@002d06@002d13@0020@00207@003a47@003a17@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2020-06-14 11:43:49 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.
2020-06-14 11:43:49 7 [Note] Initialized Master_info from 'master-2020@002d06@002d13@0020@00207@003a47@003a17@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2020-06-14 11:43:49 7 [Note] Added new Master_info '2020-06-13 7:47:17 0 [Note] Reading of all Master_info entries succ' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4ntries succeeded
2020-06-14 11:43:49 7 [Note] Started replication for '2020-06-13 7:47:17 0 [Note] Reading of all Master_info entries su'ceeded
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2020@002d06@002d13@0020@00207@003a47@003a17@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000020' 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
2020-06-14 11:43:49 7 [Note] Reading Master_info: 'master-2020@002d06@002d13@0020@00207@003a47@003a17@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2020@002d06@002d13@0020@00207@003a47@003a17@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
': Slave I/O thread killed while connecting to master:17 0 [Note] Reading of all Master_info entries succeeded
': Slave I/O thread exiting, read up to log 'FIRST', position 4e] Reading of all Master_info entries succeeded
2020-06-14 11:43:50 7 [Note] Initialized Master_info from 'master-2020@002d06@002d13@0020@00207@003a47@003a17@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table3:50 7 [Note] Added new Master_info '2020-06-13 7:47:17 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
2020-06-14 11:43:50 7 [Note] Started replication for '2020-06-13 7:47:17 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-2020@002d06@002d13@0020@00207@003a47@003a17@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000020' 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
2020-06-14 11:43:50 7 [Note] Reading Master_info: 'master-2020@002d06@002d13@0020@00207@003a47@003a17@00200@0020@005bnote@005d@0020c@003a@005cusers@005chp@005cdocuments@005csitenovo@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2020@002d06@002d13@0020@00207@003a47@003a17@00200@0020@005bnote@005d@0020c@003a@005cusers@005chp@005cdocuments@005csitenovo@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
': Slave I/O thread killed while connecting to master7:17 0 [Note] Added new Master_info '' to hash table
2020-06-14 11:43:50 7 [ERROR] Failed to create a new master info file (file 'C:\Users\HP\Documents\SITENOVO\mysql\data\master-2020@002d06@002d13@0020@00207@003a47@003a17@00200@0020@005bnote@005d@0020c@003a@005cusers@005chp@005cdocuments@005csitenovo@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info', errno 2)
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Added new Master_info '' to hash table
2020-06-14 11:43:50 7 [ERROR] Initialized Master_info from 'master-2020@002d06@002d13@0020@00207@003a47@003a17@00200@0020@005bnote@005d@0020c@003a@005cusers@005chp@005cdocuments@005csitenovo@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' failed
2020-06-14 11:43:50 7 [Note] Added new Master_info '2020-06-13 7:47:17 0 [Note] c:\users\hp\documents\sitenovo\mysql\bi' to hash tableeady for connections.
2020-06-14 11:43:50 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e11@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@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2020-06-14 11:43:50 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2020-06-14 11:43:50 7 [Note] Added new Master_info 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org bina' to hash table
2020-06-14 11:43:50 12 [Note] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-06-14 11:43:50 7 [Note] Started replication for 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org bi'ary distribution
2020-06-14 11:43:50 13 [Note] Master 'Version: '10.4.11-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@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000020' position: 4
2020-06-14 11:43:50 12 [ERROR] Master 'Version: '10.4.11-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
2020-06-14 11:43:50 7 [Note] Reading Master_info: 'master-2020@002d06@002d13@0020@00207@003a48@003a55@00209@0020@005bnote@005d@0020detected@0020table@0020cache@0020mutex@0020contention@0020at@0020instance@00201@003a@002030@0025@0020waits@002e@0020additional@0020table@0020cache@0020instance@0020activated@002e@0020number@0020of@0020instances@0020after@0020activation@003a@00202@002e@000d.info' Relay_info:'relay-log-2020@002d06@002d13@0020@00207@003a48@003a55@00209@0020@005bnote@005d@0020detected@0020table@0020cache@0020mutex@0020contention@0020at@0020instance@00201@003a@002030@0025@0020waits@002e@0020additional@0020table@0020cache@0020instance@0020activated@002e@0020number@0020of@0020instances@0020after@0020activation@003a@00202@002e@000d.info'
2020-06-14 11:43:50 12 [Note] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread killed while connecting to master
2020-06-14 11:43:50 7 [ERROR] Failed to create a new master info file (file 'C:\Users\HP\Documents\SITENOVO\mysql\data\master-2020@002d06@002d13@0020@00207@003a48@003a55@00209@0020@005bnote@005d@0020detected@0020table@0020cache@0020mutex@0020contention@0020at@0020instance@00201@003a@002030@0025@0020waits@002e@0020additional@0020table@0020cache@0020instance@0020activated@002e@0020number@0020of@0020instances@0020after@0020activation@003a@00202@002e@000d.info', errno 2)
2020-06-14 11:43:50 12 [Note] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-06-14 11:43:50 7 [ERROR] Initialized Master_info from 'master-2020@002d06@002d13@0020@00207@003a48@003a55@00209@0020@005bnote@005d@0020detected@0020table@0020cache@0020mutex@0020contention@0020at@0020instance@00201@003a@002030@0025@0020waits@002e@0020additional@0020table@0020cache@0020instance@0020activated@002e@0020number@0020of@0020instances@0020after@0020activation@003a@00202@002e@000d.info' failed
2020-06-14 11:43:50 7 [Note] Added new Master_info '2020-06-13 7:48:55 9 [Note] Detected table cache mutex contention a' to hash table0% waits. Additional table cache instance activated. Number of instances after activation: 2.
2020-06-14 11:43:50 0 [Warning] Reading of some Master_info entries failed
2020-06-14 11:43:50 0 [ERROR] Failed to initialize multi master structures
2020-06-14 11:43:50 0 [ERROR] Aborting

HP@DESKTOP-0BMUGN0 c:\users\hp\documents\sitenovo
#
Mada
 
Posts: 6
Joined: 14. June 2020 09:23
XAMPP version: v3.2.4
Operating System: windows

Re: mysql error help!

Postby Altrea » 14. June 2020 12:12

Please try the following workaround:

Open your folder "\xampp\mysql\data"
Delete all files beginning with "master-"
Delete all files beginning with "mysql_relay-bin-"
Delete all files beginning with "relay-log-"
Delete all files beginning with "ib_logfile"
Delete all files beginning with "aria_log."

Now try to start MariaDB again as regular.
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: 11942
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: mysql error help!

Postby Mada » 14. June 2020 12:27

ih, it still says that has an error
Mada
 
Posts: 6
Joined: 14. June 2020 09:23
XAMPP version: v3.2.4
Operating System: windows

Re: mysql error help!

Postby Altrea » 15. June 2020 21:15

Ok, so what files are left in your \xampp\mysql\data\ folder?
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: 11942
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: mysql error help!

Postby kubegus » 18. June 2020 09:59

Hi!

I have the same problem. I tried your advices, but the problem still.

I can run Apache, but not MySQL

After delete the files you indicated, I got:

ibdata1
multi-master.info
my.ini
mysql_error.log



cheers!
kubegus
 
Posts: 5
Joined: 18. June 2020 09:33
XAMPP version: v3.2.4
Operating System: windows 10

Re: mysql error help!

Postby Altrea » 18. June 2020 10:36

Delete the file multi-master.info

What is the output of running mysqld in console like described earlier after this?
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: 11942
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: mysql error help!

Postby kubegus » 18. June 2020 10:55

I think is the same message than Mada...





# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2020-06-18 11:53:25 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.
2020-06-18 11:53:25 0 [Note] mysqld (mysqld 10.4.11-MariaDB) starting as process 13404 ...
InnoDB: using atomic writes.
2020-06-18 11:53:25 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-18 11:53:25 0 [Note] InnoDB: Uses event mutexes
2020-06-18 11:53:25 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-18 11:53:25 0 [Note] InnoDB: Number of pools: 1
2020-06-18 11:53:25 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-18 11:53:25 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-06-18 11:53:25 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-18 11:53:25 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-18 11:53:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-18 11:53:25 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-18 11:53:25 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-06-18 11:53:25 0 [Note] InnoDB: Waiting for purge to start
2020-06-18 11:53:25 0 [Note] InnoDB: 10.4.11 started; log sequence number 623125; transaction id 680
2020-06-18 11:53:25 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2020-06-18 11:53:25 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-18 11:53:25 0 [Note] InnoDB: Buffer pool(s) load completed at 200618 11:53:25
2020-06-18 11:53:25 0 [Note] Server socket created on IP: '::'.
2020-06-18 11:53:25 7 [Note] Reading Master_info: 'master-2020@002d06@002d17@002012@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2020@002d06@002d17@002012@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2020-06-18 11:53:25 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.
2020-06-18 11:53:25 7 [Note] Initialized Master_info from 'master-2020@002d06@002d17@002012@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2020-06-18 11:53:25 7 [Note] Added new Master_info '2020-06-17 12:22:24 0 [Note] Reading of all Master_info entries succ' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4ntries succeeded
2020-06-18 11:53:25 7 [Note] Started replication for '2020-06-17 12:22:24 0 [Note] Reading of all Master_info entries su'ceeded
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2020@002d06@002d17@002012@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000001' 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
2020-06-18 11:53:25 7 [Note] Reading Master_info: 'master-2020@002d06@002d17@002012@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2020@002d06@002d17@002012@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
': Slave I/O thread killed while connecting to master:24 0 [Note] Reading of all Master_info entries succeeded
': Slave I/O thread exiting, read up to log 'FIRST', position 4e] Reading of all Master_info entries succeeded
2020-06-18 11:53:25 7 [Note] Initialized Master_info from 'master-2020@002d06@002d17@002012@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table3:25 7 [Note] Added new Master_info '2020-06-17 12:22:24 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
2020-06-18 11:53:25 7 [Note] Started replication for '2020-06-17 12:22:24 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-2020@002d06@002d17@002012@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000001' 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
2020-06-18 11:53:25 7 [Note] Reading Master_info: 'master-2020@002d06@002d17@002012@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2020@002d06@002d17@002012@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
': Slave I/O thread killed while connecting to master2:24 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
2020-06-18 11:53:26 7 [Note] Initialized Master_info from 'master-2020@002d06@002d17@002012@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2020-06-18 11:53:26 7 [Note] Added new Master_info '2020-06-17 12:22:24 0 [Note] d:\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.
2020-06-18 11:53:26 7 [Note] Started replication for '2020-06-17 12:22:24 0 [Note] d:\xampp\mysql\bin\mysqld.exe: ready 'or connections.
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2020@002d06@002d17@002012@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000001' position: 4
2020-06-18 11:53:26 12 [ERROR] Master '2020-06-17 12:22:24 0 [Note] d:\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
2020-06-18 11:53:26 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e11@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@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
': Slave I/O thread killed while connecting to master2:24 0 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
2020-06-18 11:53:26 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2020-06-18 11:53:26 7 [Note] Added new Master_info 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org bina' to hash table
2020-06-18 11:53:26 14 [Note] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-06-18 11:53:26 7 [Note] Started replication for 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org bi'ary distribution
2020-06-18 11:53:26 15 [Note] Master 'Version: '10.4.11-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@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000001' position: 4
2020-06-18 11:53:26 14 [ERROR] Master 'Version: '10.4.11-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
2020-06-18 11:53:26 7 [Note] Reading Master_info: 'master-2020@002d06@002d17@002012@003a52@003a48@002047@0020@005bwarning@005d@0020aborted@0020connection@002047@0020to@0020db@003a@0020@0027ejercicios_java@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' Relay_info:'relay-log-2020@002d06@002d17@002012@003a52@003a48@002047@0020@005bwarning@005d@0020aborted@0020connection@002047@0020to@0020db@003a@0020@0027ejercicios_java@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info'
2020-06-18 11:53:26 14 [Note] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread killed while connecting to master
2020-06-18 11:53:26 7 [ERROR] Failed to create a new master info file (file 'D:\xampp\mysql\data\master-2020@002d06@002d17@002012@003a52@003a48@002047@0020@005bwarning@005d@0020aborted@0020connection@002047@0020to@0020db@003a@0020@0027ejercicios_java@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info', errno 2)
2020-06-18 11:53:26 14 [Note] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-06-18 11:53:26 7 [ERROR] Initialized Master_info from 'master-2020@002d06@002d17@002012@003a52@003a48@002047@0020@005bwarning@005d@0020aborted@0020connection@002047@0020to@0020db@003a@0020@0027ejercicios_java@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' failed
2020-06-18 11:53:26 7 [Note] Added new Master_info '2020-06-17 12:52:48 47 [Warning] Aborted connection 47 to db: 'ejerc' to hash tabler: 'root' host: 'localhost' (Got an error reading communication packets)
2020-06-18 11:53:26 0 [Warning] Reading of some Master_info entries failed
2020-06-18 11:53:26 0 [ERROR] Failed to initialize multi master structures
2020-06-18 11:53:26 0 [ERROR] Aborting
kubegus
 
Posts: 5
Joined: 18. June 2020 09:33
XAMPP version: v3.2.4
Operating System: windows 10

Re: mysql error help!

Postby kubegus » 18. June 2020 17:18

I have reinstalled the new version and it works.
kubegus
 
Posts: 5
Joined: 18. June 2020 09:33
XAMPP version: v3.2.4
Operating System: windows 10

Next

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 121 guests