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.

Este sitio web utiliza cookies para que usted tenga la mejor experiencia de usuario. Si continúa navegando está dando su consentimiento para la aceptación de las mencionadas cookies y la aceptación de nuestra política de cookies, pinche el enlace para mayor información.plugin cookies

ACEPTAR
Aviso de cookies