Toad World® Forums

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

Toad Data Point

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?