MySQL ログファイルの設定

my.ini の [mysqld] セクションを変更


# General and Slow logging.

log-output=FILE

general-log=1

general_log_file="C:/MySQL/8_0/logs/DESKTOP-N923OK5.log"

slow-query-log=1

slow_query_log_file="C:/MySQL/8_0/logs/DESKTOP-N923OK5-slow.log"

long_query_time=10


# Binary Logging.

log-bin="C:/MySQL/8_0/logs/DESKTOP-N923OK5-bin"


# Error Logging.

log-error="C:/MySQL/8_0/logs/DESKTOP-N923OK5.err"



( 参考記事 )