Keep show_compatibility_56 always enabled in MySQL

Question

I needed to set the system variable "show_compatibility_56" to ON in MySQL. So, I run the command set global show_compatibility_56 = on;and it works. However, I noticed that whenever I stop and then start the MySQL server, this variable returns to OFF. Any tips on how to keep always ON , even if I restart the server?

Answer 1

I am using the Laravel Homestead (Vagrant) field (MySql Ver 14.14 Distrib. 5.7.17).

I needed SSH in Homestead and then run:

echo "[mysqld]
show_compatibility_56 = ON
performance_schema" | sudo tee -a /etc/mysql/conf.d/mysql.cnf  >/dev/null    
sudo service mysql restart

( Mark Reed, , vim.)

:

sudo vim /etc/mysql/conf.d/mysql.cnf

:

[mysqld]
show_compatibility_56 = ON
performance_schema

, , [mysqld] [mysql], MySql:

sudo service mysql restart

Answer 2

my.cnf linux my.ini .

Answer 3

Zafar, , .

, . :

show_compatibility_56 , - , MySQL. , show_compatibility_56 .

Answer 4

, MySQL, :

show_compatibility_56 =

Linux: my.cnf, /etc/my.cnf

For a Windows-based system: The file name is my.ini , and the default location is your mysql data directory on Windows, which you can check with the command below:

show variables of type 'datadir';