google 查的 关键字 max_allowed_packet reset 1024
结果
http://mycodkit.blogspot.kr/2016/01/maxallowedpacket-in-mysql-is-getting.html?view=timeslide
http://*.com/questions/28979660/why-mysql-max-allowed-packet-reset-to-1m-automatically
总结及解决方法:
1. As mentioned earlier, if the user has super privileges, the connection established with that user has the right to reset the max_packet_size value.
super权限的用户有权限修改max_packet_size数值
2 create a new user. restart the components with new user name and password of the newly created mysql user.
mysql>CREATE USER 'UserName'@'hostname' IDENTIFIED BY 'Password';
mysql>GRANT SELECT ON *.* TO 'UserName'@'hostname';
mysql>GRANT INSERT ON *.* TO 'UserName'@'hostname';
mysql>GRANT UPDATE ON *.* TO 'UserName'@'hostname';
mysql>GRANT DELETE ON *.* TO 'UserName'@'hostname';
mysql>flush privileges;
最好是建立新的用户 重启应用.应用使用这个用户。
3. One more thing to note down is, its would always be better if the root user password is changed. It is recommended that root user is not used in any of the components for getting connections.
应用如果用的是root用户, 改root密码,不推荐root用户在其他的 应用 来取得连接,言下之意就是root 为一个应用独享。
google 查的 关键字 max_allowed_packet reset 1024
结果
http://mycodkit.blogspot.kr/2016/01/maxallowedpacket-in-mysql-is-getting.html?view=timeslide
http://*.com/questions/28979660/why-mysql-max-allowed-packet-reset-to-1m-automatically
总结及解决方法:
1. As mentioned earlier, if the user has super privileges, the connection established with that user has the right to reset the max_packet_size value.
super权限的用户有权限修改max_packet_size数值
2 create a new user. restart the components with new user name and password of the newly created mysql user.
mysql>CREATE USER 'UserName'@'hostname' IDENTIFIED BY 'Password';
mysql>GRANT SELECT ON *.* TO 'UserName'@'hostname';
mysql>GRANT INSERT ON *.* TO 'UserName'@'hostname';
mysql>GRANT UPDATE ON *.* TO 'UserName'@'hostname';
mysql>GRANT DELETE ON *.* TO 'UserName'@'hostname';
mysql>flush privileges;
最好是建立新的用户 重启应用.应用使用这个用户。
3. One more thing to note down is, its would always be better if the root user password is changed. It is recommended that root user is not used in any of the components for getting connections.
应用如果用的是root用户, 改root密码,不推荐root用户在其他的 应用 来取得连接,言下之意就是root 为一个应用独享。