title: XAMPP Server Error: MySQL shutdown unexpectedly
body: <p>Not sure what exactly is causing this error and how to rectify the same. I suppose it's because of a port conflict or running multiple instance of mysqld, but not sure how to prevent (whichever) application from using up the port.</p>
  
  <p>When I checked netstat(XAMPP) it shows port 3306 is used by mysqld.exe(should I free up that port? <strong>if so how to?</strong>)</p>
  
  <p>OR</p>
  
  <p>Do changing the MYSQl port work to resolve this error? if so how to?</p>
  
  <p><strong>Note:</strong> This is a guest PC, so not sure what all applications are already installed in this system, or how the system is configured previously.</p>
  
  <p>Please find the error log from XAMPP below.</p>
  
  <pre><code>   2015-05-28 20:42:58 11488 [Note] Plugin 'FEDERATED' is disabled.
      2015-05-28 20:42:58 2e50 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-05-28 20:42:58 11488 [Note] InnoDB: Using atomics to ref count buffer pool pages
      2015-05-28 20:42:58 11488 [Note] InnoDB: The InnoDB memory heap is disabled
      2015-05-28 20:42:58 11488 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
      2015-05-28 20:42:58 11488 [Note] InnoDB: Memory barrier is not used
      2015-05-28 20:42:58 11488 [Note] InnoDB: Compressed tables use zlib 1.2.3
      2015-05-28 20:42:58 11488 [Note] InnoDB: Not using CPU crc32 instructions
      2015-05-28 20:42:58 11488 [Note] InnoDB: Initializing buffer pool, size = 16.0M
      2015-05-28 20:42:58 11488 [Note] InnoDB: Completed initialization of buffer pool
      2015-05-28 20:42:58 11488 [Note] InnoDB: Highest supported file format is Barracuda.
      2015-05-28 20:42:58 11488 [Note] InnoDB: 128 rollback segment(s) are active.
      2015-05-28 20:42:58 11488 [Note] InnoDB: Waiting for purge to start
      2015-05-28 20:42:58 11488 [Note] InnoDB: 5.6.24 started; log sequence number 1665294
      2015-05-28 20:42:58 11488 [Note] Server hostname (bind-address): '*'; port: 3306
      2015-05-28 20:42:58 11488 [Note] IPv6 is available.
      2015-05-28 20:42:58 11488 [Note]   - '::' resolves to '::';
      2015-05-28 20:42:58 11488 [Note] Server socket created on IP: '::'.
      2015-05-28 20:42:58 11488 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
      2015-05-28 20:42:58 11488 [ERROR] Do you already have another mysqld server running on port: 3306 ?
      2015-05-28 20:42:58 11488 [ERROR] Aborting
  
      2015-05-28 20:42:58 11488 [Note] Binlog end
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'partition'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_FT_DELETED'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_METRICS'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_CMPMEM'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_CMP_RESET'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_CMP'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_LOCKS'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'INNODB_TRX'
      2015-05-28 20:42:58 11488 [Note] Shutting down plugin 'InnoDB'
      2015-05-28 20:42:58 11488 [Note] InnoDB: FTS optimize thread exiting.
      2015-05-28 20:42:58 11488 [Note] InnoDB: Starting shutdown...
      2015-05-28 20:42:59 11488 [Note] InnoDB: Shutdown completed; log sequence number 1665304
      2015-05-28 20:42:59 11488 [Note] Shutting down plugin 'BLACKHOLE'
      2015-05-28 20:42:59 11488 [Note] Shutting down plugin 'ARCHIVE'
      2015-05-28 20:42:59 11488 [Note] Shutting down plugin 'MRG_MYISAM'
      2015-05-28 20:42:59 11488 [Note] Shutting down plugin 'MyISAM'
      2015-05-28 20:42:59 11488 [Note] Shutting down plugin 'MEMORY'
      2015-05-28 20:42:59 11488 [Note] Shutting down plugin 'CSV'
      2015-05-28 20:42:59 11488 [Note] Shutting down plugin 'sha256_password'
      2015-05-28 20:42:59 11488 [Note] Shutting down plugin 'mysql_old_password'
      2015-05-28 20:42:59 11488 [Note] Shutting down plugin 'mysql_native_password'
      2015-05-28 20:42:59 11488 [Note] Shutting down plugin 'binlog'
      2015-05-28 20:42:59 11488 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete
  </code></pre>
  
  <p>Thanks in advance for your help. Appreciate it.</p>