MYSQL shutsdown after new install

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

MYSQL shutsdown after new install

Postby rberrybabylon » 02. November 2018 20:20

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
rberrybabylon
 
Posts: 4
Joined: 17. October 2018 19:02
XAMPP version: 5.6.36
Operating System: Windows 10

Re: MYSQL shutsdown after new install

Postby Altrea » 02. November 2018 21:33

Did you change the port in the control panel configs 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: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: MYSQL shutsdown after new install

Postby rberrybabylon » 03. November 2018 16:19

Yes, I changed the config files in the xampp control console.
rberrybabylon
 
Posts: 4
Joined: 17. October 2018 19:02
XAMPP version: 5.6.36
Operating System: Windows 10

Re: MYSQL shutsdown after new install

Postby rberrybabylon » 05. November 2018 22:11

Problem solved by installing xampp for the fourth time. Go figure :roll:
rberrybabylon
 
Posts: 4
Joined: 17. October 2018 19:02
XAMPP version: 5.6.36
Operating System: Windows 10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 127 guests