Tutorial - Disable strict mode on MariaDB | Vevioz Community

Tutorial Disable strict mode on MariaDB

DevOps

Linux Systems Engineer
Joined
Oct 18, 2019
Messages
137
Reaction score
11
Points
18
Location
Indonesia
Website
www.anymusics.com
Offline
  • MySQL and MariaDB have been diverging since 2010, and now they should be considered different software products (sort of like Microsoft SQL server vs. Sybase). You should tell us which one you use, and tag your question appropriately. The answer to your question will be different depending on which one you are using.
  • You should read mariadb.com/kb/en/library/set including: "Changing a system variable by using the SET statement does not make the change permanently. To do so, the change must be made in a configuration file." You can't do this from the phpmyadmin user interface. You have to edit the configuration file on the MariaDB server

Edit via SSH

/etc/my.cnf file

Add

Code:
sql_mode=NO_ENGINE_SUBSTITUTION
restart MariaDB

and it will fix the issue

*edit - if You have error while restarting msyql service try to add "[mysqld]" above in my.cnf
 
Top Bottom