Seleccionar página

Si intentando acceder con Mysql Workbench a una BD na saca el listado de tablas y solo aparace “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.