#1193 - Unknown System Variable 'Lc_Messages' When Trying to Login to PHPmyadmin

WAMPServer Install - Error on phpMyAdmin login - Error #1193

The correct name for that parameter is lc-messages note a hyphen and not an underscore.

Have you amended anything in the 'my.ini'?

RE: Your Comment

Then potentially you have another MySQL runing or maybe just a rouge my.ini file on your system.

Search for my.ini and if you find it anywhere other then inside the \wamp\ or \wamp64\ folders, remove or rename it. There should not be one outside the wamp folder structure.

Unknown system variable when opening phpmyadmin

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

SET lc_messages = 'en_US' - Unknown system variable 'lc_messages' EVEN the version is updated

I found out that I have two sql running in the same systeme . So i deleted the processor of sql server with task manager and rerun my wamp server and it seems everything works fine.

Unknown system variable when opening phpmyadmin

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

MySQL Error Code: 1193. Unknown system variable

According to MySQL docs, the error #1193 occurs when you use wrong code for SQLSTATE.

Message: Unknown system variable %s

And, as you can see on the same page, the SQLSTATE 99003 is not defined.

---

Related Topics