\'phpMyAdmin Login Error: \'Unknown System Variable \'lc_messages\'\' – How to Fix?\'

phpMyAdmin Login Error: "Unknown System Variable 'lc_messages'" Solved

When attempting to access phpMyAdmin using root credentials, you may encounter the following error:

SET lc_messages = 'en_US';

MySQL said: Documentation
#1193 - Unknown system variable 'lc_messages'

Cause:

This error typically occurs due to a mismatch between the MySQL version and the phpMyAdmin software.

Solution:

To resolve this issue, verify the version of MySQL installed on your system and ensure that you are using the compatible version of phpMyAdmin:

• For MySQL 5.5: Use phpMyAdmin version 4.4.x or higher.
• For MySQL 5.1: Use phpMyAdmin version 4.0.x.

Ensure that your installed version of phpMyAdmin corresponds to the MySQL version to avoid this error.

The above is the detailed content of 'phpMyAdmin Login Error: 'Unknown System Variable 'lc_messages'' – How to Fix?'. For more information, please follow other related articles on the PHP Chinese website!