Mysql database status still remianed deactivated. 'MySQL could not be started' for this i did do the second bullet but it didnt work for me. Please use -explicitdefaultsfortimestamp server option MySQL could not be started. Warning TIMESTAMP with implicit DEFAULT value is deprecated. MySQL is starting with mysql bin my.ini Warning Using unique option prefix keybuffer instead of keybuffersize is deprecated and will be removed in future release. For the answer below the best answer i did run mysqlstart.bat: MySQL is trying to start Please wait. Version: '5.6.20' socket: ' port: 3306 MySQL Community Server (GPL) so port is 3306. 11:8 Note Event Scheduler: Loaded 0 events 11:8 Note C: xampp mysql bin mysqld.exe: ready for connections. 11:8 Note - '::' resolves to '::' 11:8 Note Server socket created on IP: '::'. Localhost/phpmyadmin shows exclamation marks on the databases and 'x' on the server connection collation.įor this i did check mysqlerror.log as suggested by best answer: 11:8 Note InnoDB: 5.6.20 started log sequence number 16-08-27 11:8 Note Server hostname (bind-address): '.' port: 3306 11:8 Note IPv6 is available. Localhost/xampp status page shows mysql database: deactivated. Xampp control panel: I have apache and mysql service modules ticked. I wanted to post pictures which would help in visualizing what is going on but I can't so I will try my best to explain.

Yes, I know this question has been asked and answered a dozen times but I have searched and tried all that was suggested and uninstalled and reinstalled like 4 times and still haven't gotten any closer to activating mysql database. Downloads for Linux and Solaris are available at the developer's website.

XAMPP is really very easy to install and to use - just download, extract and start. XAMPP is an easy to install Apache distribution containing MySQL, PHP and Perl. Mahara Collaboration Mautic Marketing Automation MyBB Forum OrangeHRM Human Resource Management OpenCart e-Commerce XAMPP Add-ons. 12:31:31 AM Status change detected: running. 12:31:31 AM or reconfigure Apache and the Control Panel to listen on a different port 12:31:31 AM Attempting to start Apache app.

Xampp control panel v3.2.1