Can't connect to MySQL: Unknown system variable 'lc_messages'

337 views Asked by At

Last week I was working without problem in a laravel project with a MySQL database in the localhost and two days ago when I tried to connect to phpmyadmin this message appeared:

Error
SQL query: Edit Edit
SET lc_messages = 'en_US';

MySQL said: Documentation

#1193 - Unknown system variable 'lc_messages'

I have made my research in internet, uninstalled wamp, deleted the wamp folder and reinstalled the newest version,

I found and followed these instructions:

Nothing worked.

I've checked the my.ini file and it is configured as expected:

lc-messages-dir="c:/wamp64/bin/mysql/mysql5.7.19/share"  
lc-messages=en_US   

And my laravel project is not working because it can't connect to MySQL either.
I'm working on a Windows 10 computer and my installed versions are:

  • PHPMyAdmin 4.7.4
  • MySQL 5.7.19
  • WAMP 3.1.0
  • PHP 7.1.9

I really have no idea what else to do, I just want the project to work and any help is really appreciated, thanks!

Edit: To be clear, I have already checked other stackoverflow questions on this subject and they didn't work, that's why I asked this question

0

There are 0 answers