dbforge studio the 'information_schema.session_variables' feature is disabled

dbforge studio the 'information_schema.session_variables' feature is disabled

When I try to connect MySQL 5.7 I get the following error


Example:
















Solution:


Try to use Dbforge Studio Latest Version

Or
Keep the show_compatibility_56 always ON in MySQL.
Add the following line to the [mysqld] section of your MySQL configuration file (my.cnf or my.ini):
show_compatibility_56 = On
Then restart the MySQL server:

service mysql restart


Or


Keep the Temperary show_compatibility_56 ON in MySQL.

You must be logged with a user with super privileges in order to perform this action(Command line).
Run the following query in your MySQL database:
set @@global.show_compatibility_56=ON;

Post a Comment

0 Comments