MYSQL How to turn off ONLY_FULL_GROUP_BY

Disable FULL_GROUP Mode via my.cnf Disable it by setting your own SQL_MODE in the my.cnf file, then restart MySQL. SQL_MODE should be something like this sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION most important is to remove ONLY_FULL_GROUP_BY values from SQLMODE after changing the mode, now restart mysql

how to disable mysql strict mode

Disable Strict Mode via my.cnf Disable it by setting your own SQL_MODE in the my.cnf file, then restart MySQL. SQL_MODE should be something like this sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION most important is to add NO_ENGINE_SUBSTITUTION along side other values. after changing the mode, now restart… Continue Reading

How To Install MySQL on CentOS 7

In a web browser, visit: https://dev.mysql.com/downloads/repo/yum/   Locate the desired version, and replace it in the below command as an example wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm   install the RPM rpm -ivh mysql57-community-release-el7-9.noarch.rpm   now u can use yum to install mysql server… Continue Reading