Comparison of graphical tools for MySQL


[SOLVED] ERROR 3167 (HY000) The 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' feature is disabled see the documentation for 'show_compatibility_56'

Print PDF
User Rating: / 18

Problems with MySQL 5.7.8-rc. In different situations, when you run queries or connect to mysql database you get an error:


ERROR 3167 (HY000): The 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' feature is disabled; see the documentation for 'show_compatibility_56'


To resolve the problem you must set global variable show_compatibility_56 = ON.

Connect to musql database via console and execute the command:

SET GLOBAL show_compatibility_56 = ON;

Q: How to keep variable show_compatibility_56 always ON even if you restart the server?

A: You need to save this variable setting in your configuration file my.ini for windows server and my.cnf for linux.

Q: Can you tell me please where can I find the my.cfg file (means the path)?

A: It can be found on one of these routes. execute the command:





show_compatibility_56 is deprecated because its only purpose is to permit control over deprecated system and status variable information sources that will be removed in a future MySQL release. When those sources are removed, show_compatibility_56 will have no purpose and will be removed as well.




Selection options GUI tool for mysql for purchase.

'mysql.proc' doesn't exist fixed problem


Table 'mysql.proc' doesn't exist. Fix error 1146 Table doesn't exist here...