Serverpilot - Disable Strict SQL Mode in MySQL 5.7

disable-strict-mode.sh

#!/bin/bash
if [ -e /etc/mysql/conf.d/disable_strict_mode.cnf ]; then
	echo "Disable strict mode config already exists"
else
	touch /etc/mysql/conf.d/disable_strict_mode.cnf
	echo "Creating file..."
	echo "Adding config..."
	printf "[mysqld]\nsql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION\n" > /etc/mysql/conf.d/disable_strict_mode.cnf
	echo "Restarting MySql..."
	service mysql restart
	echo "Done"
fi

How To Disable Strict SQL Mode in MySQL 5.7.MD

How To Disable Strict SQL Mode in MySQL 5.7

I wrote a quick script for those that provision servers often enough.

To get this to work take the following steps

1. Log into your server as root
2. Get script wget https://gist.githubusercontent.com/nfourtythree/90fb8ef5eeafdf478f522720314c60bd/raw/disable-strict-mode.sh
3. Make is executable chmod +x disable-strict-mode.sh
4. Run the script ./disable-strict-mode.sh
5. ??
6. MySQL without strict mode (profit)

Hope at least one person finds this useful.

Dude I tried this guide in my puTTY via php 5.6 and it worked like charm, you are genius seriously. God bless u 👍

@waderin1987 no worries! Glad it worked for you

Bro awesome work... i have tried many things but you have made it very simple and easy thank you..

You are my favorite person, thank you!

Thank you!

Not working with MariaDB version 10.3.25 :( any clue?

@IniAku unfortunately not. I don't have a need for this anymore and therefore haven't tried it in a long time