title: MySQL 5.7 show_compatibility_56
body: <p>Recently, I decided to get a VPS server and host my own forums as we grew too big for your average shared hosting platform. I thought it would be easy to setup and get going, and it has been for the most part, but I have hit a brick wall with a hellish MySQL error.</p>
  
  <p>Basically, I am trying to upload my old database inside PHPMYADMIN, but I keep getting the same  error bounce back. I have followed some excellent guides, such as those from Digital Ocean, but there doesn't seem to be much on this error, and the information is out there isn't working for me.</p>
  
  <p>Here is the error:
  Error
  SQL query: Documentation</p>
  
  <pre><code>/*!50112 SELECT COUNT(*) INTO @is_rocksdb_supported 
  FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE   
  VARIABLE_NAME='rocksdb_bulk_load' */
  MySQL said: Documentation
  #3167 - The INFORMATION_SCHEMA.SESSION_VARIABLES feature is disabled; 
  see the documentation for show_compatibility_56
  </code></pre>
  
  <p>I have tried adding <code>show_compatibility_56 = ON</code> inside my config file <code>/etc/mysql/my.cnf</code>, I get the following error:</p>
  
  <p>"Job for mysql.service failed because the control process exited with error code." add when I go to PHPMYADMIN it says "Connection for controluser as defined in your configuration failed." and " #2002 - No such file or directory<br />The server is not responding (or the local server's socket is not correctly configured)."</p>
  
  <p>I can tell you show_compatibility_56 is turned off as it shows it is turned off inside PHPMYADMIN.</p>
  
  <p>Can anyone tell me how to turn it on?</p>
  
  <p>I am using Ubuntu 16.04 with LAMP</p>