xampp mysql and phpmyadmin dont work

Question

yesterday i worked with my xampp and i used apache and mysql services. Today i want to start mysql service and did not worked. I try to search on forums a solution but i cant find anything, so i ask you.

In the log file i find this message after the mysql stopped working:

2015-10-29 12:04:02 148c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
151029 12:04:02 [Note] InnoDB: Using mutexes to ref count buffer pool pages
151029 12:04:02 [Note] InnoDB: The InnoDB memory heap is disabled
151029 12:04:02 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
151029 12:04:02 [Note] InnoDB: Memory barrier is not used
151029 12:04:02 [Note] InnoDB: Compressed tables use zlib 1.2.3
151029 12:04:02 [Note] InnoDB: Not using CPU crc32 instructions
151029 12:04:02 [Note] InnoDB: Initializing buffer pool, size = 16.0M
151029 12:04:02 [Note] InnoDB: Completed initialization of buffer pool
151029 12:04:02 [Note] InnoDB: Highest supported file format is Barracuda.
2015-10-29 12:04:02 148c  InnoDB: Operating system error number 2 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
151029 12:04:02 [ERROR] InnoDB: Could not find a valid tablespace file for 'mysql/innodb_index_stats'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
151029 12:04:02 [ERROR] InnoDB: Tablespace open failed for '"mysql"."innodb_index_stats"', ignored.
151029 12:04:02 [Note] InnoDB: 128 rollback segment(s) are active.
151029 12:04:02 [Note] InnoDB: Waiting for purge to start
151029 12:04:02 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 1665234
151029 12:04:02 [Note] Plugin 'FEEDBACK' is disabled.
151029 12:04:02 [Note] Server socket created on IP: '::'.
151029 12:04:02 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
151029 12:04:02 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed

Can you help me fix this issue?

Check it please http://stackoverflow.com/questions/9782451/mysql-in-xampp-starts-and-stops-in-five-seconds — CodeLove, Oct 29 '15 at 11:17

score 141 · Accepted Answer · edited Dec 30 '21 at 21:43

141

I have fixed the issue. I copied all files in xampp/mysql/backup/ to xampp/mysql/data/.

edited Dec 30 '21 at 21:43

answered Oct 29 '15 at 11:39

Francis

1,775
2
12
15

This worked for me also. Could you help me to understand how it worked? – bhanushalimahesh3 May 19 '20 at 11:24
its worked, but I have to make some configuration to make phpmyadmin work – Angrej Kumar Oct 14 '20 at 08:13
@AngrejKumar can you elaborate a bit more on what further configuration you have made? – sehrish Feb 18 '21 at 10:13
Can you explain the cause of this issue? – Ahmed Alhallag Mar 16 '21 at 12:59
4

I'm now getting a new error 'Table doesn't exist in engine'. Does anyone know how to solve this? – ishan shah Aug 12 '21 at 14:41
Occured on XAMPP v3.3.0, fixed with this solution – Tithira Oct 05 '21 at 05:10
Worked for me also - After a brand new install of XAMPP Version: 8.1.12 and an upgrade to phpmyadmin 5.2.1, before creating any databases, I clicked on the "User Accounts" tab and got a message indicating 'db' was corrupt. This fixed it! Thanx. – FeralReason Apr 03 '23 at 20:51

score 17 · Answer 2 · edited Aug 27 '20 at 21:47

17

I had this similar issue today and was able to solve it by:

Close the XAMPP control panel
delete the following files under /xampp/mysql/data:
- aria_log.**1
- aria_log_control
- ib_logfile0
- ib_logfile1
- ibdata1
- ibtmp1
- mysqld.pid
AND modify the multi-master.info and delete all its content then save the file.
open the Xampp and run mysql again.

edited Aug 27 '20 at 21:47

Dharman

30,962
25
85
135

answered Aug 27 '20 at 19:59

mCube

334
3
8

This worked for me! but, i not have files: ibtmp1 and mysqld.pid, just delete others and ok, it's work! – JassRiver Apr 16 '21 at 23:02
MySQL started but I'm getting this error now: Table 'phpmyadmin.pma__tracking' doesn't exist in engine. Any idea? – ishan shah Aug 12 '21 at 14:46
3

Don't do this as deleting the ibdata1 means no recovery for all your data – Emmanuel David Feb 13 '22 at 06:59

score 9 · Answer 3 · answered May 19 '20 at 08:47

9

As additional to the correct answer, you don't need to delete all the files inside xampp/mysql/data/, just replace with whatever inside xampp/mysql/backup/ will do. Cheers

answered May 19 '20 at 08:47

Greyson Yee

156
3
11

xampp mysql and phpmyadmin dont work

3 Answers3

Linked