{"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\/da\/blog\/news\/dostupna-subd-mysql-8-2-0","title":{"rendered":"MySQL 8.2.0 databasen er tilg\u00e6ngelig.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Oracle har dannet en ny gren af databasesystemet MySQL 8.2 og offentliggjort korrektionsopdateringerne MySQL 8.0.35 og 5.7.44. MySQL Community Server 8.2.0 er blevet forberedt til alle st\u00f8rre distributioner af Linux, FreeBSD, macOS og Windows.    <\/p>\n<p>MySQL 8.2.0 er den anden version i den nye model for udgivelse af versioner, som omfatter to typer af MySQL-grene \u2014 \u00abInnovation\u00bb og \u00abLTS\u00bb. Innovationsgrenene, som inkluderer MySQL 8.1 og 8.2, anbefales til dem, der \u00f8nsker tidlig adgang til nye funktioner. Disse grene offentligg\u00f8res hver 3. m\u00e5ned og underst\u00f8ttes kun indtil den n\u00e6ste store version frigives (for eksempel, efter udgivelsen af gren 8.2, oph\u00f8rer underst\u00f8ttelsen af gren 8.1). LTS-grene anbefales til implementeringer, der har brug for forudsigelighed og langsigtet bevarelse af stabile funktioner. LTS-grene vil blive udgivet hver andet \u00e5r og underst\u00f8ttes i 5 \u00e5r, hvorefter der kan afregnes yderligere 3 \u00e5r med udvidet support. LTS-udgivelsen af MySQL 8.4 forventes i for\u00e5ret 2024, hvorefter en ny Innovationsgren, version 9.0, vil blive dannet.      <\/p>\n<p>De vigtigste \u00e6ndringer i MySQL 8.2:  <\/p>\n<ul>\n<li class=\"l\"> Underst\u00f8ttelse af et autentificeringssystem baseret p\u00e5 Webauthn-specifikationen (FIDO2) er blevet tilf\u00f8jet, hvilket muligg\u00f8r brug af multifaktorautentifikation og bekr\u00e6ftelse af forbindelsen til <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/da\/server\/dts-shicago\/\"   title=\"server\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2927\">server<\/a> MySQL uden adgangskoder ved hj\u00e6lp af hardware tokens, der underst\u00f8tter FIDO2, eller biometrisk autentifikation. Plugin'en, der underst\u00f8tter Webauthn, er i \u00f8jeblikket kun tilg\u00e6ngelig for MySQL Enterprise.\n<li class=\"l\"> Server-pluginet mysql_native_password, der muligg\u00f8r autentificering ved hj\u00e6lp af adgangskoder, er blevet klassificeret som valgfrit og kan deaktiveres. I stedet for mysql_native_password anbefales det at skifte til pluginet caching_sha2_password, som bruger SHA2-algoritmen til hashing i stedet for SHA1. For at skifte brugere til caching_sha2_password-pluginet med et tilf\u00e6ldigt adgangskode kan kommandoen bruges:       ALTER USER &#8216;username&#8217;@&#8217;localhost&#8217;     IDENTIFIED WITH caching_sha2_password BY RANDOM PASSWORD     PASSWORD EXPIRE     FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LOCK_TIME 2;\n<li class=\"l\"> Hash-tabellerne er blevet optimeret, hvilket har forbedret udf\u00f8relsen af operationerne EXCEPT og INTERSECT.\n<li class=\"l\"> Fejlfindingsmulighederne er blevet udvidet. I kommandoerne SELECT, INSERT, REPLACE, UPDATE og DELETE er der tilf\u00f8jet underst\u00f8ttelse for udtrykket \u00abEXPLAIN FORMAT=JSON\u00bb for at generere diagnostisk output i JSON-format (for eksempel \u00abEXPLAIN FORMAT=JSON INTO @var select_stmt;\u00bb).\n<li class=\"l\"> Udtrykket \u00abEXPLAIN FOR SCHEMA\u00bb er blevet tilf\u00f8jet for at generere diagnoser relateret til en bestemt dataskema.\n<li class=\"l\"> Der er tilf\u00f8jet en mulighed \u00ab--output-as-version\u00bb til mysqldump-v\u00e6rkt\u00f8jet for at oprette dumps, der er kompatible med en bestemt \u00e6ldre version af MySQL (for eksempel kan du angive BEFORE_8_2_0 eller BEFORE_8_0_23 for at vende tilbage til de politisk ukorrekte termer master\/slave, der blev erkl\u00e6ret for\u00e6ldede i versioner 8.2.0 og 8.0.23).\n<li class=\"l\"> Den C-klientbibliotek har nu mulighed for at bruge navngivne attributter i parametrederede foresp\u00f8rgsler (prepared statements), implementeret ved den nye funktion mysql_stmt_bind_named_param(), som erstatter funktionen mysql_stmt_bind_param().\n<li class=\"l\"> SQL-trafikfordelingen i MySQL-serverklusteret er blevet forenklet. Der tilbydes muligheder for at etablere gennemsigtige forbindelser til sekund\u00e6re eller prim\u00e6re servere for applikationer.\n<li class=\"l\"> Der er tilf\u00f8jet en ny privilegium SET_ANY_DEFINER, der giver ret til at oprette objekter med DEFINER-udtrykket, samt privilegiet ALLOW_NONEXISTENT_DEFINER til at beskytte objekter uden ejer.\n<li class=\"l\"> F\u00f8lgende er blevet erkl\u00e6ret for\u00e6ldede: variablerne old og new, maskerne \u00ab%\u00bb og \u00ab_\u00bb i operationer til adgang til databaser, muligheden \u00ab--character-set-client-handshake\u00bb, variablen binlog_transaction_dependency_tracking og privilegiet SET_USER_ID.\n<li class=\"l\"> Som en del af justeringen af upolitisk korrekt terminologi relateret til replikation er udtryk som &#171;RESET MASTER&#187;, &#171;SHOW MASTER STATUS&#187;, &#171;SHOW MASTER LOGS&#187; og &#171;PURGE MASTER LOGS&#187; blevet erkl\u00e6ret for\u00e6ldede. I stedet b\u00f8r man bruge udtrykkene &#171;RESET BINARY LOGS AND GTIDS&#187;, &#171;SHOW BINARY LOG STATUS&#187;, &#171;SHOW BINARY LOGS&#187; og &#171;PURGE BINARY LOGS&#187;.\n<li class=\"l\"> Muligheder, der tidligere blev erkl\u00e6ret for\u00e6ldede, er blevet fjernet: funktionen WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(), variablen expire_logs_days, mulighederne &#171;&#8212;abort-slave-event-count&#187; og &#171;&#8212;disconnect-slave-event-count&#187;.\n<li class=\"l\"> 26 s\u00e5rbarheder er blevet rettet. To s\u00e5rbarheder relateret til brugen af Curl-pakken og OpenSSL-biblioteket kan udnyttes fjernbetjent.      <\/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.3 - 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\/da\/blog\/news\/dostupna-subd-mysql-8-2-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"da_DK\" \/>\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\/da\/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\udd47Databasesystemet MySQL 8.2.0 er tilg\u00e6ngeligt | ProHoster","description":"Oracle har oprettet en ny gren af databasesystemet MySQL 8.2 og offentliggjort opdateringer til MySQL 8.0.35 og 5.7.44.","canonical_url":"https:\/\/prohoster.info\/da\/blog\/news\/dostupna-subd-mysql-8-2-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"da_DK","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\/da\/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\/da\/wp-json\/wp\/v2\/posts\/111102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/comments?post=111102"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts\/111102\/revisions"}],"predecessor-version":[{"id":160207,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts\/111102\/revisions\/160207"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/media?parent=111102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/categories?post=111102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/tags?post=111102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}