mysql数据库服务器命令执行语句日志

在安装好的MySQL 数据库服务器的目录中找到my.ini文件，
在最后一行加上：

log=D:/Program Files/MySQL/MySQL Server 5.1/log.txt

重启，打开log.txt即可看到效果。


今天遇到的编码设置参数：

SET collation_server = gb2312_chinese_ci;

SET collation_database = gb2312_chinese_ci;

SET collation_connection =gb2312_chinese_ci;

SET character_set_client =utf8;

SET character_set_connection =utf8;

SET character_set_database =utf8;

SET character_set_results =utf8;

SET character_set_server =utf8;

SET character_set_system =utf8;