nfourtythree/How To Disable Strict SQL Mode in MySQL 5.7.MD

## 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

      
    Raw
  

              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

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

Hope at least one person finds this useful.
	#!/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