By m-blog → Wednesday, May 30, 2018
Berikut ini adalah cara untuk mengatasi Error "#1193 - Unknown system variable 'lc_messages'" saat login ke MySql Server menggunakan phpMyAdmin :

  1. Buka file common.inc.php (Path : phpMyAdmin\libraries\common.inc.php), lalu hapus / remark baris code berikut ini :
    if (PMA_MYSQL_INT_VERSION < $cfg['MysqlMinVersion']['internal']) {
    PMA_fatalError(
    __('You should upgrade to %s %s or later.'),
    array('MySQL', $cfg['MysqlMinVersion']['human'])
    );
    }
    Lalu simpan.
  2. Buka file DatabaseInterface.php (Path : phpMyAdmin\libraries\DatabaseInterface.php), lalu hapus / remark baris code berikut ini :
    if (! empty($locale)) {
    $this->query(
    "SET lc_messages = '" . $locale . "';",
    $link,
    self::QUERY_STORE
    );
    }
    Lalu Simpan.
  3. Selesai.
Martin Tobing

I'm Martin Tobing. A full time web programmer. I enjoy to make website and web application in PHP.

1 One Comment " #1193 - Unknown system variable 'lc_messages' Saat Login Melalui PhpMyAdmin "

Repute Agency February 8, 2023 at 6:35 PM

Thanks for sharing this blog.
Best Digital Marketing Services Provider in Coimbatore
The Role of Social Media Marketing Services in Indian Businesses