{"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\/sv\/blog\/news\/dostupna-subd-mysql-8-2-0","title":{"rendered":"Databasen MySQL 8.2.0 \u00e4r tillg\u00e4nglig","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Oracle har skapat en ny gren av databasen MySQL 8.2 och publicerat korrigerande uppdateringar f\u00f6r MySQL 8.0.35 och 5.7.44. Byggnaderna av MySQL Community Server 8.2.0 \u00e4r f\u00f6rberedda f\u00f6r alla st\u00f6rre distributioner av Linux, FreeBSD, macOS och Windows.    <\/p>\n<p>MySQL 8.2.0 \u00e4r den andra utg\u00e5van inom den nya utgivningsmodellen, som omfattar tv\u00e5 typer av MySQL-grenar \u2013 \"Innovation\" och \"LTS\". Innovation-grenarna, som inkluderar MySQL 8.1 och 8.2, rekommenderas f\u00f6r de som vill ha tidig tillg\u00e5ng till ny funktionalitet. Dessa grenar publiceras var tredje m\u00e5nad och st\u00f6ds endast tills n\u00e4sta st\u00f6rre release publiceras (till exempel, efter lanseringen av gren 8.2, upph\u00f6r st\u00f6det f\u00f6r gren 8.1). LTS-grenarna rekommenderas f\u00f6r implementationer som kr\u00e4ver f\u00f6ruts\u00e4gbarhet och l\u00e5ngsiktig stabilitet. LTS-grenar kommer att sl\u00e4ppas vartannat \u00e5r och st\u00f6djas i 5 \u00e5r, med m\u00f6jlighet till ytterligare 3 \u00e5rs ut\u00f6kat st\u00f6d. En LTS-release av MySQL 8.4 f\u00f6rv\u00e4ntas v\u00e5ren 2024, varefter en ny Innovation-gren, 9.0, kommer att bildas.      <\/p>\n<p>V\u00e4sentliga f\u00f6r\u00e4ndringar i MySQL 8.2:  <\/p>\n<ul>\n<li class=\"l\"> St\u00f6d f\u00f6r autentisering baserat p\u00e5 Webauthn-specifikationen (FIDO2) har lagts till, vilket m\u00f6jligg\u00f6r multifaktorautentisering och bekr\u00e4ftelse av anslutning till <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/sv\/server\/dts-shicago\/\"   title=\"servern\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2927\">servern<\/a> MySQL utan l\u00f6senord, med anv\u00e4ndning av h\u00e5rdvaru-token som st\u00f6der FIDO2 eller biometrisk autentisering. Plug-in som st\u00f6der Webauthn \u00e4r f\u00f6r n\u00e4rvarande endast tillg\u00e4nglig f\u00f6r MySQL Enterprise.\n<li class=\"l\"> Serverpluginet mysql_native_password, som m\u00f6jligg\u00f6r autentisering med hj\u00e4lp av l\u00f6senord, har flyttats till kategorin valfritt och kan avaktiveras. Ist\u00e4llet f\u00f6r mysql_native_password rekommenderas att man g\u00e5r \u00f6ver till att anv\u00e4nda pluginet caching_sha2_password, som anv\u00e4nder SHA2-algoritmen f\u00f6r hashning ist\u00e4llet f\u00f6r SHA1. F\u00f6r att byta anv\u00e4ndare till pluginet caching_sha2_password och ers\u00e4tta l\u00f6senordet med ett slumpm\u00e4ssigt kan f\u00f6ljande kommando anv\u00e4ndas:       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\"> Hash-tabeller har optimerats, vilket har gjort att operationerna EXCEPT och INTERSECT k\u00f6rs snabbare.\n<li class=\"l\"> Fels\u00f6kningsm\u00f6jligheterna har utvidgats. I operationerna SELECT, INSERT, REPLACE, UPDATE och DELETE har st\u00f6d f\u00f6r uttrycket \"EXPLAIN FORMAT=JSON\" lagts till f\u00f6r att generera diagnostiska utdata i JSON-format (till exempel, \"EXPLAIN FORMAT=JSON INTO @var select_stmt;\").\n<li class=\"l\"> Uttrycket \"EXPLAIN FOR SCHEMA\" har lagts till f\u00f6r att ge diagnostik relaterad endast till ett specifikt dataskema.\n<li class=\"l\"> Till verktyget mysqldump har alternativet \"--output-as-version\" lagts till f\u00f6r att skapa dumpningar som \u00e4r kompatibla med en viss \u00e4ldre version av MySQL (till exempel kan man ange BEFORE_8_2_0 eller BEFORE_8_0_23 f\u00f6r att \u00e5terg\u00e5 till den oetiska terminologin master\/slave, som har avskrivits i versionerna 8.2.0 och 8.0.23).\n<li class=\"l\"> I den klientbaserade C-biblioteket har m\u00f6jligheten att anv\u00e4nda namngivna attribut i parametriserade f\u00f6rfr\u00e5gningar (prepared statements) inf\u00f6rts, genom den nya funktionen mysql_stmt_bind_named_param(), som ers\u00e4tter funktionen mysql_stmt_bind_param().\n<li class=\"l\"> F\u00f6rdelningen av SQL-trafik i kluster av MySQL-servrar har f\u00f6renklats. M\u00f6jligheter f\u00f6r att organisera transparanta anslutningar f\u00f6r applikationer till sekund\u00e4ra eller prim\u00e4ra servrar har tillhandah\u00e5llits.\n<li class=\"l\"> En ny privilegium SET_ANY_DEFINER har lagts till, vilket ger r\u00e4tt att skapa objekt med uttrycket DEFINER, samt privilegiet ALLOW_NONEXISTENT_DEFINER f\u00f6r att skydda objekt utan \u00e4gare.\n<li class=\"l\"> F\u00f6r\u00e5ldrade har f\u00f6rklarats: variablerna old och new, maskerna \"%\" och \"_\" i operationer f\u00f6r att bevilja databas\u00e5tkomst, alternativet \"--character-set-client-handshake\", variabeln binlog_transaction_dependency_tracking och privilegiet SET_USER_ID.\n<li class=\"l\"> Som en del av justeringen av icke-politiskt korrekta termer relaterade till replikering har uttrycken &#171;RESET MASTER&#187;, &#171;SHOW MASTER STATUS&#187;, &#171;SHOW MASTER LOGS&#187; och &#171;PURGE MASTER LOGS&#187; f\u00f6rklarats som f\u00f6r\u00e5ldrade. Ist\u00e4llet ska man anv\u00e4nda uttrycken &#171;RESET BINARY LOGS AND GTIDS&#187;, &#171;SHOW BINARY LOG STATUS&#187;, &#171;SHOW BINARY LOGS&#187; och &#171;PURGE BINARY LOGS&#187;.\n<li class=\"l\"> M\u00f6jligheterna som tidigare f\u00f6rklarades som f\u00f6r\u00e5ldrade har tagits bort: funktionen WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(), variabeln expire_logs_days, och alternativen &#171;&#8212;abort-slave-event-count&#187; och &#171;&#8212;disconnect-slave-event-count&#187;.\n<li class=\"l\"> 26 s\u00e5rbarheter har \u00e5tg\u00e4rdats. Tv\u00e5 s\u00e5rbarheter relaterade till anv\u00e4ndning av Curl-paketet och OpenSSL-biblioteket kan utnyttjas p\u00e5 distans.      <\/ul>\n<p>K\u00e4lla: <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.4 - 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\/sv\/blog\/news\/dostupna-subd-mysql-8-2-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"sv_SE\" \/>\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\/sv\/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\udd47Databashanteringssystemet MySQL 8.2.0 \u00e4r tillg\u00e4ngligt | ProHoster","description":"F\u00f6retaget Oracle har bildat en ny gren av databasprogrammet MySQL 8.2 och publicerat korrigeringsuppdateringar f\u00f6r MySQL 8.0.35 och 5.7.44.","canonical_url":"https:\/\/prohoster.info\/sv\/blog\/news\/dostupna-subd-mysql-8-2-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sv_SE","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\/sv\/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\/sv\/wp-json\/wp\/v2\/posts\/111102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/comments?post=111102"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts\/111102\/revisions"}],"predecessor-version":[{"id":160207,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts\/111102\/revisions\/160207"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/media?parent=111102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/categories?post=111102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/tags?post=111102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}