A
A
andrey_yyy2018-04-09 13:37:06
MySQL
andrey_yyy, 2018-04-09 13:37:06

How to set the desired mode in MySQL not for the server, not for the session, but for the database?

I didn't find this information anywhere.
I have global.sql_mode = "NO_ENGINE_SUBSTITUTION" set on my MySQL server.
And I need to set the sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION" mode for a specific database on this server. Moreover, the mode is not sessional, but that this database always has it.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
L
Lazy @BojackHorseman MySQL, 2018-04-09
@andrey_yyy

DBAs can set the global SQL mode to match site server operating requirements, and each application can set its session SQL mode to its own requirements. documentation does not
mention other possibilities

A
Alexander Chernykh, 2018-04-10
@sashkets

make 1 more mysql instance with the necessary settings, for example, on port 3307 and transfer the database there

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question