Where is the MySQL log in Linux-linux operation and maintenance

1. First log in to mysql: >mysql -u root -p 2. Then check whether the log is enabled (recommended learning: Linux video tutorial) mysql>show variables like & # 39; log_% & # 39;; 3. View the current log mysql> show master status; 4. The log type of mysql you need to know: Error log: -log-err Query log: -log Slow query log: -log-slow-queries Update log: -log-update Binary log: -log-bin 5. Modify the configuration /etc/my.cnf (the following is the log file storage location) [mysqld] log=/var/log/mysqld_common.log log-error=/var/log/mysqld_err.log log-bin=/var/log/mysqld_bin.bin For more Linux operation and maintenance related tutorials, please pay attention to PHP Chinese website! The above is the detailed content of where is the MySQL log in Linux, please pay attention to other related articles on 1024programmer.com for more information!