Can you tell me the location of for the MySQL error log file under Debian or Ubuntu Linux? How do I view error log file?
The data directory is also the default location for other information such as log files and status files. However, under Debian and Ubuntu Linux the MySQL error log file location is as follows:
- /var/log/mysql.err – MySQL Error log file
- /var/log/mysql.log – MySQL log file
You can use the commands as follows:
grep 'something' /var/log/mysql.err tail -f /var/log/mysql.err less /var/log/mysql.err
grep ‘something’ /var/log/mysql.err
tail -f /var/log/mysql.err