MySQL loading error

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

MySQL loading error

Postby Petes2021 » 04. December 2019 21:24

Hello I've been trying to fix this error for the past couple days, hopefully you can help me the error occurred after entering 'skip-grant-tables' into the my.ini file in the [mysqld] section.

I'm using XAMPP version 7.1.32 and mysql (mariadb) stopped functioning, now it doesn't load, the error I get is this one:

Error: MySQL shutdown unexpectedly.
This may be due to a blocked port, missing dependencies,
improper privileges, a crash, or a shutdown by another method.
Press the Logs button to view error logs and check
the Windows Event Viewer for more clues
If you need more help, copy and post this
entire log window on the forums


I have tried changing the port to 3307, deleting the ib_logfile files and many many other things, the error log says this:

InnoDB: using atomic writes.
2019-12-04 13:57:06 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-12-04 13:57:06 0 [Note] InnoDB: Uses event mutexes
2019-12-04 13:57:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-04 13:57:06 0 [Note] InnoDB: Number of pools: 1
2019-12-04 13:57:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-12-04 13:57:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-12-04 13:57:06 0 [Note] InnoDB: Completed initialization of buffer pool
2019-12-04 13:57:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-12-04 13:57:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-12-04 13:57:06 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-12-04 13:57:06 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-12-04 13:57:06 0 [Note] InnoDB: Waiting for purge to start
2019-12-04 13:57:06 0 [Note] InnoDB: 10.4.6 started; log sequence number 114043; transaction id 9
2019-12-04 13:57:06 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-12-04 13:57:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-12-04 13:57:06 0 [Note] InnoDB: Buffer pool(s) load completed at 191204 13:57:06
2019-12-04 13:57:06 0 [Note] Server socket created on IP: '::'.
Petes2021
 
Posts: 3
Joined: 04. December 2019 21:13
XAMPP version: 7.1.32
Operating System: Windows

Re: MySQL loading error

Postby Petes2021 » 05. December 2019 17:13

Here are some errors from Windows Event Viewer


Slave I/O: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist in engine, Internal MariaDB error code: 1932

Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593

Failed to initialize multi master structures

Slave SQL: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist in engine, Internal MariaDB error code: 1932

Initialized Master_info from 'master-2019@002d12@002d02@002014@003a29@003a09@002014@0020@005bnote@005d@0020master@0020@00272019@002d11@002d04@0020@00208@003a37@003a10@00200@0020@005bnote@005d@0020innodb@003a@0020buffer@0020pool@0028s@0029@0020load@0020completed@0020at@0020191104@0020@00208@003a37@003a10@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exi.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

Slave SQL: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist in engine, Internal MariaDB error code: 1932

Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2019@002d12@002d02@002014@003a29@003a09@002014@0020@005bnote@005d@0020master@0020@00272019@002d11@002d04@0020@00208@003a37@003a10@00200@0020@005bnote@005d@0020innodb@003a@0020buffer@0020pool@0028s@0029@0020load@0020completed@0020at@0020191104@0020@00208@003a37@003a10@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exi.info', errno 2)

Slave SQL: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist in engine, Internal MariaDB error code: 1932
Petes2021
 
Posts: 3
Joined: 04. December 2019 21:13
XAMPP version: 7.1.32
Operating System: Windows

Re: MySQL loading error

Postby Petes2021 » 06. December 2019 19:40

Nevermind, I managed to repair the database, anyone with this issue, I had to reinstall xampp, then I replaced the ibdata1 file with the original one, then placed my database folder inside mysql/data.
Petes2021
 
Posts: 3
Joined: 04. December 2019 21:13
XAMPP version: 7.1.32
Operating System: Windows

Re: MySQL loading error

Postby storman » 10. March 2020 16:25

thanks, needed this tip

Using latest XAMPP version

https://www.apachefriends.org/download_success.html
Image
storman
 
Posts: 5
Joined: 06. March 2020 18:58
XAMPP version: 3.2.4
Operating System: Windows 10 64 bit

Re: MySQL loading error

Postby chadreitsma » 28. June 2021 05:00

I didn't need to re-install (thankfully)

I did this to fix it on my Win10 machine

1. Removed the files (NOT THE FOLDERS) in /xampp/mysql/data/
2. Copied the files (NOT THE FOLDERS) in: /xampp/mysql/backup/ To: /xampp/mysql/data/
3. Started MYSQL from the Xampp control panel.
chadreitsma
 
Posts: 5
Joined: 28. June 2021 04:54
XAMPP version: 7.4.7
Operating System: Windows7 Pro x64


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 6 guests