jonny-rimek/log.sql

Created August 13, 2020 17:45

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/jonny-rimek/c74390d4609a47a467732c02c7b64af3.js"></script>
Save jonny-rimek/c74390d4609a47a467732c02c7b64af3 to your computer and use it in GitHub Desktop.

Download ZIP

Create query log in MySQL 8

Raw

log.sql

	SET GLOBAL general_log = 'ON';
	SET GLOBAL general_log_file = '/var/log/mysql/all.log';
	SET GLOBAL general_log = 'OFF';

	tail -f -n0 /var/log/mysql/all.log

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