syn-arch/mysqld.conf

Last active November 27, 2021 13:44

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/syn-arch/4977e9d32b5febcbb86760cc4a15fcd4.js"></script>
Save syn-arch/4977e9d32b5febcbb86760cc4a15fcd4 to your computer and use it in GitHub Desktop.

Download ZIP

SELECT list is not in GROUP BY clause and contains nonaggregated column .... incompatible with sql_mode=only_full_group_by

Raw

mysqld.conf

	Step 1:

	sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
	Step 2: Go to last line and add the following

	sql_mode = ""
	Step 3: Save

	Step 4: Restart mysql server.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment