Search code examples
phpmysqlphpmyadminwampwampserver

WAMPServer Install - Error on phpMyAdmin login - Error #1193

I'm trying to set up WAMPServer for the first time on my personal computer to do some WordPress work. When I try to log into phpadmin with the root login, I get an error screen. The Error reads as such:

SQL query: Edit

SET lc_messages = 'en_US';

MySQL said:

1193 - Unknown system variable 'lc_messages'

I've tried running PHP version 7.0.10 and 5.6.25 but the errors occurred on both.

I'm running MySQL version 5.7.14

I've tried looking at a StackOverflow forum with the same issue, linked here, but none of the suggested fixes worked for me there, since I'm running a pretty updated version of phpMyAdmin.

Solution

  • 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.