- 首先打开配置文件:
sudo gedit /etc/mysql/mysql.conf.d/mysqld.cnf
- 在 [mysqld]下加上两句:
general_log_file= /var/log/mysql/mysql.log
general_log = 1
3. 重启服务:
sudo service mysql restart
4.查看日志
sudo tail -f /var/log/mysql/mysql.log
sudo gedit /etc/mysql/mysql.conf.d/mysqld.cnf
general_log_file= /var/log/mysql/mysql.log
general_log = 1
3. 重启服务:
sudo service mysql restart
4.查看日志
sudo tail -f /var/log/mysql/mysql.log