MySQL 8 Administrator???s Guide

Setting program variables with options

Many MySQL programs have internal variables that we can set during runtime operations using the SET statement and also using the same syntax by which we specify option values. This will work when the program is started. For example, if we use the option value syntax then we have to specify like this: shell> mysql --max_allowed_packet=16M . To specify the runtime option using the SET, we can specify like this: mysql> SET GLOBAL max_allowed_packet=16*1024*1024.

To find out if the option variable syntax is correct, you can go to mysql and use the following: mysql> show variables like 'max%'.