xieye114的专栏

http://www.cnblogs.com/sleepywang/archive/2008/10/22/1316825.html[code="java"][mysqld]log="d:/mysql.log"[/code]加了这句话，重启就可以了。====================================================...

新版本的pdo会有这个问题： General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to ru...

参考了http://www.centos.bz/2011/09/linux-compile-install-mysql-5-5-15-from-source/海哥centos blog centos  64位mysql5.5.14 yum install ncurses-devel 先确保删除原有的mysqlyum info installed |grep ...

都是抄的。添加最高权限用户假设root的密码是passwordGrant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;mysql修改用户表后的刷新权限命令flush privileges;上两个命令都是在mysql客户端执行。记得要删除空密码...

[code="java"]set global log_output='table';-- 查看mysql查询日志位置show variables like "%general_log%";-- 查看mysql记录到哪里show variables like "%log_output%";-- 设置会话变量的值 查询日志set global genera...