Seleccionar página

MySQL Workbench: Al acceder a una bd no saca tablas…pone “fetching…”

por | Jul 4, 2011 | GNU / Linux, MySQL

Si intentando acceder con Mysql Workbench a una BD na saca el listado de tablas y solo aparece “fetching…” puede ser porque se ha actualizado la versión de Mysql y esta dando algún error accediendo a la información de la BD.

Si se accede al log de mysqld “/var/log/mysqld” se ve que ha sacado la siguiente información:


110704 7:51:35 [Note] Plugin 'FEDERATED' is disabled.
110704 7:51:35 InnoDB: The InnoDB memory heap is disabled
110704 7:51:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110704 7:51:35 InnoDB: Compressed tables use zlib 1.2.5
110704 7:51:35 InnoDB: Using Linux native AIO
110704 7:51:35 InnoDB: Initializing buffer pool, size = 128.0M
110704 7:51:36 InnoDB: Completed initialization of buffer pool
110704 7:51:36 InnoDB: highest supported file format is Barracuda.
110704 7:51:37 InnoDB: Waiting for the background threads to start
110704 7:51:38 InnoDB: 1.1.7 started; log sequence number 5531355988
110704 7:51:38 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
110704 7:51:38 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
110704 7:51:38 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
110704 7:51:38 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
110704 7:51:38 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
110704 7:51:38 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
110704 7:51:38 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
110704 7:51:38 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
110704 7:51:38 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
110704 7:51:38 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
110704 7:51:38 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
110704 7:51:38 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
110704 7:51:38 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
110704 7:51:38 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
110704 7:51:38 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
110704 7:51:38 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
110704 7:51:38 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
110704 7:51:38 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
110704 7:51:38 [Note] Event Scheduler: Loaded 0 events
110704 7:51:38 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.13' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)

110704 11:11:46 [ERROR] Incorrect definition of table mysql.proc: expected column ‘comment’ at position 15 to have type text, found type char(64).

 

Para solucionar este problema lo único que hay que hacer es ejecutar lo siguiente:


sudo mysql_upgrade

Y listo ya se puede usar el Mysql Workbench.

0 comentarios

Enviar un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Blog de Neodoo Microsystems
Resumen de privacidad

Esta web utiliza cookies para que podamos ofrecerte la mejor experiencia de usuario posible. La información de las cookies se almacena en tu navegador y realiza funciones tales como reconocerte cuando vuelves a nuestra web o ayudar a nuestro equipo a comprender qué secciones de la web encuentras más interesantes y útiles. Puedes encontrar más información en nuestra Política de privacidad y Política de cookies.