php - #1193 - Unknown system variable 'lc_messages' when trying to login to phpmyadmin

User 2:
I had a similar frustrating experience with the 'lc_messages' error in phpMyAdmin, and it took me a while to troubleshoot it. After experimenting with different solutions, here's what eventually resolved the issue for me:

1. Locate your MySQL configuration file. On my CentOS server, it was located at `/etc/my.cnf`, but in some cases, it might be located at `/etc/mysql/my.cnf` or another directory.

2. Open the configuration file using a text editor.

3. Look for the `[mysqld]` section within the file. If the section doesn't exist, you can add it at the end of the file.

4. In the `[mysqld]` section, add or modify the following line:
`init_connect='SET collation_connection = utf8_general_ci'`

This line sets the collation connection value to 'utf8_general_ci'. You can adjust this value based on your preferred collation.

5. Save the changes and close the file.

6. Restart the MySQL service to apply the configuration changes. Use the command:
`sudo systemctl restart mysqld`

Now, try accessing phpMyAdmin again. This solution worked for me, and the 'lc_messages' error was no longer present.

I hope this solution works for you too. If you come across any further issues or if you need additional assistance, feel free to ask. Good luck!

User 1:
I had a similar issue with phpMyAdmin and the 'lc_messages' variable. In my case, the problem was related to the MySQL server configuration. Here's what I did to resolve the issue:

1. Open the MySQL configuration file using your preferred text editor. Usually, it is located at `/etc/my.cnf` or `/etc/mysql/my.cnf`.

2. Look for the `[mysqld]` section in the configuration file. If it doesn't exist, add it at the end of the file.

3. Within the `[mysqld]` section, add the following line:
`lc-messages = en_US`

This sets the 'lc-messages' variable to the English language. You can specify a different language if preferred.

4. Save the changes and exit the text editor.

5. Restart the MySQL service for the changes to take effect. On CentOS, you can do this by running the command:
`sudo systemctl restart mysqld`

6. Now try accessing phpMyAdmin again and see if the 'lc_messages' error still occurs.

In my case, after applying these steps, the error disappeared, and I was able to log in to phpMyAdmin without any issues. Hopefully, this solution works for you too. Give it a try and let us know if you encounter any further problems or if there's anything else we can assist you with.

Related Topics

• Insert PHP file in functions.php then echo variables from that file in Wordpress
• PHP Session Variable Lost On The Same Page
• oop - PHP: Class vs Instance variables
• performance - PHP: Check if variable is type of string AND is not empty string?
• Using isset or is not set with variable in PHP?
• How to allow a column variable to be changed only once with PHP/MySQL?
• hyperlink - How to use $_GET variable (index.php?cat=about)
• Passing php variable into Twig - Documentation throwing errors
• PHP - how to get a variable's name?
• mysql - How to increment a variable in php using the date in PHP

User 3:
I also encountered the dreaded 'lc_messages' error when I tried logging in to phpMyAdmin. It was quite frustrating, but I managed to resolve it by taking a slightly different approach. Here's what worked for me:

1. Check if your MySQL server version is compatible with your phpMyAdmin version. In some cases, this error can occur due to version incompatibility. Ensure that they are compatible and update either of them if necessary.

2. If you're using a customized my.cnf file, make sure there are no conflicting configurations. Incorrect configurations can often lead to the 'lc_messages' error. Double-check your my.cnf file and remove or modify any conflicting settings.

3. Another potential cause can be related to the MySQL client libraries on your server. Ensure that you have the latest MySQL client libraries installed. If not, try updating them and check if the error persists.

4. Clear your browser cache and cookies. Sometimes, stored cache or outdated cookies can interfere with logging into phpMyAdmin. Clearing them might help eliminate any related issues.

5. If you have access to the MySQL server command line, try running the following command:
`SET lc_messages = 'en_US';`

This explicitly sets the 'lc_messages' variable to English. Replace 'en_US' with your preferred locale if needed.

6. Finally, restart both the MySQL and web server services to apply any changes made throughout the troubleshooting process.

By following these steps, I managed to get rid of the 'lc_messages' error and successfully logged in to phpMyAdmin. I hope this helps you as well. If you have any further questions or encounter any other difficulties, don't hesitate to ask. Good luck!

More Topics Related to PHP

• What are the recommended PHP versions for different operating systems?
• Can I install PHP without root/administrator access?
• How can I verify the integrity of the PHP installation files?
• Are there any specific considerations when installing PHP on a shared hosting environment?
• Is it possible to install PHP alongside other programming languages like Python or Ruby?

More Topics Related to Server

• How can I use Terraform or Ansible to automate the deployment of PHP applications on cloud platforms?
• How can I troubleshoot common issues with PHP-FPM installations?
• Can I configure PHP-FPM to use different PHP settings or extensions for different virtual hosts?
• How can I configure PHP-FPM to limit resource usage and prevent potential denial-of-service (DoS) attacks?
• Are there any known performance tuning options or optimizations for PHP-FPM installations?

More Topics Related to Configuration

• How can I configure macOS to use PHP from the command line?
• How can I configure PHP to work with the built-in macOS web server (Apache) or other web servers like Nginx?
• How can I configure PHP to work with Apache HTTP Server on Windows?
• Can I install PHP on Windows systems without using an installer package?
• How can I configure PHP to send email using the SMTP protocol on Windows?