phpMyAdmin, lc_massages error

[Pauchri]

Creating a database is not a problem.
But phpMyAdmin displays the following error:

SET lc_messages = 'nl_NL'
#1231 - Variable 'lc_messages' can't be set to the value of 'nl_NL'

I deleted the database, create new one.
But the error is coming back.
What is wrong and how do I change it.
Thanks

 

[SeLLeRoNe]

Are you using a custom config?
It seems that the problem is the language set in phpMyAdmin.

Have you tryed to re-install it?

Regards

 

[Arieh]

Just had this error on a CloudLinux box.

In my case I was able to trace it back to /etc/yum.conf which contained:

override_install_langs=en_US.utf8

This will cause the system not to install locales other than en_US in /usr/share/locale/

After commenting out this line and doing

yum reinstall glibc-common

Locales are installed. (source)

Then I had to reinstall MariaDB/MySQL for it to take in effect.