{"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\/et\/blog\/news\/dostupna-subd-mysql-8-2-0","title":{"rendered":"Saadaval on andmebaas MySQL 8.2.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Ettev\u00f5te Oracle on loonud uue andmebaasi haru MySQL 8.2 ja avaldanud parandused versioonidele MySQL 8.0.35 ja 5.7.44. MySQL Community Serveri versioonid 8.2.0 on ette valmistatud k\u00f5igi peamiste Linuxi, FreeBSD, macOS ja Windowsi jaotuste jaoks.    <\/p>\n<p>MySQL 8.2.0 on teine v\u00e4ljaanne, mis on loodud vastavalt uuele v\u00e4ljaande mudelile, kus on kaks t\u00fc\u00fcpi MySQL hargne: \"Innovation\" ja \"LTS\". Innovation harud, kuhu kuuluvad MySQL 8.1 ja 8.2, on soovitatavad neile, kes soovivad varakult uusi funktsioone kasutada. Need harud avaldatakse iga 3 kuu tagant ja toetatakse ainult j\u00e4rgmise olulise v\u00e4ljaande avaldamiseni (n\u00e4iteks p\u00e4rast 8.2 v\u00e4ljaande ilmumist l\u00f5petatakse 8.1 toe andmine). LTS-harud on soovitatavad rakendustele, mis vajavad ennustatavust ja pikaajalist stabiilsust. LTS harud avaldatakse iga kahe aasta tagant ja neid toetatakse tavap\u00e4raselt 5 aastat, millele lisandub veel 3 aastat pikendatud tuge. Kevadel 2024 oodatakse LTS-v\u00e4ljaannet MySQL 8.4, p\u00e4rast mida luuakse uus Innovation-haru 9.0.      <\/p>\n<p>Peamised muudatused MySQL 8.2:  <\/p>\n<ul>\n<li class=\"l\"> Lisatud on Webauthn (FIDO2) spetsifikatsioonil p\u00f5hineva autentimise toe mehhanism, mis v\u00f5imaldab rakendada mitme teguri autentimist ja kinnitada \u00fchenduse MySQL-iga ilma paroolideta, kasutades FIDO2 toega riistvaralisi tokeneid v\u00f5i biometrilist autentimist. Webauthni tugi on hetkel saadaval ainult MySQL Enterprise'i jaoks. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/et\/server\/dts-shicago\/\"   title=\"serveri\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2927\">serveri<\/a> Serveri plugin mysql_native_password, mis tagab autentimise paroolide kaudu, on muudetud valikuliseks ja seda saab v\u00e4lja l\u00fclitada. Soovitatav on \u00fcle minna pluginole caching_sha2_password, mis kasutab r\u00e4si genereerimiseks SHA2 algoritmi, mitte SHA1. Kasutajate \u00fcleviimiseks caching_sha2_password pluginole koos parooli asendamisega juhusliku parooliga v\u00f5ib kasutada k\u00e4sku: ALTER USER \u2018username\u2019@\u2019localhost\u2019 IDENTIFIED WITH caching_sha2_password BY RANDOM PASSWORD PASSWORD EXPIRE FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LOCK_TIME 2;\n<li class=\"l\"> Serveri plugin mysql_native_password, mis tagab autentimise paroolide abil, on muudetud valikuliseks ja seda saab v\u00e4lja l\u00fclitada. Soovitame mysql_native_password asemel kasutada pluginat caching_sha2_password, mis kasutab h\u00e4\u00e4likute rikka kimara SHA2 asemel SHA1. Kasutaja muutmiseks pluginat caching_sha2_password koos parooli asendamisega juhuslikuga saab kasutada k\u00e4sku: 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\"> T\u00f5rkeotsimisv\u00f5imalusi on laiendatud. SELECT, INSERT, REPLACE, UPDATE ja DELETE operatsioonides on lisatud toetust v\u00e4ljendile \u00abEXPLAIN FORMAT=JSON\u00bb, et genereerida diagnostilist v\u00e4ljundit JSON formaadis (nt \u00abEXPLAIN FORMAT=JSON INTO @var select_stmt;\u00bb).\n<li class=\"l\"> J\u00f5udlusv\u00f5imekuse laiendamine. Valiku, INSERTi, REPLACE'i, UPDATE'i ja DELETE'i operatsioonidesse on lisatud v\u00e4ljendi \"EXPLAIN FORMAT=JSON\" tugi diagnostiliste v\u00e4ljundite loomiseks JSON formaadis (n\u00e4iteks \"EXPLAIN FORMAT=JSON INTO @var select_stmt;\").\n<li class=\"l\"> On lisatud v\u00e4ljend \"EXPLAIN FOR SCHEMA\" diagnostika kuvamiseks, mis on seotud ainult teatud andmeskeemiga.\n<li class=\"l\"> T\u00f6\u00f6riista mysqldump on lisatud valik \"--output-as-version\" vanade versioonide MySQL-iga \u00fchilduvate dumpide loomiseks (n\u00e4iteks v\u00f5ib m\u00e4\u00e4rata BEFORE_8_2_0 v\u00f5i BEFORE_8_0_23, et naasta poliitiliselt ebasobiva terminoloogia master\/slave juurde, mis kuulutati 8.2.0 ja 8.0.23 v\u00e4ljaannetes vananenuks).\n<li class=\"l\"> Klientse C teegi on lisatud v\u00f5imalus kasutada nimelisi atribuute parameteriseeritud p\u00e4ringutes (prepared statement), mida rakendatakse uue funktsiooni mysql_stmt_bind_named_param() abil, mis asendab funktsiooni mysql_stmt_bind_param().\n<li class=\"l\"> MySQL serverite klastri SQL-liikluse jaotamine on lihtsustatud. On loodud v\u00f5imalused rakendusele l\u00e4bipaistvate \u00fchenduste loomiseks sekundaarsete v\u00f5i primaarsete serveritega.\n<li class=\"l\"> Lisatud uus privileeg SET_ANY_DEFINER, mis annab \u00f5iguse luua objekte DEFINER v\u00e4ljendiga, samuti privileeg ALLOW_NONEXISTENT_DEFINER, mis kaitseb objekte, millel puudub omanik.\n<li class=\"l\"> On tunnistatud vananenuks: muutuja old ja new, maskid \"%\" ja \"_\" andmebaasi juurdep\u00e4su operatsioonides, valik \"--character-set-client-handshake\", muutuja binlog_transaction_dependency_tracking ja privileeg SET_USER_ID.\n<li class=\"l\"> Konteksti parandamiseks on poliitiliselt ebasobiva terminoloogia osas, mis puudutab replikatsiooni, muutunud vananenud m\u00f5isted \u201eRESET MASTER\u201c, \u201eSHOW MASTER STATUS\u201c, \u201eSHOW MASTER LOGS\u201c ja \u201ePURGE MASTER LOGS\u201c, mille asemel tuleks kasutada m\u00f5isted \u201eRESET BINARY LOGS AND GTIDS\u201c, \u201eSHOW BINARY LOG STATUS\u201c, \u201eSHOW BINARY LOGS\u201c ja \u201ePURGE BINARY LOGS\u201c.\n<li class=\"l\"> Eemaldatud on varasemalt vananenud v\u00f5imalused: funktsioon WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(), muutujad expire_logs_days, valikud \u201e--abort-slave-event-count\u201c ja \u201e--disconnect-slave-event-count\u201c.\n<li class=\"l\"> 26 haavatavust on k\u00f5rvaldatud. Kaks haavatavust, mis on seotud Curl paketi ja OpenSSL teegiga, v\u00f5ivad olla kaugelt \u00e4ra kasutada.      <\/ul>\n<p>Allikas: <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\/et\/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=\"et_EE\" \/>\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\/et\/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\udd47MySQL 8.2.0 andmebaas on saadaval | ProHoster","description":"Oracle on loonud uue MySQL andmebaasi 8.2 haru ja avaldanud paranduste v\u00e4rskendused MySQL 8.0.35 ja 5.7.44.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/news\/dostupna-subd-mysql-8-2-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","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\/et\/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\/et\/wp-json\/wp\/v2\/posts\/111102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=111102"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/111102\/revisions"}],"predecessor-version":[{"id":160207,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/111102\/revisions\/160207"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=111102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=111102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=111102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}