How to fix «The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled» in MySQL 5.7?

mysql
mysql-57

(Dmitry Fedyuk) #1

05


(Dmitry Fedyuk) #2

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

dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_show_compatibility_56