{"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\/ro\/blog\/news\/dostupna-subd-mysql-8-2-0","title":{"rendered":"Sistemul de gestionare a bazelor de date MySQL 8.2.0 este disponibil","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Compania Oracle a format o nou\u0103 ramur\u0103 a SGBD-ului MySQL 8.2 \u0219i a publicat actualiz\u0103rile corective MySQL 8.0.35 \u0219i 5.7.44. Versiunile MySQL Community Server 8.2.0 sunt preg\u0103tite pentru toate distribu\u021biile principale de Linux, FreeBSD, macOS \u0219i Windows.    <\/p>\n<p>MySQL 8.2.0 este a doua versiune creat\u0103 \u00een cadrul noului model de eliberare, care prevede existen\u021ba a dou\u0103 tipuri de ramuri MySQL \u2014 \u201eInnovation\u201d \u0219i \u201eLTS\u201d. Ramurile Innovation, care includ MySQL 8.1 \u0219i 8.2, sunt recomandate pentru cei care doresc acces timpuriu la noi func\u021bionalit\u0103\u021bi. Aceste ramuri sunt publicate la fiecare 3 luni \u0219i sunt sus\u021binute doar p\u00e2n\u0103 la publicarea urm\u0103toarei versiuni semnificative (de exemplu, dup\u0103 apari\u021bia ramurii 8.2, suportul pentru ramura 8.1 este oprit). Ramurile LTS sunt recomandate pentru implement\u0103rile care necesit\u0103 predictibilitate \u0219i comportament constant pe termen lung. Ramurile LTS vor fi lansate o dat\u0103 la doi ani \u0219i vor fi sus\u021binute timp de 5 ani, plus \u00eenc\u0103 3 ani de suport extins. \u00cen prim\u0103vara anului 2024, se a\u0219teapt\u0103 lansarea LTS a MySQL 8.4, dup\u0103 care va fi creat\u0103 o nou\u0103 ramur\u0103 Innovation 9.0.      <\/p>\n<p>Principalele modific\u0103ri \u00een MySQL 8.2:  <\/p>\n<ul>\n<li class=\"l\"> A fost ad\u0103ugat\u0103 suport pentru mecanismul de autentificare bazat pe specifica\u021bia Webauthn (FIDO2), care permite aplicarea autentific\u0103rii multifactor \u0219i confirmarea conexiunii la <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/ro\/server\/dts-shicago\/\"   title=\"server\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2927\">server<\/a> MySQL f\u0103r\u0103 parole, utiliz\u00e2nd tokenuri hardware compatibile cu FIDO2 sau autentificare biometric\u0103. Pluginul cu suport pentru Webauthn este disponibil \u00een prezent doar pentru MySQL Enterprise.\n<li class=\"l\"> Pluginul serverului mysql_native_password, care asigur\u0103 autentificarea prin parole, a fost mutat \u00een categoria op\u021bional\u0103 \u0219i poate fi dezactivat. \u00cen loc de mysql_native_password, se recomand\u0103 trecerea la utilizarea pluginului caching_sha2_password, care folose\u0219te algoritmul SHA2 pentru hashing, \u00een loc de SHA1. Pentru a transfera utilizatorii pe pluginul caching_sha2_password cu \u00eenlocuirea parolei cu una aleatorie, se poate folosi comanda:       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\"> A fost optimizat tabelul hash, permi\u021b\u00e2nd accelerarea opera\u021biunilor EXCEPT \u0219i INTERSECT.\n<li class=\"l\"> Capacit\u0103\u021bile de depanare au fost extinse. \u00cen opera\u021biile SELECT, INSERT, REPLACE, UPDATE \u0219i DELETE a fost ad\u0103ugat\u0103 suportul pentru expresia \u201eEXPLAIN FORMAT=JSON\u201d pentru a genera ie\u0219iri diagnostice \u00een format JSON (de exemplu, \u201eEXPLAIN FORMAT=JSON INTO @var select_stmt;\u201d).\n<li class=\"l\"> A fost ad\u0103ugat\u0103 expresia \u201eEXPLAIN FOR SCHEMA\u201d pentru a produce diagnostice legate doar de o schem\u0103 de date specific\u0103.\n<li class=\"l\"> \u00cen utilitarul mysqldump a fost ad\u0103ugat\u0103 op\u021biunea \u201e--output-as-version\u201d pentru a crea dump-uri compatibile cu o versiune veche specific\u0103 de MySQL (de exemplu, se poate specifica BEFORE_8_2_0 sau BEFORE_8_0_23 pentru a reveni la terminologia nepoliticos corect\u0103 master\/slave, declarat\u0103 \u00eenvechit\u0103 \u00een versiunile 8.2.0 \u0219i 8.0.23).\n<li class=\"l\"> Biblioteca client C a fost extins\u0103 cu posibilitatea utiliz\u0103rii atributelor denumite \u00een interog\u0103ri parametrizate (prepared statement), implementate prin noua func\u021bie mysql_stmt_bind_named_param(), care \u00eenlocuie\u0219te func\u021bia mysql_stmt_bind_param().\n<li class=\"l\"> A fost simplificat\u0103 distribu\u021bia traficului SQL \u00een clusterele de servere MySQL. Au fost oferite posibilit\u0103\u021bi pentru stabilirea de conexiuni transparente pentru aplica\u021bii la servere secundare sau primare.\n<li class=\"l\"> A fost ad\u0103ugat\u0103 noua privilegiu SET_ANY_DEFINER, care confer\u0103 dreptul de a crea obiecte cu expresia DEFINER, precum \u0219i privilegiul ALLOW_NONEXISTENT_DEFINER pentru a proteja obiectele f\u0103r\u0103 un proprietar.\n<li class=\"l\"> Au fost declarate \u00eenvechite: variabilele old \u0219i new, m\u0103\u0219tile \u201e%\u201d \u0219i \u201e_\u201d \u00een opera\u021biile de acordare a accesului la BD, op\u021biunea \u201e--character-set-client-handshake\u201d, variabila binlog_transaction_dependency_tracking \u0219i privilegiul SET_USER_ID.\n<li class=\"l\"> \u00cen cadrul ajust\u0103rii terminologiei considerate necorespunz\u0103toare din punct de vedere politic, expresiile \u201eRESET MASTER\u201d, \u201eSHOW MASTER STATUS\u201d, \u201eSHOW MASTER LOGS\u201d \u0219i \u201ePURGE MASTER LOGS\u201d au fost declarate dep\u0103\u0219ite, iar \u00een locul lor ar trebui folosite expresiile \u201eRESET BINARY LOGS AND GTIDS\u201d, \u201eSHOW BINARY LOG STATUS\u201d, \u201eSHOW BINARY LOGS\u201d \u0219i \u201ePURGE BINARY LOGS\u201d.\n<li class=\"l\"> Func\u021bionalit\u0103\u021bile anterioare declarate dep\u0103\u0219ite au fost eliminate: func\u021bia WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(), variabila expire_logs_days, op\u021biunile \u201e\u2014abort-slave-event-count\u201d \u0219i \u201e\u2014disconnect-slave-event-count\u201d.\n<li class=\"l\"> Au fost remediate 26 de vulnerabilit\u0103\u021bi. Dou\u0103 vulnerabilit\u0103\u021bi legate de utilizarea pachetului Curl \u0219i a bibliotecii OpenSSL pot fi exploatate de la distan\u021b\u0103.      <\/ul>\n<p>Sursa: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=59995\">opennet.ro<\/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.2.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\/ro\/blog\/news\/dostupna-subd-mysql-8-2-0\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"ro_RO\" \/>\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\/ro\/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\udd47Sistemul de gestionare a bazelor de date MySQL 8.2.0 | ProHoster","description":"Compania Oracle a creat un nou ramur\u0103 a sistemului de gestionare a bazelor de date MySQL 8.2 \u0219i a publicat actualiz\u0103ri corective pentru MySQL 8.0.35 \u0219i 5.7.44.","canonical_url":"https:\/\/prohoster.info\/ro\/blog\/news\/dostupna-subd-mysql-8-2-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"ro_RO","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\/ro\/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\/ro\/wp-json\/wp\/v2\/posts\/111102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=111102"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/111102\/revisions"}],"predecessor-version":[{"id":160207,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/111102\/revisions\/160207"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=111102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=111102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=111102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}