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

Symptoms

Plesk cannot be installed:

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

Plesk autoinstaller cannot create 'psa' database. Also, it is not possible to create 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

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:

For Ubuntu/Debian:

# service mysqld restart

For CentOS/RHEL/CloudLinux:

# service mariadb restart