打开mysql日志记录的方法

一。首先登录到数据库: cd /opt/redmine.org.cn/mysql/bin ./mysql -h127.0.0.1 -P3307&nbs…

一。首先登录到数据库:

cd /opt/redmine.org.cn/mysql/bin

./mysql -h127.0.0.1 -P3307 -uroot -p11111231113;

use bitnami_redmine;

二。查看日志是否打开,及日志路径:

show variables like "%general_log%";

三。打开个全局变量

mysql> set global general_log=on;
Query OK, 0 rows affected (0.00 sec)

作者: admin

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam viverra euismod odio, gravida pellentesque urna varius vitae. Sed dui lorem, adipiscing in adipiscing et, interdum nec metus. Mauris ultricies, justo eu convallis placerat, felis enim ornare nisi vitae.

为您推荐

联系我们

联系我们

返回顶部