Não consigo startar MYSQL

qxada07
(usa Slackware)

Enviado em 27/11/2015 - 16:02h

Galera,

Estou tendo problemas em startar meu mysql

Após executar o comando abaixo da erro.
#mysqld_safe &

Segue abaixo os logs de erro.

151127 18:20:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
151127 18:20:42 InnoDB: The InnoDB memory heap is disabled
151127 18:20:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151127 18:20:42 InnoDB: Compressed tables use zlib 1.2.6
151127 18:20:42 InnoDB: Using Linux native AIO
151127 18:20:42 InnoDB: Initializing buffer pool, size = 128.0M
151127 18:20:42 InnoDB: Completed initialization of buffer pool
151127 18:20:42 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!
151127 18:20:42 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...
151127 18:20:42 InnoDB: Waiting for the background threads to start
151127 18:20:43 Percona XtraDB (http://www.percona.com) 5.5.32-MariaDB-30.2 started; log sequence number 1597945
151127 18:20:43 [Note] Plugin 'FEEDBACK' is disabled.
151127 18:20:43 [ERROR] mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
151127 18:20:43 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
151127 18:20:43 [Note] Server socket created on IP: '0.0.0.0'.
151127 18:20:43 [ERROR] mysqld: Can't find file: './mysql/host.frm' (errno: 13)
151127 18:20:43 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
151127 18:20:43 mysqld_safe mysqld from pid file /var/lib/mysql/Slk.pid ended

Obrigado!!!

conectadohost
(usa XUbuntu)

Enviado em 27/11/2015 - 23:10h

Olá,
Já tentou esse procedimento
rm -rf /tmp/* limpar a pasta tmp
myisamchk –check /var/lib/mysql/*/*.MYI reparar as tabelas
depois da o comando para parar o mysql e depois reiniciar o mysql

se não resolver, posta pra nós seu arquivo my.conf do mysql

---> A arte de programar consiste na arte de organizar e dominar a complexidade.
---> Dijkstra <---