Comparison of graphical tools for MySQL

MySQL Tools Comparison.

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

Print PDF

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.




Create SSH tunnel for MySQL connections

Print PDF
User Rating: / 18

Today we consider the organization of SSH tunneling through PUTTY to MySQL.

Some programs require a connection to the database MySQL. For example mysql.exe console or other tools to work with databases of online stores or websites.

Very often, in the application, which requires a connection to the database MySQL, there are only 5 fields:

  • Host
  • Port
  • Login
  • Password
  • Database

Some hosting providers allow direct access to the databases from outside, but others provide access to MySQL only through SSH protocol.

To build a SSH tunnel from your local machine to the database on the hosting, we recommend using PuTTY.

Next, write out step by step process.

  • «
  •  Start 
  •  Prev 
  •  1 
  •  2 
  •  Next 
  •  End 
  • »

Page 1 of 2

HTTP-tunnel - Ability to manage MySQL database via the Internet. More...

'mysql.proc' doesn't exist fixed problem


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