DevOps
Linux Systems Engineer
- Joined
- Oct 18, 2019
- Messages
- 199
- Reaction score
- 18
- Points
- 18
- Location
- Novosibirsk, Russia
- Website
- addons.vevioz.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