Prosíme přihlašte se nebo zaregistrujte.

Přihlašte se svým uživatelským jménem a heslem.
Vaše pomoc je stále potřeba!

Autor Téma: problém se spuštěním MySQL serveru pod apache2  (Přečteno 2296 krát)

psenik

  • Návštěvník
  • Příspěvků: 30
problém se spuštěním MySQL serveru pod apache2
« kdy: 07 Ledna 2014, 11:43:38 »
Zdravím všechny,
ještě se mi to nestalo, ale právě se mi zhroutil mysql server, výpis error logu je následující:
Kód: [Vybrat]
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
140107 11:40:07 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
140107 11:40:07 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
140107 11:40:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140107 11:40:07 InnoDB: The InnoDB memory heap is disabled
140107 11:40:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140107 11:40:07 InnoDB: Compressed tables use zlib 1.2.8
140107 11:40:07 InnoDB: Using Linux native AIO
140107 11:40:07 InnoDB: Initializing buffer pool, size = 128.0M
140107 11:40:07 InnoDB: Completed initialization of buffer pool
140107 11:40:07  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
140107 11:40:08 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
140107 11:40:08 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
140107 11:40:08 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140107 11:40:08 InnoDB: The InnoDB memory heap is disabled
140107 11:40:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140107 11:40:08 InnoDB: Compressed tables use zlib 1.2.8
140107 11:40:08 InnoDB: Using Linux native AIO
140107 11:40:08 InnoDB: Initializing buffer pool, size = 128.0M
140107 11:40:08 InnoDB: Completed initialization of buffer pool
140107 11:40:08  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
140107 11:40:09 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
140107 11:40:09 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
140107 11:40:09 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140107 11:40:09 InnoDB: The InnoDB memory heap is disabled
140107 11:40:09 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140107 11:40:09 InnoDB: Compressed tables use zlib 1.2.8
140107 11:40:09 InnoDB: Using Linux native AIO
140107 11:40:09 InnoDB: Initializing buffer pool, size = 128.0M
140107 11:40:09 InnoDB: Completed initialization of buffer pool
140107 11:40:09  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.

Nevíte někdo co s tím?

Petr Merlin Vaněček

  • Moderátor
  • Závislák
  • ***
  • Příspěvků: 5057
    • Lomítkáři
Re:problém se spuštěním MySQL serveru pod apache2
« Odpověď #1 kdy: 07 Ledna 2014, 13:06:43 »
Opravit práva na /var/lib/mysql a spustit mysql_upgrade
Stiskni CTRL + W ...
80% mozku tvoří kapalina ... u některých brzdová

Petr Merlin Vaněček

  • Moderátor
  • Závislák
  • ***
  • Příspěvků: 5057
    • Lomítkáři
Re:problém se spuštěním MySQL serveru pod apache2
« Odpověď #2 kdy: 05 Února 2014, 20:47:36 »
Jak to dopadlo?
Stiskni CTRL + W ...
80% mozku tvoří kapalina ... u některých brzdová

 

Provoz zaštiťuje spolek OpenAlt.