Either Apache or MySQL can run

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Either Apache or MySQL can run

Postby jb_Xiaogong » 16. October 2015 08:23

In the beginning I think the ports are blocked so I changed the port in config-Service and Port Settings to different numbers.

However I"m still returned with an error log:

2015-10-16 03:20:41 26976 [Note] Plugin 'FEDERATED' is disabled.
2015-10-16 03:20:41 6964 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-16 03:20:41 26976 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-10-16 03:20:41 26976 [Note] InnoDB: The InnoDB memory heap is disabled
2015-10-16 03:20:41 26976 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-10-16 03:20:41 26976 [Note] InnoDB: Memory barrier is not used
2015-10-16 03:20:41 26976 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-10-16 03:20:41 26976 [Note] InnoDB: Not using CPU crc32 instructions
2015-10-16 03:20:41 26976 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-10-16 03:20:41 26976 [Note] InnoDB: Completed initialization of buffer pool
2015-10-16 03:20:41 26976 [Note] InnoDB: Highest supported file format is Barracuda.
2015-10-16 03:20:41 26976 [Note] InnoDB: 128 rollback segment(s) are active.
2015-10-16 03:20:41 26976 [Note] InnoDB: Waiting for purge to start
2015-10-16 03:20:41 26976 [Note] InnoDB: 5.6.26 started; log sequence number 1665264
2015-10-16 03:20:41 26976 [Note] Server hostname (bind-address): '*'; port: 3306
2015-10-16 03:20:41 26976 [Note] IPv6 is available.
2015-10-16 03:20:41 26976 [Note] - '::' resolves to '::';
2015-10-16 03:20:41 26976 [Note] Server socket created on IP: '::'.
2015-10-16 03:20:41 26976 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2015-10-16 03:20:41 26976 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2015-10-16 03:20:41 26976 [ERROR] Aborting

2015-10-16 03:20:41 26976 [Note] Binlog end
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'partition'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_METRICS'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_CMP'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'INNODB_TRX'
2015-10-16 03:20:41 26976 [Note] Shutting down plugin 'InnoDB'
2015-10-16 03:20:41 26976 [Note] InnoDB: FTS optimize thread exiting.
2015-10-16 03:20:41 26976 [Note] InnoDB: Starting shutdown...
2015-10-16 03:20:43 26976 [Note] InnoDB: Shutdown completed; log sequence number 1665274
2015-10-16 03:20:43 26976 [Note] Shutting down plugin 'BLACKHOLE'
2015-10-16 03:20:43 26976 [Note] Shutting down plugin 'ARCHIVE'
2015-10-16 03:20:43 26976 [Note] Shutting down plugin 'MRG_MYISAM'
2015-10-16 03:20:43 26976 [Note] Shutting down plugin 'MyISAM'
2015-10-16 03:20:43 26976 [Note] Shutting down plugin 'MEMORY'
2015-10-16 03:20:43 26976 [Note] Shutting down plugin 'CSV'
2015-10-16 03:20:43 26976 [Note] Shutting down plugin 'sha256_password'
2015-10-16 03:20:43 26976 [Note] Shutting down plugin 'mysql_old_password'
2015-10-16 03:20:43 26976 [Note] Shutting down plugin 'mysql_native_password'
2015-10-16 03:20:43 26976 [Note] Shutting down plugin 'binlog'
2015-10-16 03:20:43 26976 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

Can someone tell me what I should do next? Xampp used to work on my other computer.
jb_Xiaogong
 
Posts: 1
Joined: 16. October 2015 08:13
Operating System: Windows

Re: Either Apache or MySQL can run

Postby Altrea » 16. October 2015 11:01

Did you change the ports in the config files too?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Either Apache or MySQL can run

Postby Alex R4 » 17. October 2015 04:23

jb_Xiaogong wrote:2015-10-16 03:20:41 26976 [Note] IPv6 is available.
2015-10-16 03:20:41 26976 [Note] - '::' resolves to '::';
2015-10-16 03:20:41 26976 [Note] Server socket created on IP: '::'.
2015-10-16 03:20:41 26976 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory


This looks a bit odd. The double colon is sometimes referred to a local address eg. ::1
Have you looked into your file
Code: Select all
Windows/System32/drivers/etc/hosts

for any problems?
Alex R4
 
Posts: 31
Joined: 08. April 2014 11:24
Location: Adelaide/Australia
Operating System: Windows 7

Re: Either Apache or MySQL can run

Postby Altrea » 17. October 2015 06:57

Alex R4 wrote:This looks a bit odd. The double colon is sometimes referred to a local address eg. ::1

This is absolutely okay here. MySQL binds to both IPv4 and IPv6, That is what is meant by this double colon without any number.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 192 guests