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

 

Var dette svaret til hjelp?

 Print

Les også disse

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 redirect domain with www ?

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

HOW TO INCREASE FILE UPLOAD SIZE IN ZPANEL / SENTORA

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