Cannot See DB Tables In Workbench After Connect

(Doc ID 2247809.1)

Last updated on JUNE 09, 2017

Applies to:

MySQL Workbench - Version 6.3 and later
Information in this document applies to any platform.

Symptoms

Workbench is unable to retrieve meta data from MySQL server. Tables are not listed.

Looking at the MySQL error log we can find the error

2017-03-13T19:25:17.583335Z 2564 [ERROR] Incorrect definition of table mysql.proc: expected column 'definer' at position 11 to have type char(77), found type char(93)

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms