Compatibility, Mysql 8 - Can't read tables properly in information_schema.

[expired user #12358]'s profile image [expired user #12358] posted 5 years ago in General Permalink

Something has changes with information_schema in MySQL 8 that prevents heidisql from being able to read most of the tables. It's frustrating as I use it quite heavily for my migration and code generation tools.

It's not only heidisql that is effected, some other connectors and libs also break with information_schema in mysql 8 so if anyone figures out what's causing it please share.

The client works alright so I would guess the issue is in the diffs for that.

ansgar's profile image ansgar posted 5 years ago Permalink

Yes, MySQL 8 does not continue with quite a bit of backward compatibility.

You did not post an exact error message so I can just recommend to update to the latest build - I recall I already worked around some of these issues.

Please login to leave a reply, or register at first.