Error while installing ~ vtiger CRM

 MySQL Server should be configured with: sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

solution: 

Fire this query through the root user in MySQL

SET GLOBAL sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

And check if the settings are applied by firing the query as follows

SHOW GLOBAL VARIABLES LIKE 'sql_mode';

vtigercrm -> Database charset or collation not compatible with UTF8

Solution:

create a db with utf8mb4_general_ci