{"id":13952,"date":"2021-05-11T10:37:59","date_gmt":"2021-05-11T09:37:59","guid":{"rendered":"https:\/\/www.oderland.se\/support\/?post_type=ht_kb&#038;p=13952"},"modified":"2026-02-05T13:21:43","modified_gmt":"2026-02-05T12:21:43","slug":"kan-ni-aktivera-event_scheduler-i-mysql","status":"publish","type":"ht_kb","link":"https:\/\/www.oderland.se\/support\/artikel\/kan-ni-aktivera-event_scheduler-i-mysql\/","title":{"rendered":"Kan ni aktivera event_scheduler i MariaDB?"},"content":{"rendered":"\n<p>Vi kan inte av s\u00e4kerhetssk\u00e4l aktivera event_scheduler i MariaDB p\u00e5 v\u00e5ra webbhotellkontoservrar. Du kan allts\u00e5 inte l\u00e4gga in events i MariaDB.<\/p>\n\n\n\n<p>Vi rekommenderar ist\u00e4llet att du anv\u00e4nder <a rel=\"noreferrer noopener\" href=\"https:\/\/www.oderland.se\/support\/artikel\/hur-skapar-jag-cronjobb\/\" data-type=\"ht_kb\" data-id=\"438\" target=\"_blank\">cronjobb<\/a> uppsatta p\u00e5 servern.<\/p>\n\n\n\n<p>N\u00e4r du skapar cronjobbet kan du anv\u00e4nda ett kommando likt detta:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mariadb -h localhost -u <code>DATABASANV\u00c4NDARE<\/code> -p <code>L\u00d6SENORD<\/code> -D <code>DATABASNAMN<\/code> -e \"<code>DATABASFR\u00c5GA<\/code>\"<\/pre>\n\n\n\n<p><a href=\"https:\/\/www.oderland.se\/support\/artikel\/hur-skapar-jag-databaser-i-cpanel\/#lagg-till-en-anvandare\" target=\"_blank\" rel=\"noreferrer noopener\">Skapa g\u00e4rna en separat MariaDB-anv\u00e4ndare<\/a> f\u00f6r detta och <a href=\"https:\/\/www.oderland.se\/support\/artikel\/hur-skapar-jag-databaser-i-cpanel\/#koppla-en-anvandare-till-en-databas\" target=\"_blank\" rel=\"noreferrer noopener\">koppla den till databasen<\/a>. Byt ut <code>DATABASANV\u00c4NDARE<\/code>, <code>L\u00d6SENORD<\/code>, <code>DATABASNAMN<\/code> och <code>DATABASFR\u00c5GA<\/code> i kommandot ovan s\u00e5 de matchar din anv\u00e4ndare, databas och databasfr\u00e5ga (query).<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">Om du inte har n\u00e5got alternativ till att anv\u00e4nda events direkt i MariaDB beh\u00f6ver du s\u00e4tta upp en egen server via <a href=\"https:\/\/www.oderland.se\/cloud\/\" target=\"_blank\" rel=\"noreferrer noopener\">Oderland Cloud<\/a> d\u00e4r du sj\u00e4lv styr \u00f6ver vad som ska k\u00f6ras. Om du har en <a href=\"https:\/\/www.oderland.se\/server\/managed\/\" target=\"_blank\" rel=\"noreferrer noopener\">Managed Server<\/a> kan vi hj\u00e4lpa dig med aktivering av event_scheduler.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Vi kan inte av s\u00e4kerhetssk\u00e4l aktivera event_scheduler i MariaDB p\u00e5 v\u00e5ra webbhotellkontoservrar. Du kan allts\u00e5 inte l\u00e4gga in events i MariaDB. Vi rekommenderar ist\u00e4llet att du anv\u00e4nder cronjobb uppsatta p\u00e5 servern. N\u00e4r du skapar cronjobbet kan du anv\u00e4nda ett kommando likt detta: mariadb -h localhost -u DATABASANV\u00c4NDARE -p L\u00d6SENORD -D&#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-13952","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\/13952","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=13952"}],"version-history":[{"count":9,"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/ht-kb\/13952\/revisions"}],"predecessor-version":[{"id":24781,"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/ht-kb\/13952\/revisions\/24781"}],"wp:attachment":[{"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/media?parent=13952"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/ht-kb-category?post=13952"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.oderland.se\/support\/wp-json\/wp\/v2\/ht-kb-tag?post=13952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}