Unknown system variable when opening phpmyadmin [d

问题:

This question already has an answer here:

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

Error

SQL query: Edit Edit

SET lc_messages = 'en_US'; MySQL said: Documentation

1193 - Unknown system variable 'lc_messages'

回答1:

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

回答2:

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

Enter

mysql // Hit enter

SET lc_messages = 'en_US'; //Hit enter

Restart Mysql