I have a Windows MySQL server running (5.6), and in the
my.ini
file I have the following directive under [mysqld]:
lc_time_names = 'fr_FR';
But it has ZERO effect. When I start up the server, all time names are still in English. If I then launch Workbench and issue the following command:
SET GLOBAL lc_time_names = 'fr_FR';
it works and the times are changed. Is there something different I need to do in my.ini
?
UPDATE (VERY IMPORTANT):
in addition to needing to put this value in the correct ini file, you also need to NOT ADD QUOTES!! I broke my server with the above, and it took me forever to figure out I needed to change the line to
lc_time_names = fr_FR
WITHOUT THE QUOTES, or your MySQL server will not start up! Hope this helps someone else.
Asked by Stephen
(111 rep)
Oct 21, 2015, 08:25 AM
Last activity: Apr 16, 2025, 02:07 AM
Last activity: Apr 16, 2025, 02:07 AM