Solucionado (ver solução)
Solucionado
(ver solução)
3
respostas

Erro ao Iniciar o serviço do MySQL no xampp

bom dia a todos, estou com um dificuldade na iniciação do serviço do mySQL no xampp, o serviço não inicia e desta forma não consigo conectar no banco, não tem nada de errado com o código, pois ontem estava funcionando, até realizei alguns exercícios com êxito, desativai o firewall e nada de serviço iniciar, fiz a instalação em outra maquina da minha casa e o mesmo problema ocorre. Segue trecho do log de erro:

2016-07-08 12:02:08 21c0 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. 2016-07-08 12:02:08 8640 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2016-07-08 12:02:08 8640 [Note] InnoDB: The InnoDB memory heap is disabled 2016-07-08 12:02:08 8640 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2016-07-08 12:02:08 8640 [Note] InnoDB: Memory barrier is not used 2016-07-08 12:02:08 8640 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-07-08 12:02:08 8640 [Note] InnoDB: Using generic crc32 instructions 2016-07-08 12:02:08 8640 [Note] InnoDB: Initializing buffer pool, size = 16.0M 2016-07-08 12:02:08 8640 [Note] InnoDB: Completed initialization of buffer pool 2016-07-08 12:02:08 8640 [Note] InnoDB: Highest supported file format is Barracuda. 2016-07-08 12:02:08 8640 [Note] InnoDB: 128 rollback segment(s) are active. 2016-07-08 12:02:08 8640 [Note] InnoDB: Waiting for purge to start 2016-07-08 12:02:08 8640 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1846000 2016-07-08 12:02:09 6800 [Note] InnoDB: Dumping buffer pool(s) not yet started 2016-07-08 12:02:09 8640 [Note] Plugin 'FEEDBACK' is disabled. 2016-07-08 12:02:09 8640 [Note] Server socket created on IP: '::'. 2016-07-08 12:02:09 8640 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Normalmente é permitida apenas uma utilização de cada endereço de soquete (protocolo/endereço de rede/porta).

2016-07-08 12:02:09 8640 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2016-07-08 12:02:09 8640 [ERROR] Aborting

2016-07-08 12:02:58 1a2c 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. 2016-07-08 12:02:58 6700 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2016-07-08 12:02:58 6700 [Note] InnoDB: The InnoDB memory heap is disabled 2016-07-08 12:02:58 6700 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2016-07-08 12:02:58 6700 [Note] InnoDB: Memory barrier is not used 2016-07-08 12:02:58 6700 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-07-08 12:02:58 6700 [Note] InnoDB: Using generic crc32 instructions 2016-07-08 12:02:58 6700 [Note] InnoDB: Initializing buffer pool, size = 16.0M 2016-07-08 12:02:58 6700 [Note] InnoDB: Completed initialization of buffer pool 2016-07-08 12:02:59 6700 [Note] InnoDB: Highest supported file format is Barracuda. 2016-07-08 12:02:59 6700 [Note] InnoDB: 128 rollback segment(s) are active. 2016-07-08 12:02:59 6700 [Note] InnoDB: Waiting for purge to start 2016-07-08 12:02:59 6700 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1846010 2016-07-08 12:02:59 6700 [Note] Plugin 'FEEDBACK' is disabled. 2016-07-08 12:02:59 6700 [Note] Server socket created on IP: '::'. 2016-07-08 12:02:59 6700 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Normalmente é permitida apenas uma utilização de cada endereço de soquete (protocolo/endereço de rede/porta).

2016-07-08 12:02:59 6700 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2016-07-08 12:02:59 5680 [Note] InnoDB: Dumping buffer pool(s) not yet started 2016-07-08 12:02:59 6700 [ERROR] Aborting

3 respostas
solução!

Aparentemente o teu mysql server já tá rodando, tenta olhar no gerenciador de tarefas algo como "mysql" e mata o processo, ao menos eu resolvo assim.

obrigado pela ajuda Luiz Eduardo, funcionou perfeitamente.

Resolveu. abs