Where is max allowed packet

The second specifies the value in megabytes. For variables that take a numeric value, the value can be given with a suffix of K , M , or G either uppercase or lowercase to indicate a multiplier of , 2 or 3.

If you like, underscores in an option name can be specified as dashes. The following option groups are equivalent. Both set the size of the server's key buffer to MB:. In older versions of MySQL, program options could be specified in full or as any unambiguous prefix. For example, the --compress option could be given to mysqldump as --compr , but not as --comp because the latter is ambiguous. In MySQL 5. This is because prefixes can cause problems when new options are implemented for programs and a prefix that is currently unambiguous might become ambiguous in the future.

Some implications of this change:. The --key-buffer option must now be specified as --key-buffer-size. Thanks seems to be working even though I had hoped this would be possible without having to modify ini files manually. Konerak, Who was the taunter? It seems rather pointless to give someone an answer and then tell them they should go check Google for an answer. Especially since, SO is invariably occupies several of the top results for any decent programming related question.

Talk about programming an infinite loop!!! Make sure it is under [mysqld] and not [mysql] very similar. Cost me some minutes of headscratching. Show 6 more comments. TehShrike TehShrike 9, 2 2 gold badges 36 36 silver badges 28 28 bronze badges.

Not helps :. It displays "Query OK, 0 rows affected 0. If you disconnect and reconnect you'll see the updated value. Matt Crinklaw-Vogt is right. It needs exit and connect again — makriria. Show 5 more comments. Garbit 5, 6 6 gold badges 37 37 silver badges 70 70 bronze badges. Would it be better to litter this answer with instructions on setting up sudo for the first time?

A user account with sudo permission is almost as unsecure as root is. Just use SSH key based authentication. This is important on Windows. Had MySQL as a service and edited my. Query OK, 0 rows affected 0. Welcome to the MySQL monitor. All rights reserved. Other names may be trademarks of their respective owners. Now I see what I have inside my. Abdul Saleem Abdul Saleem 8, 4 4 gold badges 38 38 silver badges 37 37 bronze badges. This error come because of your data contain larger then set value.

Now just restart the MySQL. Active 2 years, 10 months ago. Viewed k times. Only changing its value in my. What is wrong?

Improve this question. Handsome Nerd. Handsome Nerd Handsome Nerd 1 1 gold badge 4 4 silver badges 11 11 bronze badges.

Add a comment. Active Oldest Votes. Improve this answer. C oneil C oneil 71 1 1 silver badge 1 1 bronze badge. This server variable can be set globally by running a query. Peter Venderberghe Peter Venderberghe 5 5 silver badges 10 10 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook.