Error on PHPMyAdmin

1

Hello I hope everyone is fine,

I’m getting a weird error that I have a really hard time to fix.

Everytime I try to log on phpmyadmin I get this message:

SET lc_messages = 'fr_FR';

MySQL a répondu : Documentation

#1231 - Variable 'lc_messages' can't be set to the value of 'fr_FR'

Which is weird because those packages are correctly installed, and no matter what I set like fr_FR.UTF-8, etc, nothing works

I really don’t care to show it in French, I’m ok with english, is there a way to change that? Because no matter where I click at the moment, it ends getting me logged out because of this error.

Thanks!

2

Hi @Jollip,

Take a look to this post:

Before doing any change, double check that you are in the same situation because instead of changing mysql to mariadb maybe your case is the opposite and you must change mariadb to mysql.

If you are unsure, show the output of these commands:

grep -r lc-messages-dir /etc/mysql/
ls -ld /usr/share/{mariadb,mysql}
2 Likes
3

Thank you so much for your reply!

Here are the outputs:

vnc

4

Use this command as root and try again:

ln -s /usr/share/mysql /usr/share/mariadb
3 Likes
5

I did it the output is blank (nothing returned)

6

That’s expected, try to access phpmyadmin.

3 Likes
7

waow you are a wizard! thank you soooo much that fixed it

3 Likes