Method for modifying the max_allowed_packet attribute of MySQL 5.5

To modify the max_allowed_packet attribute of MySQL 5.5, the following error is reported when an experiment system is deployed: your 'max _ allowed_packet 'variable is set to less than 16777216 Byte (16 MB ). it is easy to understand, that is, you need to modify the MySQL configuration file, but here is a tip (in Windows 7 ): if you directly use notepad or notepad ++ to open my. ini, it will prompt that the file is occupied by other programs, or access is denied (for example, "please check if this file is opended in another program "). If the MySQL service has been stopped, it is not a problem of program occupation. The solution is also very simple. First, cut my. ini elsewhere under the MySQL 5.5 installation directory, and then ask the Administrator to continue. Then, there are many and my In the installation directory of MySQL 5.5. ini similar files, such as my-small.ini, use the Administrator identity to start a text editing software (such as notepad ++. ini and my-small.ini are open, copy these lines in the my-small.ini: [plain] [mysqldump] quick max_allowed_packet = 16 M to my. in the INI file, you can save it successfully. Copy the file to the MySQL 5.5 installation directory as an administrator to achieve our goal. That's simple. record it.