i cant start mysql in my windows7

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

i cant start mysql in my windows7

Postby Dheekshitha » 09. August 2017 07:59

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

2017-08-09 12:36:41 1c2c 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.
2017-08-09 12:36:41 7212 [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.

2017-08-09 12:36:41 7212 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-08-09 12:36:41 7212 [Note] InnoDB: The InnoDB memory heap is disabled
2017-08-09 12:36:41 7212 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-08-09 12:36:41 7212 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-08-09 12:36:41 7212 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-08-09 12:36:41 7212 [Note] InnoDB: Using generic crc32 instructions
2017-08-09 12:36:41 7212 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-08-09 12:36:41 7212 [Note] InnoDB: Completed initialization of buffer pool
2017-08-09 12:36:41 7212 [Note] InnoDB: Highest supported file format is Barracuda.
2017-08-09 12:36:42 7212 [Note] InnoDB: 128 rollback segment(s) are active.
2017-08-09 12:36:42 7212 [Note] InnoDB: Waiting for purge to start
2017-08-09 12:36:42 7212 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1835037
2017-08-09 12:36:42 8056 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-08-09 12:36:42 7212 [Note] Plugin 'FEEDBACK' is disabled.
2017-08-09 12:36:42 7212 [Note] Server socket created on IP: '::'.
2017-08-09 12:36:42 7212 [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.


2017-08-09 12:36:42 7212 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-08-09 12:36:42 7212 [ERROR] Aborting

2017-08-09 12:36:53 185c 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.
2017-08-09 12:36:53 6236 [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.

2017-08-09 12:36:53 6236 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-08-09 12:36:53 6236 [Note] InnoDB: The InnoDB memory heap is disabled
2017-08-09 12:36:53 6236 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-08-09 12:36:53 6236 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-08-09 12:36:53 6236 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-08-09 12:36:53 6236 [Note] InnoDB: Using generic crc32 instructions
2017-08-09 12:36:53 6236 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-08-09 12:36:53 6236 [Note] InnoDB: Completed initialization of buffer pool
2017-08-09 12:36:53 6236 [Note] InnoDB: Highest supported file format is Barracuda.
2017-08-09 12:36:54 6236 [Note] InnoDB: 128 rollback segment(s) are active.
2017-08-09 12:36:54 6236 [Note] InnoDB: Waiting for purge to start
2017-08-09 12:36:54 6236 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1835047
2017-08-09 12:36:54 4620 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-08-09 12:36:54 6236 [Note] Plugin 'FEEDBACK' is disabled.
2017-08-09 12:36:54 6236 [Note] Server socket created on IP: '::'.
2017-08-09 12:36:54 6236 [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.


2017-08-09 12:36:54 6236 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-08-09 12:36:54 6236 [ERROR] Aborting

2017-08-09 12:37:02 1098 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.
2017-08-09 12:37:02 4248 [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.

2017-08-09 12:37:02 4248 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-08-09 12:37:02 4248 [Note] InnoDB: The InnoDB memory heap is disabled
2017-08-09 12:37:02 4248 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-08-09 12:37:02 4248 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-08-09 12:37:02 4248 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-08-09 12:37:02 4248 [Note] InnoDB: Using generic crc32 instructions
2017-08-09 12:37:02 4248 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-08-09 12:37:02 4248 [Note] InnoDB: Completed initialization of buffer pool
2017-08-09 12:37:02 4248 [Note] InnoDB: Highest supported file format is Barracuda.
2017-08-09 12:37:02 4248 [Note] InnoDB: 128 rollback segment(s) are active.
2017-08-09 12:37:02 4248 [Note] InnoDB: Waiting for purge to start
2017-08-09 12:37:02 4248 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1835057
2017-08-09 12:37:02 1928 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-08-09 12:37:02 4248 [Note] Plugin 'FEEDBACK' is disabled.
2017-08-09 12:37:02 4248 [Note] Server socket created on IP: '::'.
2017-08-09 12:37:02 4248 [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.


2017-08-09 12:37:02 4248 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-08-09 12:37:02 4248 [ERROR] Aborting

2017-08-09 12:38:03 1934 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.
2017-08-09 12:38:03 6452 [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.

2017-08-09 12:38:03 6452 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-08-09 12:38:03 6452 [Note] InnoDB: The InnoDB memory heap is disabled
2017-08-09 12:38:03 6452 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-08-09 12:38:03 6452 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-08-09 12:38:03 6452 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-08-09 12:38:03 6452 [Note] InnoDB: Using generic crc32 instructions
2017-08-09 12:38:03 6452 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-08-09 12:38:03 6452 [Note] InnoDB: Completed initialization of buffer pool
2017-08-09 12:38:03 6452 [Note] InnoDB: Highest supported file format is Barracuda.
2017-08-09 12:38:03 6452 [Note] InnoDB: 128 rollback segment(s) are active.
2017-08-09 12:38:03 6452 [Note] InnoDB: Waiting for purge to start
2017-08-09 12:38:03 6452 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1835067
2017-08-09 12:38:03 6912 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-08-09 12:38:03 6452 [Note] Plugin 'FEEDBACK' is disabled.
2017-08-09 12:38:03 6452 [Note] Server socket created on IP: '::'.
2017-08-09 12:38:03 6452 [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.


2017-08-09 12:38:03 6452 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-08-09 12:38:03 6452 [ERROR] Aborting

2017-08-09 12:38:21 16c0 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.
2017-08-09 12:38:21 5824 [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.

2017-08-09 12:38:21 5824 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-08-09 12:38:21 5824 [Note] InnoDB: The InnoDB memory heap is disabled
2017-08-09 12:38:21 5824 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-08-09 12:38:21 5824 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-08-09 12:38:21 5824 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-08-09 12:38:21 5824 [Note] InnoDB: Using generic crc32 instructions
2017-08-09 12:38:21 5824 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-08-09 12:38:21 5824 [Note] InnoDB: Completed initialization of buffer pool
2017-08-09 12:38:22 5824 [Note] InnoDB: Highest supported file format is Barracuda.
2017-08-09 12:38:22 5824 [Note] InnoDB: 128 rollback segment(s) are active.
2017-08-09 12:38:22 5824 [Note] InnoDB: Waiting for purge to start
2017-08-09 12:38:22 5824 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1835077
2017-08-09 12:38:22 776 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-08-09 12:38:22 5824 [Note] Plugin 'FEEDBACK' is disabled.
2017-08-09 12:38:22 5824 [Note] Server socket created on IP: '::'.
2017-08-09 12:38:22 5824 [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.


2017-08-09 12:38:22 5824 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-08-09 12:38:22 5824 [ERROR] Aborting
Dheekshitha
 
Posts: 4
Joined: 09. August 2017 07:56
XAMPP version: 3.2.2
Operating System: windows

Re: i cant start mysql in my windows7

Postby Altrea » 09. August 2017 08:18

Dheekshitha wrote:2017-08-09 12:38:22 5824 [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.


2017-08-09 12:38:22 5824 [ERROR] Do you already have another mysqld server running on port: 3306 ?
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: 11933
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: i cant start mysql in my windows7

Postby Dheekshitha » 09. August 2017 08:31

yea, yesterday i installed my sql. but i cant uninstall it completely from my system.give me a tip to solve it.
Dheekshitha
 
Posts: 4
Joined: 09. August 2017 07:56
XAMPP version: 3.2.2
Operating System: windows

Re: i cant start mysql in my windows7

Postby Altrea » 09. August 2017 09:13

Dheekshitha wrote:yea, yesterday i installed my sql. but i cant uninstall it completely from my system.give me a tip to solve it.

give me a tip why you are not able to uninstall it completely from your system
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: 11933
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: i cant start mysql in my windows7

Postby Dheekshitha » 09. August 2017 09:50

when i try to delete the complete files.it says the action cant be completed,the folder or file is open in another program.but i cant find where it was opened?
Dheekshitha
 
Posts: 4
Joined: 09. August 2017 07:56
XAMPP version: 3.2.2
Operating System: windows

Re: i cant start mysql in my windows7

Postby Nobbie » 09. August 2017 09:59

Thats a plain windows problem, we cannot help on that- You MUST at least stop that mysql installation. Its even better to de-install it. Either start windows in protected mode, or re-install windows or whatever, if you do not succeed to stop that mysql installation, you cannot run Xampps MySQL.
Nobbie
 
Posts: 13176
Joined: 09. March 2008 13:04

Re: i cant start mysql in my windows7

Postby Altrea » 09. August 2017 10:03

Is there a MySQL Service present and running on your system?
If yes you need to stop and unregister the service in order to be able to remove the remaining files and folders.
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: 11933
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: i cant start mysql in my windows7

Postby Dheekshitha » 09. August 2017 12:52

I uninstalled mysql and i started mysql with Xampp.Thank you for your help :)
Dheekshitha
 
Posts: 4
Joined: 09. August 2017 07:56
XAMPP version: 3.2.2
Operating System: windows


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 297 guests

cron