- Plesk for Linux
Deleted in PHPMyAdmin STRICT_TRANS_TABLES setting is reverted after Plesk updates.
sql_mode is set to STRICT_TRANS_TABLES in /etc/my.cnf
# cat /etc/my.cnf | grep 'STRICT_TRANS_TABLES'
After every MySQL restart its configuration is loaded in accordance to
for Debian-based OS)
All changes done with direct MySQL queries are reverted.
1. Connect to the server via SSH
configuration file (
for Debian-based OS) with any preferable text-editor (vi, for example)