Toad World® Forums

Querying mysql.user gives "unknown data type/fatal error encountered during command execution"

Toad Data Point 5.0.4.45

Running 'select * from mysql.user;' against a MySQL 8.0 database returns a pop-up stating "unknown data type"

Running it against a MySQL 5.6 database works just fine

Looks like the "User Attributes" column is to blame, as it's in format json. Removing this column pulls the data without issue.

Is the version of Toad I'm using unable to pull json, or unable to pull if being pulled with other columns?

Bump for visibility, anyone have any ideas?

Toad Data Point is not supporting MySQL 8.0 yet (Toad Data Point 5.4 release notes are here https://support.quest.com/technical-documents/toad-data-point/5.4/release-notes#TOPIC-1602180). So this may just be an incompatibility issue that will be addressed in an upcoming release.

Thanks for the reply on this! Will keep this in mind going forward.