[FIXED] Unknown system variable when opening phpmyadmin

Issue

Error

SQL query: Edit Edit

SET lc_messages = 'en_US'; MySQL said: Documentation

1193 - Unknown system variable 'lc_messages'

Solution

I had the same problem and here is how I fixed it:

Upgraded mysql to latest version: http://www.tecmint.com/install-latest-mysql-on-rhel-centos-and-fedora/ After the upgrade mysql service couldn't start. Here's the fix: mysqld_safe --skip-grant-tables mysql_upgrade

Answered By - faisal