Dino Geek, try to help you

How to disable strict mode in MariaDB?


You can disable strict mode in MariaDB by doing the following steps:

1. Go to your MariaDB configuration file. The common locations are: `/etc/my.cnf` or `/etc/mysql/my.cnf`. If you installed MariaDB with a Windows Installer, the my.ini file is installed in C:\Program Files\MariaDB x.x version.

1. Open the configuration file and under `[mysqld]`, look for line starting with `sql_mode`.

1. If you find a line starting with `sql_mode`, you should adjust the mode to disable strict mode. For example like this:
```
sql_mode=NO_ENGINE_SUBSTITUTION
```
1. If there is no line starting with `sql_mode`, you should add one.

1. Save your changes and exit the text editor.

1. You need to restart your MariaDB server for the changes to take effect.

Remember that you have to be careful when disabling strict mode, as it can lead to potential data integrity issues. This is because it disables data validations that help enforce the integrity of your data. Always make sure you understand the implications of disabling this mode before proceeding.


Simply generate articles to optimize your SEO
Simply generate articles to optimize your SEO





DinoGeek offers simple articles on complex technologies

Would you like to be quoted in this article? It's very simple, contact us at dino@eiki.fr

CSS | NodeJS | DNS | DMARC | MAPI | NNTP | htaccess | PHP | HTTPS | Drupal | WEB3 | LLM | Wordpress | TLD | Domain name | IMAP | TCP | NFT | MariaDB | FTP | Zigbee | NMAP | SNMP | SEO | E-Mail | LXC | HTTP | MangoDB | SFTP | RAG | SSH | HTML | ChatGPT API | OSPF | JavaScript | Docker | OpenVZ | ChatGPT | VPS | ZIMBRA | SPF | UDP | Joomla | IPV6 | BGP | Django | Reactjs | DKIM | VMWare | RSYNC | Python | TFTP | Webdav | FAAS | Apache | IPV4 | LDAP | POP3 | SMTP

| Whispers of love (API) | Déclaration d'Amour |






Legal Notice / General Conditions of Use