Why do I get an \'Unknown System Variable \'lc_messages\'\' error when logging into phpMyAdmin?

Resolving the 'Unknown System Variable 'lc_messages'' Error in phpMyAdmin

When attempting to log in to phpMyAdmin with root credentials, users may encounter the following error:

SQL query:

SET lc_messages = 'en_US';

MySQL said: Documentation

#1193 - Unknown system variable 'lc_messages'

This error arises due to a compatibility issue between different versions of MySQL and phpMyAdmin. To rectify this issue, it is crucial to align the versions correctly.

Solution:

Verify your current MySQL version. If it is:

MySQL 5.5: Use phpMyAdmin version 4.4.x or higher.

MySQL 5.1: Use phpMyAdmin version 4.0.x.

By ensuring that the appropriate versions of MySQL and phpMyAdmin are coupled, users can circumvent this error and successfully log in to phpMyAdmin.

The above is the detailed content of Why do I get an \'Unknown System Variable \'lc_messages\'\' error when logging into phpMyAdmin?. For more information, please follow other related articles on the PHP Chinese website!