Got a packet bigger than ‘max_allowed_packet

mysql开启远程访问权限错误

mysql需要开放远程访问端口,结果。。 mysql> update user set host =’%’ where user =’root’; ERROR 1062 (23000): Duplicate entry ‘%-root’ for key ‘PRIMARY’ root用户好几个,有几个没有密码 mysql> update user set password = PASSWORD(‘xxx’) where user=’root’ -> ; 删除最后一个root用户: localhost root 然后确保有一个%就可以了。

WP后台登陆失败

WP后台登陆不进去,原来表有点小问题。。。

mysql-bin.000001-x

发达了,mysql-bin占了我9g空间啊,大汗一把: 20K mysql-bin.000001 700K mysql-bin.000002 4.0K mysql-bin.000003 4.0K mysql-bin.000004 4.0K mysql-bin.000005 4.0K mysql-bin.000006 4.0K mysql-bin.000007 4.0K mysql-bin.000008 4.0K mysql-bin.000009 4.0K mysql-bin.000010 11M mysql-bin.000011 63M mysql-bin.000012 368K mysql-bin.000013 256K mysql-bin.000014 9.5M mysql-bin.000015 1.8M mysql-bin.000016 11M mysql-bin.000017 508K mysql-bin.000018 45M mysql-bin.000019 146M […]

lnmp、mono与asp.net环境安装

kloxo虽然比较强大,但是太耗资源,有些东西不一定需要,所以决定还是装LNMP。另外需要调试下ASP.NET程序,把MONO也装上了,使用fastcgi、mysql和nginx。 1.安装lnmp

asp.net支持 2.编译安装mono 2.0

3.安装完毕后可以通过“mono -V”查看mono版本

4.安装fastcgi-mono-server

  下面的方法经测可用 #yum groupinstall Mono But I noticed the version of Mono I installed is 1.2.4, seems that the lastversion of mono (2.4.2.3) is not in the CentOS […]

从数据库随机读取数据

示例代码: SQL Server:Select Top * From  表 Order By NewID()   Access  :Select Top * From 表 Order By Rnd(ID)          *说明-Rnd(ID) 其中的ID是自动编号字段,可以利用其他任何数值来完成,比如用姓名字段(UserName)  Select Top 10 * From 表 Order BY Rnd(Len(UserName))   MySql:Select * From 表 Order By Rand() Limit […]