How to change MySQL mode / Remove ONLY_FULL_GROUP_BY?

How to change MySQL mode / Remove ONLY_FULL_GROUP_BY?

Method 1:
Remove ONLY_FULL_GROUP_BY from MySQL console
 
mysql >SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
-----------------------------------------------------------------

Method 2: (ubuntu commands)

  1. sudo nano /etc/mysql/my.cnf

  2. [mysqld]  
sql_mode ="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

  3. sudo service mysql restart to restart MySQL

    This will disable ONLY_FULL_GROUP_BY for ALL users

-----------------------------------------------------------------

Method 3: (Easy)

  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. DONE!

You can keep the script where you downloaded it for future mods or references or you can rm -rf disable-strict-mode.sh and delete the shell script.

You will then have MySQL 5.7 without strict mode.

DISCLAIMER: Not sure if it works with version 8.0

 

Was this answer helpful?

 Print this Article

Also Read

How to start own Internet radio station?

Internet Radio HostingStart your very own radio station online - [VIEW PLANS] Effectively make...

How to redirect old domain to new domain ?

Step 1:  Create/Edit a file .htaccess in the documbent root (public_html / www folder)of your old...

How to redirect old URL to new URL ?

Step 1:  Create/Edit a file .htaccess in the documbent root (public_html / www folder)of your...

How to force all web traffic to use HTTPS ?

// // SSL Certificate Properly Installed & Working Require, To Use It.If you've no SSL...

HOW TO INCREASE FILE UPLOAD SIZE IN ZPANEL / SENTORA

Increasing Max Upload Size in ZPanel / SENTORA / Linux VPS / CentOs 6 ZPanel / Sentora server...