Magari leggere meglio...

Any client can examine the value of lc_time_names or set its SESSION value to affect the locale for its own connection.
SET lc_time_names = 'it_IT'

Occhio alla versione di mysql però