Change Plesk default language
If you only have paid for a basic Plesk Licence and need to change the default language pack from english to other this are the instructions. This is a sample to change it to Spanish.
Please follow the below mentioned steps to help resolve the issue :
- Create Plesk database backup:
# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa > /root/psa_backup.sql
- Stop Plesk CP:
# /etc/init.d/psa stop1
- Login into Plesk database:
# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
- Find what locales are available in Plesk:
mysql> select * from locales;
+-------+--------+
| id | active |
+-------+--------+
| es-ES | false |
| en-US | true |
+-------+--------+
- In table ‘misc’ replace ‘en-US’ with desired locale name what you found in the step 3 ( for example ‘es-ES’) in ‘admin_locale’ and ‘def_locale’:
mysql> update misc set val="es-ES" where param in
mysql> ("admin_locale","def_locale");
- In table ‘mn_param’ replace ‘en-US’ with the desired locale:
mysql> update mn_param set val="es-ES" where val="en-US";
- In table ‘clients’ replace locale for all clients:
mysql> update clients set locale="es-ES";
- In table ‘module_watchdog_param’:
mysql> update module_watchdog_param set val="es-ES" where
mysql> param="locale";
- In ‘dom_param’ there are locales for each domain:
mysql> update dom_param set val="es-ES" where param="locale";
- Change locale for mailboxes in the ‘Parameters’ table:
mysql> update Parameters set value="es-ES" where Parameter in
mysql> ("s:locale", "s:country_locale");
- Also, in order to keep everything correct, alter locales table to display active locale correctly:
mysql> update locales set active="false" where id="en-US"; update
mysql> locales set active="true" where id="es-ES";
- Exit from MySQL:
mysql> quit
- Start Plesk CP:
# /etc/init.d/psa start
Good luck
