xampp\mysql\bin\my.ini
copy and paste below codes under group [mysqld]
[code]
#logging sql
log="D:/xampp/mysql/log.txt"
#logging slow query
log-slow-queries="D:/xampp/mysql/logslowquery.txt"
long_query_time=1
[/code]
mysql tips
mysql> show variables like '%log%'\g
mysql> show databases\g
dos> mysql -u root -p pass
copy and paste below codes under group [mysqld]
[code]
#logging sql
log="D:/xampp/mysql/log.txt"
#logging slow query
log-slow-queries="D:/xampp/mysql/logslowquery.txt"
long_query_time=1
[/code]
mysql tips
mysql> show variables like '%log%'\g
mysql> show databases\g
dos> mysql -u root -p pass