How to set the SQL mode by modifying the --sql-mode="modes" configuration option before starting TiDB?

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 如何TiDB 启动之前采用修改 --sql-mode=“modes” 配项设置 SQL 模式?

| username: TiDBer_WH4HEF3o

Before starting TiDB, modify the --sql-mode="modes" option to set the SQL mode? How to configure --sql-mode?

| username: 我是咖啡哥 | Original post link

Isn’t it persistent after setting it globally? Why do you need to set it every time you start?