设置会话变量的MariaDB赠款

Question

在MariaDB上，设置会话变量需要哪些授权？

set global是超级助学金。但是，没有超级授权的客户可以设置自己的会话变量吗？

Answer 1

是的，似乎是这样的-您不需要任何特定的GRANT来修改您自己的会话变量：

CREATE USER user1@localhost IDENTIFIED BY 'Password_123!';
SHOW GRANTS FOR user1@localhost;
+--------------------------------------------------------------------------------------------------------------+
| Grants for user1@localhost                                                                                   |
+--------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'user1'@'localhost' IDENTIFIED BY PASSWORD '*45C046113DAFA331183C338569DC015C53EE4B47' |
+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.05 sec)

然后：

mysql -u user1 -p‘’Password_123！‘

SHOW VARIABLES LIKE 'sql_mode';
+---------------+--------------------------------------------+
| Variable_name | Value                                      |
+---------------+--------------------------------------------+
| sql_mode      | NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+---------------+--------------------------------------------+
1 row in set (0.03 sec)
SET sql_mode='';
SHOW VARIABLES LIKE 'sql_mode';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| sql_mode      |       |
+---------------+-------+
1 row in set (0.01 sec)

注意，当然不是每个会话都可以修改所有的系统变量，有些甚至不是动态的。