Home > Database > Mysql Tutorial > body text

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

Linda Hamilton
Release: 2024-10-30 17:00:26
Original
267 people have browsed it

Why do I get an

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'
Copy after login

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!

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!