{"id":111102,"date":"2023-10-26T15:10:14","date_gmt":"2023-10-26T13:10:14","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/dostupna-subd-mysql-8-2-0"},"modified":"2023-10-26T15:10:14","modified_gmt":"2023-10-26T13:10:14","slug":"dostupna-subd-mysql-8-2-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/no\/blog\/news\/dostupna-subd-mysql-8-2-0","title":{"rendered":"MySQL 8.2.0 databasen er tilgjengelig.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Oracle har dannet en ny gren av databasesystemet MySQL 8.2 og publisert korrektive oppdateringer for MySQL 8.0.35 og 5.7.44. Byggene av MySQL Community Server 8.2.0 er forberedt for alle hoveddistribusjoner av Linux, FreeBSD, macOS og Windows.    <\/p>\n<p>MySQL 8.2.0 er den andre utgivelsen i den nye modellen for utgivelsesformasjon, som omfatter to typer MySQL-grener \u2014 \"Innovation\" og \"LTS\". Innovation-grenene, som inkluderer MySQL 8.1 og 8.2, anbefales for de som \u00f8nsker tidlig tilgang til nye funksjoner. Disse grenene publiseres hver tredje m\u00e5ned og st\u00f8ttes kun frem til publikasjonen av den neste store utgivelsen (for eksempel etter utgivelsen av gren 8.2, opph\u00f8rer st\u00f8tten for gren 8.1). LTS-grener anbefales for implementeringer som trenger forutsigbarhet og langvarig up\u00e5virket oppf\u00f8rsel. LTS-grener vil bli utgitt annenhvert \u00e5r og st\u00f8ttet i 5 \u00e5r, samt at det vil v\u00e6re mulig \u00e5 f\u00e5 3 \u00e5rs utvidet st\u00f8tte. LTS-utgivelsen MySQL 8.4 er forventet til v\u00e5ren 2024, hvorefter en ny Innovation-gren 9.0 vil bli dannet.      <\/p>\n<p>Viktige endringer i MySQL 8.2:  <\/p>\n<ul>\n<li class=\"l\"> St\u00f8tte for autentiseringsmekanismen basert p\u00e5 Webauthn-spesifikasjonen (FIDO2) er lagt til, noe som muliggj\u00f8r flerfaktorautentisering og bekreftelse av tilkoblingen til <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/no\/server\/dts-shicago\/\"   title=\"server\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2927\">server<\/a> MySQL uten passord, ved \u00e5 bruke maskinvare-token som st\u00f8tter FIDO2 eller biometrisk autentisering. Plugin-modulen med st\u00f8tte for Webauthn er forel\u00f8pig kun tilgjengelig for MySQL Enterprise.\n<li class=\"l\"> Serverpluginet mysql_native_password, som gir autentisering ved hjelp av passord, er flyttet til kategorien valgfrie og kan deaktiveres. I stedet for mysql_native_password anbefales det \u00e5 bruke pluginen caching_sha2_password, som benytter SHA2-algoritmen for hashing i stedet for SHA1. For \u00e5 bytte brukere til caching_sha2_password-pluginen med et tilfeldig generert passord, kan kommandoen brukes:       ALTER USER 'username'@'localhost'     IDENTIFIED WITH caching_sha2_password BY RANDOM PASSWORD     PASSWORD EXPIRE     FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LOCK_TIME 2;\n<li class=\"l\"> Optimaliseringen av hash-tabeller har muliggjort raskere utf\u00f8relse av EXCEPT- og INTERSECT-operasjoner.\n<li class=\"l\"> Feils\u00f8kingsmulighetene er utvidet. I SELECT, INSERT, REPLACE, UPDATE og DELETE-operasjoner er det lagt til st\u00f8tte for uttrykket \"EXPLAIN FORMAT=JSON\" for \u00e5 generere diagnostisk output i JSON-format (for eksempel \"EXPLAIN FORMAT=JSON INTO @var select_stmt;\").\n<li class=\"l\"> Uttrykket \"EXPLAIN FOR SCHEMA\" er lagt til for \u00e5 vise diagnose relatert kun til en bestemt dataskjema.\n<li class=\"l\"> Verkt\u00f8yet mysqldump har f\u00e5tt tillegget \"--output-as-version\" for \u00e5 lage dumps som er kompatible med en bestemt eldre versjon av MySQL (for eksempel kan du angi BEFORE_8_2_0 eller BEFORE_8_0_23 for \u00e5 g\u00e5 tilbake til den ikke-politisk korrekte terminologien master\/slave, som ble erkl\u00e6rt foreldet i utgivelsene 8.2.0 og 8.0.23).\n<li class=\"l\"> Den klientside C-biblioteket har f\u00e5tt muligheten til \u00e5 bruke navngitte attributter i parametrisert sp\u00f8rringer (prepared statement), implementert ved hjelp av den nye funksjonen mysql_stmt_bind_named_param(), som erstatter funksjonen mysql_stmt_bind_param().\n<li class=\"l\"> Distribusjonen av SQL-trafikk i klynger av MySQL-servere er forenklet. Det er gitt muligheter for \u00e5 organisere applikasjonsgjennomsiktige tilkoblinger til sekund\u00e6re eller prim\u00e6re servere.\n<li class=\"l\"> Det er lagt til en ny privilegium SET_ANY_DEFINER, som gir rett til \u00e5 opprette objekter med DEFINER-uttrykk, samt privilegiet ALLOW_NONEXISTENT_DEFINER for \u00e5 beskytte objekter uten eier.\n<li class=\"l\"> Erkl\u00e6rt foreldet: variablene old og new, masker \"%\" og \"_\" i operasjoner for databasetilgang, alternativet \"--character-set-client-handshake\", variabelen binlog_transaction_dependency_tracking og privilegiet SET_USER_ID.\n<li class=\"l\"> I forbindelse med justeringen av upolitisk korrekt terminologi knyttet til replikasjon, er uttrykkene \u00abRESET MASTER\u00bb, \u00abSHOW MASTER STATUS\u00bb, \u00abSHOW MASTER LOGS\u00bb og \u00abPURGE MASTER LOGS\u00bb erkl\u00e6rt foreldet, og det anbefales \u00e5 bruke uttrykkene \u00abRESET BINARY LOGS AND GTIDS\u00bb, \u00abSHOW BINARY LOG STATUS\u00bb, \u00abSHOW BINARY LOGS\u00bb og \u00abPURGE BINARY LOGS\u00bb i stedet.\n<li class=\"l\"> Muligheter som tidligere ble erkl\u00e6rt foreldet, er fjernet: funksjonen WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(), variabelen expire_logs_days, alternativene \u00ab\u2014abort-slave-event-count\u00bb og \u00ab\u2014disconnect-slave-event-count\u00bb.\n<li class=\"l\"> 26 s\u00e5rbarheter er eliminert. To s\u00e5rbarheter knyttet til bruk av Curl-pakken og OpenSSL-biblioteket kan utnyttes eksternt.      <\/ul>\n<p>Kilde: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=59995\">opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 8.2 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0438\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f MySQL 8.0.35 \u0438 5.7.44. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 8.2.0 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u044b \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u0434\u0438\u0441\u0442\u0440\u0438\u0431\u0443\u0442\u0438\u0432\u043e\u0432 Linux, FreeBSD, macOS \u0438 Windows. MySQL 8.2.0 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0432\u0442\u043e\u0440\u044b\u043c \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u043c, \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u043c \u0432 \u0440\u0430\u043c\u043a\u0430\u0445 \u043d\u043e\u0432\u043e\u0439 \u043c\u043e\u0434\u0435\u043b\u0438 \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0440\u0435\u043b\u0438\u0437\u043e\u0432, \u043f\u0440\u0435\u0434\u0443\u0441\u043c\u0430\u0442\u0440\u0438\u0432\u0430\u044e\u0449\u0435\u0439 \u043d\u0430\u043b\u0438\u0447\u0438\u0435 \u0434\u0432\u0443\u0445 \u0442\u0438\u043f\u043e\u0432 \u0432\u0435\u0442\u043e\u043a MySQL &#8212; &#171;Innovation&#187; \u0438 &#171;LTS&#187;. \u0412\u0435\u0442\u043a\u0438 Innovation, [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-111102","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.5 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 8.2 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0438\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f MySQL 8.0.35 \u0438 5.7.44.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/no\/blog\/news\/dostupna-subd-mysql-8-2-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\n\t\t<meta property=\"og:locale\" content=\"nn_NO\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0414\u043e\u0441\u0442\u0443\u043f\u043d\u0430 \u0421\u0423\u0411\u0414 MySQL 8.2.0 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 8.2 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0438\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f MySQL 8.0.35 \u0438 5.7.44.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/no\/blog\/news\/dostupna-subd-mysql-8-2-0\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2023-10-26T13:10:14+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2023-10-26T13:10:14+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Database MySQL 8.2.0 er tilgjengelig | ProHoster","description":"Oracle har dannet en ny gren av databasesystemet MySQL 8.2 og publisert oppdateringer for MySQL 8.0.35 og 5.7.44.","canonical_url":"https:\/\/prohoster.info\/no\/blog\/news\/dostupna-subd-mysql-8-2-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"nn_NO","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0414\u043e\u0441\u0442\u0443\u043f\u043d\u0430 \u0421\u0423\u0411\u0414 MySQL 8.2.0 | ProHoster","og:description":"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 8.2 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0438\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f MySQL 8.0.35 \u0438 5.7.44.","og:url":"https:\/\/prohoster.info\/no\/blog\/news\/dostupna-subd-mysql-8-2-0","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2023-10-26T13:10:14+00:00","article:modified_time":"2023-10-26T13:10:14+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"111102","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-02-09 21:42:05","updated":"2026-02-09 21:42:05","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/posts\/111102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/comments?post=111102"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/posts\/111102\/revisions"}],"predecessor-version":[{"id":160207,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/posts\/111102\/revisions\/160207"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/media?parent=111102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/categories?post=111102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/tags?post=111102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}