'How to solve "Error: MySQL shutdown unexpectedly"? Tried All solutions posted solutions
I tried to start up my DB like every day for the past month, not in admin mode, I was going through some final work and i can't get on anymore, I have looked and tried the solutions already listed, but none seemed to work. I noticed that I am now getting a Warning: Memory not freed: 16864 could this be my issue?
I am getting this error Error:
MySQL shutdown unexpectedly.
9:22:45 AM [mysql] This may be due to a blocked port, missing dependencies,
9:22:45 AM [mysql] improper privileges, a crash, or a shutdown by another method.
9:22:45 AM [mysql] Press the Logs button to view error logs and check
9:22:45 AM [mysql] the Windows Event Viewer for more clues
9:22:45 AM [mysql] If you need more help, copy and post this
9:22:45 AM [mysql] entire log window on the forums
I have tried renaming my data files from the backups, changing the port numbers and running in administrator. All three didn't work.
This is the mysqlerror log:
2022-03-31 9:22:38 19 [Note] Master '2022-03-31 9:07:21 10 [Warning] Access denied for user 'JGadmin'@'localhost' (using password: YES)
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2022@002d03@002d31@0020@00209@003a07@003a21@002010@0020@005bwarning@005d@0020access@0020denied@0020for@0020user@0020@0027jgadmin@0027@0040@0027localhost@0027@0020@0028using@0020password@003a@0020yes@[email protected]' position: 4
2022-03-31 9:22:38 18 [ERROR] Master '2022-03-31 9:07:21 10 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2022-03-31 9:22:38 0 [Warning] Reading of some Master_info entries failed
2022-03-31 9:22:38 18 [Note] Master '2022-03-31 9:07:21 10 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
': Slave I/O thread killed while connecting to master
2022-03-31 9:22:38 0 [ERROR] Failed to initialize multi master structures
2022-03-31 9:22:38 18 [Note] Master '2022-03-31 9:07:21 10 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2022-03-31 9:22:38 0 [ERROR] Aborting
2022-03-31 9:22:38 18 [Note] Master '2022-03-31 9:07:21 10 [Warning] Access denied for user 'admin'@'localhost' (using password: YES)
': master was :3306
Warning: Memory not freed: 16864
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
