mysql - 如何为 MySQL 中的每个新连接自动调用查询？

Question

是否可以在 MySQL 中为每个新连接设置或初始化查询？

无论何时创建连接，它都会自动调用过程或选择查询？

为此有任何脚本或配置选项吗？

Answer 1

您可能需要检查 init_connect 变量:

A string to be executed by the server for each client that connects. The string consists of one or more SQL statements, separated by semicolon characters. For example, each client session begins by default with autocommit mode enabled.

http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_init_connect