Sample Header Ad - 728x90

`lc_time_names` has no effect

1 vote
1 answer
2569 views
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