Page 1 of 1

MYSQL shutsdown after new install

PostPosted: 02. November 2018 20:20
by rberrybabylon
Just reinstalled xampp pkg and had to change all mysql config files from 3306 port to 3330. Still won't work. (The original install had the same problem.) Can't figure out why it continues to refer to port 3306. Thanks for your help. Here is portion of my log file:

2018-11-02 14:17:41 2474 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.
2018-11-02 14:17:41 9332 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-11-02 14:17:41 9332 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-11-02 14:17:41 9332 [Note] InnoDB: The InnoDB memory heap is disabled
2018-11-02 14:17:41 9332 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-11-02 14:17:41 9332 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-11-02 14:17:41 9332 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-11-02 14:17:41 9332 [Note] InnoDB: Using generic crc32 instructions
2018-11-02 14:17:41 9332 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-11-02 14:17:41 9332 [Note] InnoDB: Completed initialization of buffer pool
2018-11-02 14:17:42 9332 [Note] InnoDB: Highest supported file format is Barracuda.
2018-11-02 14:17:42 9332 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*320 pages, LSN=1836566
2018-11-02 14:17:42 9332 [Warning] InnoDB: Starting to delete and rewrite log files.
2018-11-02 14:17:42 9332 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5 MB
2018-11-02 14:17:42 9332 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
2018-11-02 14:17:42 9332 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2018-11-02 14:17:42 9332 [Warning] InnoDB: New log files created, LSN=1837068
2018-11-02 14:17:42 9332 [Note] InnoDB: 128 rollback segment(s) are active.
2018-11-02 14:17:42 9332 [Note] InnoDB: Waiting for purge to start
2018-11-02 14:17:42 9332 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1836566
2018-11-02 14:17:42 7008 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-11-02 14:17:42 9332 [Note] Plugin 'FEEDBACK' is disabled.
2018-11-02 14:17:42 9332 [Note] Server socket created on IP: '::'.
2018-11-02 14:17:42 9332 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2018-11-02 14:17:42 9332 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2018-11-02 14:17:42 9332 [ERROR] Aborting

Re: MYSQL shutsdown after new install

PostPosted: 02. November 2018 21:33
by Altrea
Did you change the port in the control panel configs too?

Re: MYSQL shutsdown after new install

PostPosted: 03. November 2018 16:19
by rberrybabylon
Yes, I changed the config files in the xampp control console.

Re: MYSQL shutsdown after new install

PostPosted: 05. November 2018 22:11
by rberrybabylon
Problem solved by installing xampp for the fourth time. Go figure :roll: