#1193 - Unknown system variable 'lc_messages' when trying to login to phpmyadmin

Question

I have recently installed MySQL and phpMyAdmin, but when I try to login to phpMyAdmin with the root credentials I get the following error for this query:

SQL query:

SET lc_messages = 'en_US';

MySQL said: Documentation

#1193 - Unknown system variable 'lc_messages'

Why am I experiencing this error?

Answer 1

I faced the same problem. Check your mySQL version:

For mySQL 5.5, use phpMyAdmin 4.4.x and above

For mySQL 5.1, use phpMyAdmin 4.0.x

Hope this helps someone.

Answer 2

It isn't true. PhpMyAdmin can work with older Mysql as always.

Quick fix is easy

• in /usr/share/phpMyAdmin/libraries/common.inc.php delete these lines

if (PMA_MYSQL_INT_VERSION < $cfg['MysqlMinVersion']['internal']) {
  PMA_fatalError(
    __('You should upgrade to %s %s or later.'),
    array('MySQL', $cfg['MysqlMinVersion']['human'])
  );
}

or

• in /usr/share/phpMyAdmin/libraries/classes/DatabaseInterface.php delete these lines

if (! empty($locale)) {
  $this->query("SET lc_messages = '" . $locale . "';", $link, self::QUERY_STORE);
}

Reference https://github.com/phpmyadmin/phpmyadmin/issues/12822