Problema no Mysql Xampp

  • ironsoldierjp
  • Avatar de ironsoldierjp Autor do Tópico
  • Offline
  • JCB! Novato
  • JCB! Novato
Mais
10 anos 4 meses atrás #94968 por ironsoldierjp
ironsoldierjp created the topic: Problema no Mysql Xampp
Ola pessoal...estou com um problema! pra variar uahauhauah....

bem meu pc tava com alguns virus, após fazer a remoção e antes também meu xamp nao quer funcionar da forma apropriada q deveria ser. Ele não está iniciando a base do Mysql naquele botão aonde clicamos START & STOP.

pensei poder ser meu anti virus Kaspersky internet security que pode ter bloqueado alguma porta que o xammp usa, mas não sei como verificar isso no Kaspersky, alguma luz ai?

o log de erro segue abaixo do xampp

131220 6:29:15 [Note] Plugin 'FEDERATED' is disabled.
131220 6:29:16 InnoDB: The InnoDB memory heap is disabled
131220 6:29:16 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131220 6:29:16 InnoDB: Compressed tables use zlib 1.2.3
131220 6:29:16 InnoDB: Initializing buffer pool, size = 16.0M
131220 6:29:16 InnoDB: Completed initialization of buffer pool
131220 6:29:16 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
131220 6:29:16 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
131220 6:29:22 InnoDB: Waiting for the background threads to start
131220 6:29:23 InnoDB: 1.1.8 started; log sequence number 11529115
131220 6:29:24 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
131220 6:29:24 [Note] - '0.0.0.0' resolves to '0.0.0.0';
131220 6:29:24 [Note] Server socket created on IP: '0.0.0.0'.
131220 6:29:24 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
131220 6:30:23 [Note] Plugin 'FEDERATED' is disabled.
131220 6:30:23 InnoDB: The InnoDB memory heap is disabled
131220 6:30:23 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131220 6:30:23 InnoDB: Compressed tables use zlib 1.2.3
131220 6:30:23 InnoDB: Initializing buffer pool, size = 16.0M
131220 6:30:23 InnoDB: Completed initialization of buffer pool
131220 6:30:23 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
131220 6:30:23 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
131220 6:30:25 InnoDB: Waiting for the background threads to start
131220 6:30:26 InnoDB: 1.1.8 started; log sequence number 11529115
131220 6:30:26 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
131220 6:30:26 [Note] - '0.0.0.0' resolves to '0.0.0.0';
131220 6:30:26 [Note] Server socket created on IP: '0.0.0.0'.
131220 6:30:26 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
131220 7:41:33 [Note] Plugin 'FEDERATED' is disabled.
131220 7:41:33 InnoDB: The InnoDB memory heap is disabled
131220 7:41:33 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131220 7:41:33 InnoDB: Compressed tables use zlib 1.2.3
131220 7:41:33 InnoDB: Initializing buffer pool, size = 16.0M
131220 7:41:33 InnoDB: Completed initialization of buffer pool
131220 7:41:33 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
131220 7:41:33 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
131220 7:41:35 InnoDB: Waiting for the background threads to start
131220 7:41:36 InnoDB: 1.1.8 started; log sequence number 11529115
131220 7:41:36 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
131220 7:41:36 [Note] - '0.0.0.0' resolves to '0.0.0.0';
131220 7:41:36 [Note] Server socket created on IP: '0.0.0.0'.
131220 7:41:36 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)


Qualquer ajuda será bem vinda....
grato pessoal

Joao

Please Entrar ou Registrar to join the conversation.


Mais
10 anos 4 meses atrás #95021 por panku
panku replied the topic: Re: Problema no Mysql Xampp
Não sei arrumar esse bug, mas sei que você pode reinstalar ele, e vai funcionar =D

Please Entrar ou Registrar to join the conversation.