{"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\/sq\/blog\/news\/dostupna-subd-mysql-8-2-0","title":{"rendered":"Sistemi i menaxhimit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave MySQL 8.2.0 \u00ebsht\u00eb i disponuesh\u00ebm.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Kompania Oracle krijoi nj\u00eb deg\u00eb t\u00eb re t\u00eb DBMS MySQL 8.2 dhe publikoi p\u00ebrmir\u00ebsime korigjuese p\u00ebr MySQL 8.0.35 dhe 5.7.44. Nd\u00ebrtesat MySQL Community Server 8.2.0 jan\u00eb p\u00ebrgatitur p\u00ebr t\u00eb gjitha distribucionet kryesore t\u00eb Linux, FreeBSD, macOS dhe Windows.    <\/p>\n<p>MySQL 8.2.0 \u00ebsht\u00eb l\u00ebshimi i dyt\u00eb, i formuar n\u00eb kuad\u00ebr t\u00eb modelit t\u00eb ri t\u00eb l\u00ebshimeve, q\u00eb parashikon dy lloje t\u00eb deg\u00ebve MySQL \u2014 \u00abInnovation\u00bb dhe \u00abLTS\u00bb. Deg\u00ebt Innovation, t\u00eb cilat p\u00ebrfshijn\u00eb MySQL 8.1 dhe 8.2, rekomandohen p\u00ebr ata q\u00eb d\u00ebshirojn\u00eb t\u00eb aksesojn\u00eb m\u00eb her\u00ebt funksionalitete t\u00eb reja. K\u00ebto deg\u00eb publikohen \u00e7do 3 muaj dhe mb\u00ebshteten vet\u00ebm deri n\u00eb publikimin e l\u00ebshimit t\u00eb ardhsh\u00ebm t\u00eb r\u00ebnd\u00ebsish\u00ebm (p.sh., mb\u00ebshtetja p\u00ebr deg\u00ebn 8.1 do t\u00eb nd\u00ebrpritet pas daljes s\u00eb deg\u00ebs 8.2). Deg\u00ebt LTS rekomandohen p\u00ebr implementime q\u00eb kan\u00eb nevoj\u00eb p\u00ebr parashikueshm\u00ebri dhe ruajtje t\u00eb q\u00ebndrueshm\u00ebris\u00eb n\u00eb sjellje. Deg\u00ebt LTS do t\u00eb l\u00ebshohen \u00e7do dy vjet dhe do t\u00eb mb\u00ebshteten p\u00ebr 5 vjet, me mund\u00ebsin\u00eb e nj\u00eb mb\u00ebshtetjeje t\u00eb zgjeruar p\u00ebr 3 vjet t\u00eb tjera. Pritet q\u00eb l\u00ebshimi LTS i MySQL 8.4 t\u00eb ndodh\u00eb n\u00eb pranver\u00ebn e vitit 2024, pas t\u00eb cilit do t\u00eb formohet nj\u00eb deg\u00eb e re Innovation 9.0.      <\/p>\n<p>Ndryshimet kryesore n\u00eb MySQL 8.2:  <\/p>\n<ul>\n<li class=\"l\"> jan\u00eb shtuar mb\u00ebshtetje p\u00ebr mekanizmin e autentifikimit t\u00eb bazuar n\u00eb specifikimin Webauthn (FIDO2), i cili mund\u00ebson aplikimin e autentifikimit me shum\u00eb faktor\u00eb dhe konfirmimin e lidhjes n\u00eb <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/sq\/server\/dts-shicago\/\"   title=\"serverit\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2927\">serverit<\/a> MySQL pa fjal\u00ebkalime, duke p\u00ebrdorur token\u00eb harduerik q\u00eb mb\u00ebshtesin FIDO2 ose autentifikim biometrik. Plugini me mb\u00ebshtetje p\u00ebr Webauthn aktualisht \u00ebsht\u00eb i disponuesh\u00ebm vet\u00ebm p\u00ebr MySQL Enterprise.\n<li class=\"l\"> Plugin i serverit mysql_native_password, i cili siguron autentikimin p\u00ebrmes fjal\u00ebkalimeve, \u00ebsht\u00eb kaluar n\u00eb kategorin\u00eb e opsionaleve dhe mund t\u00eb \u00e7aktivizohet. N\u00eb vend t\u00eb mysql_native_password rekomandohet kalimi n\u00eb p\u00ebrdorimin e plugin-it caching_sha2_password, i cili aplikon algoritmin SHA2 p\u00ebr hashimin n\u00eb vend t\u00eb SHA1. P\u00ebr t\u00eb kaluar p\u00ebrdoruesit n\u00eb plugin-in caching_sha2_password me z\u00ebvend\u00ebsimin e fjal\u00ebkalimit me nj\u00eb t\u00eb rast\u00ebsish\u00ebm mund t\u00eb p\u00ebrdoret komanda:       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\"> \u00cbsht\u00eb optimizuar tabela e hash-it, duke lejuar shpejtimin e ekzekutimit t\u00eb operacioneve EXCEPT dhe INTERSECT.\n<li class=\"l\"> Jan\u00eb zgjatur mund\u00ebsit\u00eb e debug-imit. N\u00eb operacionet SELECT, INSERT, REPLACE, UPDATE dhe DELETE \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr shprehjen \u00abEXPLAIN FORMAT=JSON\u00bb p\u00ebr t\u00eb formuar daljen diagnostike n\u00eb formatin JSON (p.sh., \u00abEXPLAIN FORMAT=JSON INTO @var select_stmt;\u00bb).\n<li class=\"l\"> \u00cbsht\u00eb shtuar shprehja \u00abEXPLAIN FOR SCHEMA\u00bb p\u00ebr t\u00eb dh\u00ebn\u00eb diagnoza q\u00eb lidhen vet\u00ebm me nj\u00eb skem\u00eb t\u00eb caktuar t\u00eb t\u00eb dh\u00ebnave.\n<li class=\"l\"> N\u00eb utilitarin mysqldump \u00ebsht\u00eb shtuar opsioni \u00ab--output-as-version\u00bb p\u00ebr t\u00eb krijuar dump-e q\u00eb jan\u00eb t\u00eb kompatib\u00ebl me nj\u00eb version t\u00eb kaluar t\u00eb caktuar t\u00eb MySQL (p.sh., mund t\u00eb specifikohet BEFORE_8_2_0 ose BEFORE_8_0_23 p\u00ebr t\u00eb rikthyer terminologjin\u00eb jo-politikisht korrekte master\/slave, e cila \u00ebsht\u00eb shpallur e vjet\u00ebruar n\u00eb l\u00ebshimet 8.2.0 dhe 8.0.23).\n<li class=\"l\"> N\u00eb bibliotek\u00ebn klient S t\u00eb Shtuar funksionalitetin p\u00ebr p\u00ebrdorimin e atributeve t\u00eb em\u00ebruara n\u00eb k\u00ebrkesat parametrike (prepared statement), t\u00eb realizuara p\u00ebrmes funksionit t\u00eb ri mysql_stmt_bind_named_param(), i cili z\u00ebvend\u00ebson funksionin mysql_stmt_bind_param().\n<li class=\"l\"> \u00cbsht\u00eb thjeshtuar shp\u00ebrndarja e trafikut SQL n\u00eb klasterin e server\u00ebve MySQL. Jan\u00eb ofruar mund\u00ebsi p\u00ebr t\u00eb organizuar lidhje transparente p\u00ebr aplikacionet me server\u00ebt dyt\u00ebsor\u00eb ose primar\u00eb.\n<li class=\"l\"> \u00cbsht\u00eb shtuar privilegji i ri SET_ANY_DEFINER, i cili jep t\u00eb drejt\u00ebn e krijimit t\u00eb objekteve me shprehjen DEFINER, si dhe privilegji ALLOW_NONEXISTENT_DEFINER p\u00ebr mbrojtjen e objekteve pa pronar.\n<li class=\"l\"> Jan\u00eb shpallur t\u00eb vjetruara: variablat old dhe new, maskat \u00ab%\u00bb dhe \u00ab_\u00bb n\u00eb operacionet e dh\u00ebnies s\u00eb qasjes n\u00eb DB, opsioni \u00ab--character-set-client-handshake\u00bb, variabla binlog_transaction_dependency_tracking dhe privilegji SET_USER_ID.\n<li class=\"l\"> Si n\u00eb kuad\u00ebr t\u00eb rregullimit t\u00eb terminologjis\u00eb jo-politikisht korrekte q\u00eb lidhet me replikimin, jan\u00eb shpallur t\u00eb pap\u00ebrdorura shprehjet \"RESET MASTER\", \"SHOW MASTER STATUS\", \"SHOW MASTER LOGS\" dhe \"PURGE MASTER LOGS\", n\u00eb vend t\u00eb cilave duhet t\u00eb p\u00ebrdoren shprehjet \"RESET BINARY LOGS AND GTIDS\", \"SHOW BINARY LOG STATUS\", \"SHOW BINARY LOGS\" dhe \"PURGE BINARY LOGS\".\n<li class=\"l\"> Jan\u00eb hequr mund\u00ebsit\u00eb q\u00eb m\u00eb par\u00eb ishin shpallur t\u00eb pap\u00ebrdorura: funksioni WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(), variabla expire_logs_days, opsionet \"--abort-slave-event-count\" dhe \"--disconnect-slave-event-count\".\n<li class=\"l\"> Jan\u00eb eliminuar 26 vulnerabilitete. Dy vulnerabilitete t\u00eb lidhura me p\u00ebrdorimin e paket\u00ebs Curl dhe bibliotek\u00ebs OpenSSL, mund t\u00eb shfryt\u00ebzohen nga distanca.      <\/ul>\n<p>Burimi: <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.2 - 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\/sq\/blog\/news\/dostupna-subd-mysql-8-2-0\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\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\/sq\/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\udd47SGBD MySQL 8.2.0 | ProHoster","description":"Kompania Oracle ka formuar nj\u00eb deg\u00eb t\u00eb re t\u00eb SGBD MySQL 8.2 dhe ka publikuar p\u00ebrdit\u00ebsime korrigjuese MySQL 8.0.35 dhe 5.7.44.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/news\/dostupna-subd-mysql-8-2-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","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\/sq\/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\/sq\/wp-json\/wp\/v2\/posts\/111102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=111102"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/111102\/revisions"}],"predecessor-version":[{"id":160207,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/111102\/revisions\/160207"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=111102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=111102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=111102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}