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 然后确保有一个%就可以了。

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 […]