How to enable show_compatibility_56 variable for MySQL 5.7?

Created:

2017-04-09 19:12:28 UTC

Modified:

2017-08-08 13:44:54 UTC

0

Was this article helpful?


Have more questions?

Submit a request

How to enable show_compatibility_56 variable for MySQL 5.7?

Applicable to:

  • Plesk for Linux

Question

How to enable show_compatibility_56 variable for MySQL 5.7

Answer

  1. Find and add the following directives in my.cnf file

    #cat /etc/mysql/my.cnf | grep show_compatibility_56
    
    show_compatibility_56=ON

Here is location of my.cnf depending on Linux distribution

RHEL/CentOS

/etc/my.cnf

Debian/Ubuntu

/etc/mysql/my.cnf
  1. Restart MySQL service:

    #service mysql restart
    
  2. Check that variable is set:

    # plesk db "SHOW SESSION VARIABLES where Variable_name like '%show_compatibility%'"
    
    +-----------------------+-------+
    | Variable_name | Value |
    +-----------------------+-------+
    | show_compatibility_56 | ON |
    +-----------------------+-------+
Have more questions? Submit a request
Please sign in to leave a comment.