Computer Science, asked by afrin6731, 1 year ago

How to enable MySQL Query Log?

Answers

Answered by Anonymous
17

Slow Query Log in MySQL. To enable or change file path of MySQL slow query logs. Edit MySQL configuration file and uncomment or add the following line in [mysqld] section. This file contains logs of those queries which is taking more time to complete

  • Go to > General Configuration > Logging and Profiling.
  • Choose Enable SQL Logging.


Anonymous: hello
Answered by anuj00799
1
SET global general_log = 1
SET global log_output = ' table ' ;

hope it was helpful plz mark as brainliest please
thankq
Similar questions