'Error on client connections: invalid values of 'columnLabel'

I am MySQL user with workbench and Amazon RDS

Every time I try to access MySQL client connections I get this error:

enter image description here

Unhandled exception:
DbMySQLQuery.resultFieldStringValueByName():
MySQL_ResultSet::isNull: invalid values of 'columnLabel'

Check the log for more details

enter image description here

The user I am using has all the accesses of an admin/root

This error does not happen to all users, only to some

Am I forgetting to provide some kind of permission?

mysqlmysql-workbench


Solution 1:[1]

There is a solution in this link that worked for me on version 8.0.28:

https://bugs.mysql.com/bug.php?id=102465

See entry "[3 Feb 16:10] Adam Latchem"

Solution 2:[2]

The proposed solution "[3 Feb 16:10] Adam Latchem" worked for me, in the context of MySQL Workbench connecting to a MariaDB database. The fix (for definiteness) is to edit the file C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_connections.py at line 346, to change it from

("DB", mforms.StringColumnType, "DB", 100),

to

("db", mforms.StringColumnType, "DB", 100),

(note change of case in first argument).

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Mike Martin
Solution 2 Martin Baxter

Related Questions