Erros de inicialização do MySQL: ERROR 1005

Question

A minha instalação Debian MySQL dá isto:

Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [Note] Server socket created on IP: '127.0.0.1'.
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/events_waits_current.frm' (errno: 13)
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/events_waits_history.frm' (errno: 13)
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/events_waits_history_long.frm' (errno: 13)
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/setup_consumers.frm' (errno: 13)
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/setup_instruments.frm' (errno: 13)
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/setup_timers.frm' (errno: 13)
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/performance_timers.frm' (errno: 13)
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/threads.frm' (errno: 13)
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/events_waits_summary_by_thread_by_event_name.frm' (errno: 13)
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/events_waits_summary_by_instance.frm' (errno: 13)
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/events_waits_summary_global_by_event_name.frm' (errno: 13)
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/file_summary_by_event_name.frm' (errno: 13)
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/file_summary_by_instance.frm' (errno: 13)
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/mutex_instances.frm' (errno: 13)
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/rwlock_instances.frm' (errno: 13)
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/cond_instances.frm' (errno: 13)
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/file_instances.frm' (errno: 13)
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [Note] Event Scheduler: Loaded 0 events
Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [Note] /usr/sbin/mysqld: ready for connections.
:
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: Running 'mysql_fix_privilege_tables'...
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: ERROR 1007 (HY000) at line 160: Can't create database 'performance_schema'; database exists
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: ERROR 1005 (HY000) at line 183: Can't create table 'cond_instances' (errno: 13)
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: ERROR 1005 (HY000) at line 213: Can't create table 'events_waits_current' (errno: 13)
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: ERROR 1005 (HY000) at line 227: Can't create table 'events_waits_history' (errno: 13)
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: ERROR 1005 (HY000) at line 241: Can't create table 'events_waits_history_long' (errno: 13)
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: ERROR 1005 (HY000) at line 262: Can't create table 'events_waits_summary_by_instance' (errno: 13)
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: ERROR 1005 (HY000) at line 283: Can't create table 'events_waits_summary_by_thread_by_event_name' (errno: 13)
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: ERROR 1005 (HY000) at line 303: Can't create table 'events_waits_summary_global_by_event_name' (errno: 13)
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: ERROR 1005 (HY000) at line 320: Can't create table 'file_instances' (errno: 13)
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: ERROR 1005 (HY000) at line 339: Can't create table 'file_summary_by_event_name' (errno: 13)
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: ERROR 1005 (HY000) at line 359: Can't create table 'file_summary_by_instance' (errno: 13)
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: ERROR 1005 (HY000) at line 376: Can't create table 'mutex_instances' (errno: 13)
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: ERROR 1005 (HY000) at line 394: Can't create table 'performance_timers' (errno: 13)
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: ERROR 1005 (HY000) at line 412: Can't create table 'rwlock_instances' (errno: 13)
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: ERROR 1005 (HY000) at line 428: Can't create table 'setup_consumers' (errno: 13)
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: ERROR 1005 (HY000) at line 445: Can't create table 'setup_instruments' (errno: 13)
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: ERROR 1005 (HY000) at line 461: Can't create table 'setup_timers' (errno: 13)
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: ERROR 1005 (HY000) at line 478: Can't create table 'threads' (errno: 13)
Sep 25 13:38:10 xint01 /etc/mysql/debian-start[20151]: FATAL ERROR: Upgrade failed

Ele não parece afetar o MySQL, mas como posso remover / corrigir isso?

mysql --version
mysql  Ver 14.14 Distrib 5.5.38, for debian-linux-gnu (x86_64) using readline 6.2

- EDITAR

Parece que está relacionado com mysql_upgrade , o que dá os mesmos erros após o ':' acima.

    

Answer 1

Errno 13 significa "permissão negada", ou os arquivos em si não são legíveis e / ou os diretórios que levam aos arquivos não são acessíveis (/, / var, / var / lib precisa executar permissões para o usuário mysql, / var / lib / mysql e abaixo precisa de leitura / gravação / execução).

Neste caso, parece que está limitado ao diretório mysql / performance_schema em / var / lib / mysql; corrija esse diretório para mostrar as mesmas permissões, usuário / grupo como, por exemplo, o diretório mysql / mysql.

EDIT: substituiu spool com lib como apontado por Ole.