Page 1 of 1

I desperately need help. MYSQL won't start :(

PostPosted: 10. November 2016 15:52
by OrdinaryUser
I get this error:
2015-11-10 15:26:56 10fc 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-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete


I've tried changing ports but still no luck. Please help me. I really need this for college :(

Re: I desperately need help. MYSQL won't start :(

PostPosted: 10. November 2016 19:16
by tm01
no idea if this is causing your problem, but:
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.

in my log it says its binding to my localhost IP (127.0.0.1).
search in the my.ini for "bind-address" and set 0.0.0.0 for all IPs or 127.0.0.1 for local connections.
btw: change your system time! its 2016 ;)

Re: I desperately need help. MYSQL won't start :(

PostPosted: 12. November 2016 14:34
by OrdinaryUser
Still did not work :( . I do not know why it even shows that "2015". My system date is always update. I'll try reinstalling my XAMPP...

Re: I desperately need help. MYSQL won't start :(

PostPosted: 12. November 2016 15:02
by OrdinaryUser
tm01 wrote:no idea if this is causing your problem, but:
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.

in my log it says its binding to my localhost IP (127.0.0.1).
search in the my.ini for "bind-address" and set 0.0.0.0 for all IPs or 127.0.0.1 for local connections.
btw: change your system time! its 2016 ;)


Thank you for your help :D. It is working now after reinstalling. It seems that I was too dumb to notice that it specifically said to NOT to install it in C://Program Files(x86)/. Hahaha