Unknown system variable when opening phpmyadmin

Question

Error

SQL query: Edit Edit

SET lc_messages = 'en_US'; MySQL said: Documentation

1193 - Unknown system variable 'lc_messages'

Could you also please let us know what MySQL version you have installed? — Rajeev Radhakrishnan, Oct 03 '17 at 09:30

score 0 · Answer 1 · answered Oct 03 '17 at 09:45

0

Go to Shell (In xampp at right corner, third one)

Enter

mysql // Hit enter

SET lc_messages = 'en_US'; //Hit enter

Restart Mysql

answered Oct 03 '17 at 09:45

score 0 · Accepted Answer · answered Oct 03 '17 at 12:43

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