{"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\/fr\/blog\/news\/dostupna-subd-mysql-8-2-0","title":{"rendered":"La base de donn\u00e9es MySQL 8.2.0 est disponible","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>La soci\u00e9t\u00e9 Oracle a d\u00e9velopp\u00e9 une nouvelle branche du SGBD MySQL 8.2 et a publi\u00e9 des mises \u00e0 jour correctives MySQL 8.0.35 et 5.7.44. Les builds de MySQL Community Server 8.2.0 sont pr\u00e9par\u00e9s pour toutes les principales distributions Linux, FreeBSD, macOS et Windows.    <\/p>\n<p>MySQL 8.2.0 est la deuxi\u00e8me version cr\u00e9\u00e9e dans le cadre du nouveau mod\u00e8le de versionnement, qui comprend deux types de branches MySQL \u2014 \u00ab Innovation \u00bb et \u00ab LTS \u00bb. Les branches Innovation, qui incluent MySQL 8.1 et 8.2, sont recommand\u00e9es pour ceux qui souhaitent acc\u00e9der plus t\u00f4t aux nouvelles fonctionnalit\u00e9s. Ces branches sont publi\u00e9es tous les 3 mois et ne sont prises en charge que jusqu'\u00e0 la publication de la prochaine version majeure (par exemple, apr\u00e8s l'apparition de la branche 8.2, la prise en charge de la branche 8.1 est interrompue). Les branches LTS sont recommand\u00e9es pour les d\u00e9ploiements qui n\u00e9cessitent une pr\u00e9visibilit\u00e9 et un comportement constant sur le long terme. Les branches LTS seront publi\u00e9es tous les deux ans et prises en charge normalement pendant 5 ans, avec la possibilit\u00e9 d'une extension de 3 ans de support additionnel. La version LTS de MySQL 8.4 est attendue au printemps 2024, apr\u00e8s quoi une nouvelle branche d'Innovation 9.0 sera form\u00e9e.      <\/p>\n<p>Principales modifications dans MySQL 8.2 :  <\/p>\n<ul>\n<li class=\"l\"> Ajout du support d'un m\u00e9canisme d'authentification bas\u00e9 sur la sp\u00e9cification Webauthn (FIDO2), permettant d'appliquer l'authentification multi-facteurs et de confirmer la connexion \u00e0 <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/fr\/server\/dts-shicago\/\"   title=\"serveur\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2927\">serveur<\/a> MySQL sans mots de passe, en utilisant des jetons mat\u00e9riels compatibles FIDO2 ou une authentification biom\u00e9trique. Le plugin avec support Webauthn n'est pour l'instant disponible que pour MySQL Enterprise.\n<li class=\"l\"> Le plugin serveur mysql_native_password, qui permet l'authentification par mot de passe, a \u00e9t\u00e9 class\u00e9 comme facultatif et peut \u00eatre d\u00e9sactiv\u00e9. Au lieu de mysql_native_password, il est recommand\u00e9 de passer au plugin caching_sha2_password, qui utilise l'algorithme de hachage SHA2 au lieu de SHA1. Pour passer les utilisateurs au plugin caching_sha2_password tout en rempla\u00e7ant leur mot de passe par un mot de passe al\u00e9atoire, on peut utiliser la commande :       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\"> Optimisation des tables de hachage, permettant d'acc\u00e9l\u00e9rer l'ex\u00e9cution des op\u00e9rations EXCEPT et INTERSECT.\n<li class=\"l\"> Les capacit\u00e9s de d\u00e9bogage ont \u00e9t\u00e9 \u00e9tendues. Dans les op\u00e9rations SELECT, INSERT, REPLACE, UPDATE et DELETE, il a \u00e9t\u00e9 ajout\u00e9 le support de l'expression \u00ab EXPLAIN FORMAT=JSON \u00bb pour g\u00e9n\u00e9rer une sortie de diagnostic au format JSON (par exemple, \u00ab EXPLAIN FORMAT=JSON INTO @var select_stmt; \u00bb).\n<li class=\"l\"> Une expression \u00ab EXPLAIN FOR SCHEMA \u00bb a \u00e9t\u00e9 ajout\u00e9e pour fournir un diagnostic li\u00e9 uniquement \u00e0 un sch\u00e9ma de donn\u00e9es sp\u00e9cifique.\n<li class=\"l\"> L'outil mysqldump a ajout\u00e9 l'option \u00ab --output-as-version \u00bb pour cr\u00e9er des dumps compatibles avec une ancienne version sp\u00e9cifique de MySQL (par exemple, on peut sp\u00e9cifier BEFORE_8_2_0 ou BEFORE_8_0_23 pour revenir \u00e0 la terminologie non politiquement correcte ma\u00eetre\/esclave, d\u00e9clar\u00e9e obsol\u00e8te dans les versions 8.2.0 et 8.0.23).\n<li class=\"l\"> La biblioth\u00e8que cliente en C a \u00e9t\u00e9 dot\u00e9e de la possibilit\u00e9 d'utiliser des attributs nomm\u00e9s dans des requ\u00eates param\u00e9tr\u00e9es (prepared statement), mises en \u0153uvre par une nouvelle fonction mysql_stmt_bind_named_param(), rempla\u00e7ant la fonction mysql_stmt_bind_param().\n<li class=\"l\"> La r\u00e9partition du trafic SQL dans le cluster de serveurs MySQL a \u00e9t\u00e9 simplifi\u00e9e. De nouvelles options ont \u00e9t\u00e9 fournies pour organiser des connexions transparentes pour les applications aux serveurs secondaires ou principaux.\n<li class=\"l\"> Un nouveau privil\u00e8ge SET_ANY_DEFINER a \u00e9t\u00e9 ajout\u00e9, permettant de cr\u00e9er des objets avec une expression DEFINER, ainsi qu'un privil\u00e8ge ALLOW_NONEXISTENT_DEFINER pour prot\u00e9ger les objets sans propri\u00e9taire.\n<li class=\"l\"> Les variables old et new, les masques \u00ab % \u00bb et \u00ab _ \u00bb dans les op\u00e9rations de fourniture d'acc\u00e8s \u00e0 la base de donn\u00e9es, l'option \u00ab --character-set-client-handshake \u00bb, la variable binlog_transaction_dependency_tracking et le privil\u00e8ge SET_USER_ID ont \u00e9t\u00e9 d\u00e9clar\u00e9s obsol\u00e8tes.\n<li class=\"l\"> Dans le cadre de la mise \u00e0 jour de la terminologie politiquement correcte li\u00e9e \u00e0 la r\u00e9plication, les expressions \u00ab RESET MASTER \u00bb, \u00ab SHOW MASTER STATUS \u00bb, \u00ab SHOW MASTER LOGS \u00bb et \u00ab PURGE MASTER LOGS \u00bb ont \u00e9t\u00e9 d\u00e9clar\u00e9es obsol\u00e8tes, et il faut d\u00e9sormais utiliser les expressions \u00ab RESET BINARY LOGS AND GTIDS \u00bb, \u00ab SHOW BINARY LOG STATUS \u00bb, \u00ab SHOW BINARY LOGS \u00bb et \u00ab PURGE BINARY LOGS \u00bb.\n<li class=\"l\"> Les fonctionnalit\u00e9s pr\u00e9c\u00e9demment d\u00e9clar\u00e9es obsol\u00e8tes ont \u00e9t\u00e9 supprim\u00e9es : la fonction WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(), la variable expire_logs_days, ainsi que les options \u00ab \u2014abort-slave-event-count \u00bb et \u00ab \u2014disconnect-slave-event-count \u00bb.\n<li class=\"l\"> Vingt-six vuln\u00e9rabilit\u00e9s ont \u00e9t\u00e9 corrig\u00e9es. Deux vuln\u00e9rabilit\u00e9s li\u00e9es \u00e0 l'utilisation du paquet Curl et de la biblioth\u00e8que OpenSSL peuvent \u00eatre exploit\u00e9es \u00e0 distance.      <\/ul>\n<p>Source : <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.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\/fr\/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=\"fr_FR\" \/>\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\/fr\/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\udd47 La SGBD MySQL 8.2.0 est disponible | ProHoster","description":"La soci\u00e9t\u00e9 Oracle a form\u00e9 une nouvelle branche du SGBD MySQL 8.2 et a publi\u00e9 des mises \u00e0 jour correctives pour MySQL 8.0.35 et 5.7.44.","canonical_url":"https:\/\/prohoster.info\/fr\/blog\/news\/dostupna-subd-mysql-8-2-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"fr_FR","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\/fr\/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\/fr\/wp-json\/wp\/v2\/posts\/111102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/comments?post=111102"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts\/111102\/revisions"}],"predecessor-version":[{"id":160207,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts\/111102\/revisions\/160207"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/media?parent=111102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/categories?post=111102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/tags?post=111102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}