Page 1 of 1

MySQL won't start

PostPosted: 18. October 2015 14:23
by LindaM13
I installed Xampp on my G Partition G:\xampp after several tries on C:/program files (x86) didn’t work. Still can’t get MySQL to work. I’ve tried the advice given to other people, what am I doing wrong?

System and log files as follows.
Windows 7, 64 bit
xampp-win32-5.6.12-0-VC11-installer

Control panel log
13:57:58 [main] Initializing Control Panel
13:57:58 [main] Windows Version: Windows 7 Home Premium SP1 64-bit
13:57:58 [main] XAMPP Version: 5.6.12
13:57:58 [main] Control Panel Version: 3.2.1 [ Compiled: May 7th 2013 ]
13:57:58 [main] Running with Administrator rights - good!
13:57:58 [main] XAMPP Installation Directory: "g:\xampp\"
13:57:58 [main] Checking for prerequisites
13:57:58 [main] All prerequisites found
13:57:58 [main] Initializing Modules
13:57:58 [Apache] XAMPP Apache is already running on port 80
13:57:58 [Apache] XAMPP Apache is already running on port 443
13:57:58 [main] Starting Check-Timer
13:57:58 [main] Control Panel Ready
13:58:19 [mysql] Attempting to start MySQL app...
13:58:21 [mysql] Status change detected: running

Apache shows a green tick and MySQL has a red cross under Module services
MySQL shows 3872 under PID(s) and 3306 under Port(s)
Skype is not running

MySQL Error log
2015-10-18 13:58:22 3872 [Note] Plugin 'FEDERATED' is disabled.
2015-10-18 13:58:22 1bc0 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.
2015-10-18 13:58:22 3872 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-10-18 13:58:22 3872 [Note] InnoDB: The InnoDB memory heap is disabled
2015-10-18 13:58:22 3872 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-10-18 13:58:22 3872 [Note] InnoDB: Memory barrier is not used
2015-10-18 13:58:22 3872 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-10-18 13:58:22 3872 [Note] InnoDB: Not using CPU crc32 instructions
2015-10-18 13:58:22 3872 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-10-18 13:58:22 3872 [Note] InnoDB: Completed initialization of buffer pool
2015-10-18 13:58:22 3872 [Note] InnoDB: Highest supported file format is Barracuda.
2015-10-18 13:58:22 3872 [Note] InnoDB: 128 rollback segment(s) are active.
2015-10-18 13:58:22 3872 [Note] InnoDB: Waiting for purge to start
2015-10-18 13:58:23 3872 [Note] InnoDB: 5.6.26 started; log sequence number 1665234
2015-10-18 13:58:23 3872 [Note] Server hostname (bind-address): '*'; port: 3306
2015-10-18 13:58:23 3872 [Note] IPv6 is available.
2015-10-18 13:58:23 3872 [Note] - '::' resolves to '::';
2015-10-18 13:58:23 3872 [Note] Server socket created on IP: '::'.
2015-10-18 13:58:23 3872 [Note] Event Scheduler: Loaded 0 events
2015-10-18 13:58:23 3872 [Note] g:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.26' socket: '' port: 3306 MySQL Community Server (GPL)

Re: MySQL won't start

PostPosted: 18. October 2015 14:55
by Altrea
LindaM13 wrote:13:58:21 [mysql] Status change detected: running

Apache shows a green tick and MySQL has a red cross under Module services
MySQL shows 3872 under PID(s) and 3306 under Port(s)



LindaM13 wrote:2015-10-18 13:58:23 3872 [Note] Server hostname (bind-address): '*'; port: 3306
2015-10-18 13:58:23 3872 [Note] IPv6 is available.
2015-10-18 13:58:23 3872 [Note] - '::' resolves to '::';
2015-10-18 13:58:23 3872 [Note] Server socket created on IP: '::'.
2015-10-18 13:58:23 3872 [Note] Event Scheduler: Loaded 0 events
2015-10-18 13:58:23 3872 [Note] g:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.26' socket: '' port: 3306 MySQL Community Server (GPL)

I would say MySQL IS started.
The red cross just means that you have not registered a windows service for this app, which is absolutely okay.
You can start and use the apps without any windows services.

Re: MySQL won't start

PostPosted: 18. October 2015 15:55
by LindaM13
Many thanks for your quick reply.