Mysql strict mode not disabled?

Question

linux

The problem is, to transfer the site to a new server, STRICT_TRANS_TABLES is already working there forcibly.
The strictly mysql mode, I need to disable it for the site to work correctly. It doesn’t give through phpmyadmin
, it requires super rights (in the isp panel, when creating a user, there is no choice of super permission ) edit anyway Opens a pristine file, Write there via vim sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Save and restart mysql server. I check To no avail, it still works, then I read what I need






above the line with parameters in the config write
[mysqld]
Wrote, when trying to restart mysql, it gives an error
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
and doesn't load.

CentOS 8, MySQL 8.0.21

Answer 1

MySQL 8 removed the NO_AUTO_CREATE_USER option along with the ability to create a user via GRANT.
https://dev.mysql.com/doc/refman/8.0/en/mysql-nuts...
And you need to look at the errors in the MySQL log itself.