Cannot install Plesk: ERROR 1146 (42S02) at line 1: Table 'psa.misc' doesn't exist

Symptoms

1. Plesk cannot be installed:

   PLESK_INFO: ERROR 1146 (42S02) at line 1: Table 'psa.misc' doesn't exist

2. Plesk autoinstaller cannot create 'psa' database. Also, it is not possible to create the database manually:

   # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa < /usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/db/psa_db.sql
   ERROR 1364 (HY000) at line 141: Field 'pname' doesn't have a default value

3. MySQL server is running in strict mode:

   # plesk db "show variables like 'sql_mode'"
   sql_mode      | STRICT_TRANS_TABLES,STRICT_ALL_TABLES

Cause

Strict mode does not allow inserting NULL value into a NOT NULL column.


Resolution

1.  Login to the server over SSH
2.  Disable the strict mode in /etc/my.cnf (RHEL/Centos) or /etc/mysql/my.cnf (Debian/Ubuntu):

   CONFIG_TEXT: [mysqld]
   sql_mode=""

3.  Restart MySQL server:

   # service mysql restart || service mariadb restart || service mysqld restart