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 Set Up Apache Virtual Hosts on CentOS 7

install apache yum -y install httpd Create the Directory Structure mkdir -p /var/www/example.com/public_html mkdir -p /var/www/example2.com/public_html Grant Permissions chown -R $USER:$USER /var/www/example.com/public_html chown -R $USER:$USER /var/www/example2.com/public_htm   ensure that read access is permitted to the general web directory chmod -R… 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