MYSQL-TOOLS

Comparison of graphical tools for MySQL

Home

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

Печать PDF
Рейтинг пользователей: / 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 VARIABLES LIKE '%dir%';

 

IMPORTANT:

Note:

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.

 

 

 

How create data source in Visual Studio with data from My SQL tables with FK. more...

'mysql.proc' doesn't exist fixed problem

_

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