{"id":11239,"date":"2020-07-17T10:53:49","date_gmt":"2020-07-17T09:53:49","guid":{"rendered":"https:\/\/www.oderland.se\/support\/?post_type=ht_kb&#038;p=11239"},"modified":"2026-03-18T14:16:11","modified_gmt":"2026-03-18T13:16:11","slug":"hur-inaktiverar-jag-strict-mode-for-mariadb","status":"publish","type":"ht_kb","link":"https:\/\/www.oderland.se\/support\/artikel\/hur-inaktiverar-jag-strict-mode-for-mariadb\/","title":{"rendered":"Hur inaktiverar jag Strict Mode f\u00f6r MariaDB?"},"content":{"rendered":"\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-alert\">Observera att detta inte kan anv\u00e4ndas f\u00f6r att k\u00f6ra en hemsida p\u00e5 en server d\u00e4r strict mode \u00e4r aktiverat om sitens databas bryter mot Strict Mode&#8217;s regler. Det \u00e4r endast till f\u00f6r eng\u00e5ngs\u00e5tg\u00e4rder via mariadb-cli eller phpMyAdmin.<\/p>\n\n\n\n<p>Strict Mode f\u00f6r MariaDB f\u00f6rhindrar ett stort antal skadliga kommandon och liknande fr\u00e5n att k\u00f6ras, men ibland kan man beh\u00f6va k\u00f6ra n\u00e5gon databasfr\u00e5ga (query) som ogillas av strict mode, \u00e4ven om kommandot i sig inte \u00e4r skadligt. Ett exempel \u00e4r om man vill l\u00e4gga in datumet 0000-00-00 i en datumformaterad kolumn s\u00e5 blockeras detta normalt av <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/sql-mode.html#sqlmode_no_zero_date\"><code>NO_ZERO_DATE<\/code><\/a>.<\/p>\n\n\n\n<p>I den h\u00e4r guiden g\u00e5r vi igenom hur du tillf\u00e4lligt g\u00e5r runt strict mode p\u00e5 n\u00e5gra olika s\u00e4tt.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Inaktivera f\u00f6r MariaDB via cli<\/h2>\n\n\n\n<p>F\u00f6r att n\u00e5 MySQL via cli (command line interface) beh\u00f6ver du <a rel=\"noreferrer noopener\" href=\"https:\/\/www.oderland.se\/support\/artikel\/hur-ansluter-jag-med-ssh-till-ett-webbhotellkonto\/\" target=\"_blank\">ansluta till ditt webbhotellkonto via SSH eller anv\u00e4nda Terminalen inne p\u00e5 cPanel<\/a>.<\/p>\n\n\n\n<p>V\u00e4l inloggad g\u00e5r du in i MariaDB genom att skriva f\u00f6ljande:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ mariadb -u DITT_DATABAS-ANV\u00c4NDARNAMN -p<\/pre>\n\n\n\n<p>Byt ut <code>DITT_DATABAS-ANV\u00c4NDARNAMN<\/code> mot r\u00e4tt anv\u00e4ndarnamn (antingen ditt cPanel-anv\u00e4ndarnamn eller ett namn p\u00e5 en anv\u00e4ndare kopplad till databasen som du vill agera p\u00e5). Efter du tryckt p\u00e5 <code>Enter<\/code> kommer du bli tillfr\u00e5gad om l\u00f6senordet tillh\u00f6rande anv\u00e4ndaren.<\/p>\n\n\n\n<p>F\u00f6r att se nuvarande mode som MariaDB anv\u00e4nder, k\u00f6r detta kommando:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mariadb&gt; SELECT @@sql_mode;<\/pre>\n\n\n\n<p>Ett exempel p\u00e5 output du kan f\u00e5:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">+------------------------------------------------------------------------------------------------------------------------+\n| @@sql_mode |\n+------------------------------------------------------------------------------------------------------------------------+\n| STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |\n+------------------------------------------------------------------------------------------------------------------------+\n1 row in set (0.00 sec)<\/pre>\n\n\n\n<p>F\u00f6r att st\u00e4nga av strict mode anv\u00e4nder du detta kommando:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mariadb&gt; SET sql_mode = '';<\/pre>\n\n\n\n<p>Strict Mode \u00e4r nu avst\u00e4ngt tills du loggar ut fr\u00e5n MariaDB och du kan k\u00f6ra dina queries obehindrat.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Inaktivera f\u00f6r phpMyAdmin<\/h2>\n\n\n\n<p>Om du f\u00f6redrar att arbeta med MariaDB via phpMyAdmin s\u00e5 kan du avaktivera strict mode \u00e4ven h\u00e4r. Du n\u00e5r phpMyAdmin via cPanel f\u00f6r ditt webbhotellkonto, s\u00e5 b\u00f6rja med att <a href=\"https:\/\/www.oderland.se\/support\/artikel\/hur-loggar-jag-in-pa-cpanel\/\" target=\"_blank\" rel=\"noreferrer noopener\">logga in d\u00e4r<\/a>. Klicka sedan p\u00e5 ikonen f\u00f6r phpMyAdmin f\u00f6r att komma ig\u00e5ng.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_ikon_phpmyadmin-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"739\" height=\"192\" src=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_ikon_phpmyadmin-1.png\" alt=\"\" class=\"wp-image-24927\" srcset=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_ikon_phpmyadmin-1.png 739w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_ikon_phpmyadmin-1-300x78.png 300w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_ikon_phpmyadmin-1-50x13.png 50w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_ikon_phpmyadmin-1-60x16.png 60w, https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_ikon_phpmyadmin-1-100x26.png 100w\" sizes=\"auto, (max-width: 739px) 100vw, 739px\" \/><\/a><\/figure>\n\n\n\n<p>Klicka p\u00e5 databasen i menyn ute till v\u00e4nster f\u00f6r att v\u00e4lja vilken du vill arbeta med.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_phpmyadmin_valj_databas.png\"><img loading=\"lazy\" decoding=\"async\" width=\"230\" height=\"207\" src=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_phpmyadmin_valj_databas.png\" alt=\"\" class=\"wp-image-11244\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Manuella SQL-kommandon<\/h3>\n\n\n\n<p>G\u00e5 p\u00e5 databasen enligt ovan och vidare in p\u00e5 fliken SQL.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_phpmyadmin_fliken_sql.png\"><img loading=\"lazy\" decoding=\"async\" width=\"445\" height=\"104\" src=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_phpmyadmin_fliken_sql.png\" alt=\"\" class=\"wp-image-11246\"\/><\/a><\/figure>\n\n\n\n<p>H\u00e4r har du nu ett inmatningsf\u00e4lt d\u00e4r du kan k\u00f6ra dina databaskommandon. Om du anger f\u00f6ljande framf\u00f6r\/f\u00f6re dina kommandon kommer Strict Mode vara avst\u00e4ngt n\u00e4r kommandot k\u00f6rs. Det m\u00e5ste allts\u00e5 anges f\u00f6re varje kommando som du k\u00f6r.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SET SESSION sql_mode = ''; X<\/pre>\n\n\n\n<p>Byt ut <code>X<\/code> mot resten av din query.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Insert via menyn<\/h3>\n\n\n\n<p>Du kan \u00e4ven g\u00f6ra databasoperationer s\u00e5 som Insert direkt via det grafiska gr\u00e4nssnittet i phpMyAdmin. F\u00f6r att g\u00f6ra det, g\u00f6r som ovan och klicka p\u00e5 databasnamnet ute till v\u00e4nster.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_phpmyadmin_valj_databas.png\"><img loading=\"lazy\" decoding=\"async\" width=\"230\" height=\"207\" src=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_phpmyadmin_valj_databas.png\" alt=\"\" class=\"wp-image-11244\"\/><\/a><\/figure>\n\n\n\n<p>Klicka sedan p\u00e5 tabellen som du vill l\u00e4gga in data i.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_phpmyadmin_valj_databastabell.png\"><img loading=\"lazy\" decoding=\"async\" width=\"238\" height=\"340\" src=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_phpmyadmin_valj_databastabell.png\" alt=\"\" class=\"wp-image-11268\"\/><\/a><\/figure>\n\n\n\n<p>G\u00e5 d\u00e4refter in p\u00e5 fliken Insert h\u00f6gst upp.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_phpmyadmin_insert.png\"><img loading=\"lazy\" decoding=\"async\" width=\"539\" height=\"61\" src=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_phpmyadmin_insert.png\" alt=\"\" class=\"wp-image-11270\"\/><\/a><\/figure>\n\n\n\n<p>Mata in datan du vill l\u00e4gga in i tabellen och klicka p\u00e5 knappen <code>Go<\/code>.<\/p>\n\n\n\n<p>Du kommer nu f\u00e5 ett felmeddelande om din input bryter mot Strict Mode:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_phpmyadmin_felmeddelande.png\"><img loading=\"lazy\" decoding=\"async\" width=\"359\" height=\"226\" src=\"https:\/\/www.oderland.se\/support\/wp-content\/uploads\/2020\/07\/cpanel_phpmyadmin_felmeddelande.png\" alt=\"\" class=\"wp-image-11272\"\/><\/a><\/figure>\n\n\n\n<p>Klicka p\u00e5 <code>Edit<\/code> f\u00f6r att kunna korrigera kommandot som kommer k\u00f6ras och l\u00e4gg in f\u00f6ljande <em>f\u00f6re<\/em> kommandot som phpMyAdmin genererat:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SET SESSION sql_mode = ''; X<\/pre>\n\n\n\n<p><code>X<\/code> i kommandot ers\u00e4tts av resten av phpMyAdmins kommando.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Strict Mode f\u00f6r MariaDB f\u00f6rhindrar ett stort antal skadliga kommandon och liknande fr\u00e5n att k\u00f6ras, men ibland kan man beh\u00f6va k\u00f6ra n\u00e5gon databasfr\u00e5ga (query) som ogillas av strict mode, \u00e4ven om kommandot i sig inte \u00e4r skadligt. Ett exempel \u00e4r om man vill l\u00e4gga in datumet 0000-00-00 i en datumformaterad&#8230;<\/p>\n","protected":false},"author":12,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"ht-kb-category":[4],"ht-kb-tag":[],"class_list":["post-11239","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-databaser"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/ht-kb\/11239","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/comments?post=11239"}],"version-history":[{"count":15,"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/ht-kb\/11239\/revisions"}],"predecessor-version":[{"id":25118,"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/ht-kb\/11239\/revisions\/25118"}],"wp:attachment":[{"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/media?parent=11239"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/ht-kb-category?post=11239"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/ht-kb-tag?post=11239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}