MySQL - set variables - установка переменных

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Пример задания переменной mysql через SET:

mysql(root)> set connect_timeout=1000;
ERROR 1229 (HY000): Variable 'connect_timeout' is a GLOBAL variable and should be set with SET GLOBAL
mysql(root)> set global connect_timeout=1000;