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?
To access phpMyAdmin from XAMPP you will need to make sure you have Apache and MySQL running in the XAMPP control panel by clicking the start buttons under the Actions column. If Apache and MySQL are green then all is well. Then you can click the “Admin” button in the MySQL row and that will launch phpMyAdmin.
I solved this problem by changing the proxy of my firefox browser, go to menu tools-Option find tab Network, click button settings. Fill the text box below No Proxy for with localhost. Then press Ok, then Ok again. Try now typing localhost/xampp then it should show Welcome to XAMPP for Windows!
Try starting MySQL and Apache in Xampp. Verify Port Number assigned to Apache (By default it should be 80). Now load localhost/phpmyadmin . It solved my problem.
If you have MySQL already installed on your windows then go to services. msc file on your windows and right click the MySQL file and stop the service, now open your XAMPP and start MySQL. Now MySQL will start on the port 3306. My MYSQL server on XAMPP was instantly getting stopped.
I have fixed the issue. I copied all files in xampp/mysql/backup/
to xampp/mysql/data/
.
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
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:
AND modify the multi-master.info and delete all its content then save the file.
open the Xampp and run mysql again.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With