Information_schema not displaying when connecting to MySql
Trying to make queries about the structure of my databases using information_schema. I can see and add the database in the databases tab in the connection editor, but they don't show up in list once connected. All the other table show up including performance_schema and sys, as well as my db's.
I'm logging on with root privileges, also tried with an admin user where I specifically all full control over this and all other objects.
I can reference the tables I'm interested in using select statements, which is fine, but I can't see the table visually, can't drag it onto the query editor, etc
Is there a fix for this?
Hello, Peter.
Open the Connection Properties dialog, go to the Databases tab and add "Information_schema" to the list of displayed databases for this connection.