{"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\/pl\/blog\/news\/dostupna-subd-mysql-8-2-0","title":{"rendered":"Dost\u0119pna baza danych MySQL 8.2.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Firma Oracle utworzy\u0142a now\u0105 ga\u0142\u0105\u017a baz danych MySQL 8.2 i opublikowa\u0142a aktualizacje poprawkowe MySQL 8.0.35 i 5.7.44. Wersje MySQL Community Server 8.2.0 s\u0105 dost\u0119pne dla wszystkich g\u0142\u00f3wnych dystrybucji Linux, FreeBSD, macOS i Windows.    <\/p>\n<p>MySQL 8.2.0 to druga wersja stworzona w ramach nowego modelu wydawania, kt\u00f3ry przewiduje dwa rodzaje ga\u0142\u0119zi MySQL \u2014 \u201eInnovation\u201d oraz \u201eLTS\u201d. Ga\u0142\u0119zie Innovation, do kt\u00f3rych nale\u017c\u0105 MySQL 8.1 i 8.2, s\u0105 rekomendowane dla tych, kt\u00f3rzy chc\u0105 wcze\u015bniej uzyska\u0107 dost\u0119p do nowej funkcjonalno\u015bci. Te ga\u0142\u0119zie s\u0105 publikowane co 3 miesi\u0105ce i s\u0105 wspierane tylko do momentu wydania nast\u0119pnej istotnej wersji (na przyk\u0142ad, po wydaniu ga\u0142\u0119zi 8.2 wsparcie dla ga\u0142\u0119zi 8.1 zostaje zako\u0144czone). Ga\u0142\u0119zie LTS s\u0105 rekomendowane dla wdro\u017ce\u0144, kt\u00f3re potrzebuj\u0105 przewidywalno\u015bci oraz d\u0142ugotrwa\u0142ego zachowania niezmienno\u015bci. Ga\u0142\u0119zie LTS b\u0119d\u0105 wydawane co dwa lata i wspierane przez 5 lat w trybie regularnym, a dodatkowo mo\u017cliwe b\u0119dzie uzyskanie jeszcze 3 lat wsparcia rozszerzonego. Wiosn\u0105 2024 roku oczekiwane jest wydanie LTS MySQL 8.4, po kt\u00f3rym zostanie utworzona nowa ga\u0142\u0105\u017a Innovation 9.0.      <\/p>\n<p>G\u0142\u00f3wne zmiany w MySQL 8.2:  <\/p>\n<ul>\n<li class=\"l\"> Dodano wsparcie dla mechanizmu uwierzytelniania opartego na specyfikacji Webauthn (FIDO2), co pozwala na stosowanie uwierzytelniania wielosk\u0142adnikowego oraz potwierdzanie po\u0142\u0105czenia z <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/pl\/server\/dts-shicago\/\"   title=\"serwera\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2927\">serwera<\/a> MySQL bez hase\u0142, wykorzystuj\u0105c sprz\u0119towe klucze wspieraj\u0105ce FIDO2 lub uwierzytelnianie biometryczne. Wtyczka wspieraj\u0105ca Webauthn jest tymczasowo dost\u0119pna tylko dla MySQL Enterprise.\n<li class=\"l\"> Wtyczka serwera mysql_native_password, odpowiedzialna za uwierzytelnianie za pomoc\u0105 hase\u0142, zosta\u0142a przeniesiona do kategorii opcjonalnych i mo\u017ce by\u0107 wy\u0142\u0105czona. Zamiast mysql_native_password zaleca si\u0119 przej\u015bcie na wtyczk\u0119 caching_sha2_password, kt\u00f3ra wykorzystuje algorytm SHA2 do haszowania zamiast SHA1. Aby prze\u0142\u0105czy\u0107 u\u017cytkownik\u00f3w na wtyczk\u0119 caching_sha2_password, zmieniaj\u0105c has\u0142o na losowe, mo\u017cna u\u017cy\u0107 polecenia: 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\"> Przeprowadzono optymalizacj\u0119 tabel haszowych, co pozwoli\u0142o przyspieszy\u0107 wykonywanie operacji EXCEPT i INTERSECT.\n<li class=\"l\"> Rozszerzone zosta\u0142y mo\u017cliwo\u015bci debugowania. W operacjach SELECT, INSERT, REPLACE, UPDATE i DELETE dodano wsparcie dla wyra\u017cenia \u201eEXPLAIN FORMAT=JSON\u201d w celu generowania diagnostycznego wyj\u015bcia w formacie JSON (na przyk\u0142ad, \u201eEXPLAIN FORMAT=JSON INTO @var select_stmt;\u201d).\n<li class=\"l\"> Dodano wyra\u017cenie \u201eEXPLAIN FOR SCHEMA\u201d w celu wy\u015bwietlenia diagnostyki zwi\u0105zanej wy\u0142\u0105cznie z konkretn\u0105 schem\u0105 danych.\n<li class=\"l\"> Do narz\u0119dzia mysqldump dodano opcj\u0119 \u201e--output-as-version\u201d do tworzenia zrzut\u00f3w kompatybilnych z okre\u015blon\u0105 starsz\u0105 wersj\u0105 MySQL (na przyk\u0142ad, mo\u017cna wskaza\u0107 BEFORE_8_2_0 lub BEFORE_8_0_23, aby przywr\u00f3ci\u0107 niepoprawn\u0105 politycznie terminologi\u0119 master\/slave, og\u0142oszon\u0105 jako przestarza\u0142a w wydaniach 8.2.0 i 8.0.23).\n<li class=\"l\"> Do biblioteki klienckiej C dodano mo\u017cliwo\u015b\u0107 u\u017cywania nazwanych atrybut\u00f3w w zparametryzowanych zapytaniach (prepared statement), osi\u0105ganych za pomoc\u0105 nowej funkcji mysql_stmt_bind_named_param(), kt\u00f3ra zast\u0119puje funkcj\u0119 mysql_stmt_bind_param().\n<li class=\"l\"> Uproszczono rozdzielanie ruchu SQL w klastrze serwer\u00f3w MySQL. Zapewniono mo\u017cliwo\u015bci organizacji przejrzystych dla aplikacji po\u0142\u0105cze\u0144 z serwerami podrz\u0119dnymi lub nadrz\u0119dnymi.\n<li class=\"l\"> Dodano now\u0105 privilegium SET_ANY_DEFINER, kt\u00f3ra przyznaje prawo tworzenia obiekt\u00f3w z wyra\u017ceniem DEFINER, a tak\u017ce privilegium ALLOW_NONEXISTENT_DEFINER w celu ochrony obiekt\u00f3w z brakuj\u0105cym w\u0142a\u015bcicielem.\n<li class=\"l\"> Og\u0142oszone jako przestarza\u0142e: zmienne old i new, maski \u201e%\u201d oraz \u201e_\u201d w operacjach przyznawania dost\u0119pu do bazy danych, opcja \u201e--character-set-client-handshake\u201d, zmienna binlog_transaction_dependency_tracking oraz przywilej SET_USER_ID.\n<li class=\"l\"> W ramach korekty niepoprawnej terminologii zwi\u0105zanej z replikacj\u0105 og\u0142oszono przestarza\u0142e wyra\u017cenia \u201eRESET MASTER\u201d, \u201eSHOW MASTER STATUS\u201d, \u201eSHOW MASTER LOGS\u201d oraz \u201ePURGE MASTER LOGS\u201d, kt\u00f3re powinny by\u0107 zast\u0105pione wyra\u017ceniami \u201eRESET BINARY LOGS AND GTIDS\u201d, \u201eSHOW BINARY LOG STATUS\u201d, \u201eSHOW BINARY LOGS\u201d oraz \u201ePURGE BINARY LOGS\u201d.\n<li class=\"l\"> Usuni\u0119to mo\u017cliwo\u015bci wcze\u015bniej og\u0142oszone jako przestarza\u0142e: funkcj\u0119 WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(), zmienn\u0105 expire_logs_days, opcje \u201e\u2014abort-slave-event-count\u201d oraz \u201e\u2014disconnect-slave-event-count\u201d.\n<li class=\"l\"> Usuni\u0119to 26 podatno\u015bci. Dwie podatno\u015bci zwi\u0105zane z u\u017cywaniem pakietu Curl i biblioteki OpenSSL mog\u0105 by\u0107 wykorzystywane zdalnie.      <\/ul>\n<p>\u0179r\u00f3d\u0142o: <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.1.1 - 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\/pl\/blog\/news\/dostupna-subd-mysql-8-2-0\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"pl_PL\" \/>\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\/pl\/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\udd47Dost\u0119pna jest baza danych MySQL 8.2.0 | ProHoster","description":"Firma Oracle utworzy\u0142a now\u0105 ga\u0142\u0105\u017a systemu zarz\u0105dzania bazami danych MySQL 8.2 i opublikowa\u0142a poprawki do MySQL 8.0.35 i 5.7.44.","canonical_url":"https:\/\/prohoster.info\/pl\/blog\/news\/dostupna-subd-mysql-8-2-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"pl_PL","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\/pl\/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\/pl\/wp-json\/wp\/v2\/posts\/111102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/comments?post=111102"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/posts\/111102\/revisions"}],"predecessor-version":[{"id":160207,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/posts\/111102\/revisions\/160207"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/media?parent=111102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/categories?post=111102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/tags?post=111102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}