{"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\/es\/blog\/news\/dostupna-subd-mysql-8-2-0","title":{"rendered":"La base de datos MySQL 8.2.0 est\u00e1 disponible","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>La empresa Oracle ha creado una nueva rama de la base de datos MySQL 8.2 y ha publicado actualizaciones de correcci\u00f3n para MySQL 8.0.35 y 5.7.44. Las compilaciones de MySQL Community Server 8.2.0 est\u00e1n preparadas para todas las principales distribuciones de Linux, FreeBSD, macOS y Windows.    <\/p>\n<p>MySQL 8.2.0 es la segunda versi\u00f3n desarrollada bajo el nuevo modelo de lanzamiento, que incluye dos tipos de ramas MySQL: \u00abInnovation\u00bb y \u00abLTS\u00bb. Las ramas Innovation, que incluyen MySQL 8.1 y 8.2, est\u00e1n recomendadas para quienes desean acceder a nuevas funcionalidades m\u00e1s r\u00e1pidamente. Estas ramas se publican cada 3 meses y solo se mantienen hasta el lanzamiento de la siguiente versi\u00f3n importante (por ejemplo, una vez publicada la rama 8.2, se suspende el soporte para la rama 8.1). Las ramas LTS son recomendadas para implementaciones que requieren previsibilidad y un comportamiento inalterado a largo plazo. Las ramas LTS se lanzar\u00e1n cada dos a\u00f1os y se mantendr\u00e1n durante 5 a\u00f1os, adem\u00e1s de otros 3 a\u00f1os de soporte extendido que se podr\u00e1n obtener. Se espera que la versi\u00f3n LTS de MySQL 8.4 sea lanzada en primavera de 2024, tras la cual se formar\u00e1 una nueva rama de Innovation 9.0.      <\/p>\n<p>Principales cambios en MySQL 8.2:  <\/p>\n<ul>\n<li class=\"l\"> Se ha agregado soporte para un mecanismo de autenticaci\u00f3n basado en la especificaci\u00f3n Webauthn (FIDO2), que permite implementar autenticaci\u00f3n multifactor y verificar la conexi\u00f3n a <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/es\/server\/dts-shicago\/\"   title=\"servidor\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2927\">servidor<\/a> MySQL sin contrase\u00f1as, utilizando tokens hardware compatibles con FIDO2 o autenticaci\u00f3n biom\u00e9trica. El plugin compatible con Webauthn est\u00e1 actualmente disponible solo para MySQL Enterprise.\n<li class=\"l\"> El plugin de servidor mysql_native_password, que proporciona autenticaci\u00f3n mediante contrase\u00f1as, ha sido trasladado a la categor\u00eda de opcionales y puede ser desactivado. En lugar de mysql_native_password, se recomienda utilizar el plugin caching_sha2_password, que aplica el algoritmo de hash SHA2 en lugar de SHA1. Para cambiar a los usuarios al plugin caching_sha2_password y reemplazar la contrase\u00f1a por una aleatoria, se puede usar el siguiente comando:       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\"> Se ha optimizado la ejecuci\u00f3n de tablas hash, lo que ha permitido acelerar las operaciones EXCEPT e INTERSECT.\n<li class=\"l\"> Se han ampliado las capacidades de depuraci\u00f3n. En las operaciones SELECT, INSERT, REPLACE, UPDATE y DELETE se ha a\u00f1adido soporte para la expresi\u00f3n \u00abEXPLAIN FORMAT=JSON\u00bb para generar salida diagn\u00f3stica en formato JSON (por ejemplo, \u00abEXPLAIN FORMAT=JSON INTO @var select_stmt;\u00bb).\n<li class=\"l\"> Se ha a\u00f1adido la expresi\u00f3n \u00abEXPLAIN FOR SCHEMA\u00bb para proporcionar diagn\u00f3sticos relacionados solo con un esquema de datos espec\u00edfico.\n<li class=\"l\"> Se ha a\u00f1adido la opci\u00f3n \u00ab--output-as-version\u00bb a la utilidad mysqldump para crear volcado compatible con una versi\u00f3n anterior espec\u00edfica de MySQL (por ejemplo, se puede especificar BEFORE_8_2_0 o BEFORE_8_0_23 para volver a la terminolog\u00eda considerada poco apropiada master\/slave, que fue depreciada en las versiones 8.2.0 y 8.0.23).\n<li class=\"l\"> Se ha incorporado a la biblioteca C del cliente la capacidad de utilizar atributos nombrados en consultas parametrizadas (prepared statement) mediante la nueva funci\u00f3n mysql_stmt_bind_named_param(), que sustituye a mysql_stmt_bind_param().\n<li class=\"l\"> Se ha simplificado la distribuci\u00f3n del tr\u00e1fico SQL en el cl\u00faster de servidores MySQL. Se han proporcionado capacidades para establecer conexiones transparentes para las aplicaciones a servidores secundarios o primarios.\n<li class=\"l\"> Se ha a\u00f1adido un nuevo privilegio SET_ANY_DEFINER, que otorga el derecho de crear objetos con la expresi\u00f3n DEFINER, as\u00ed como el privilegio ALLOW_NONEXISTENT_DEFINER para proteger objetos sin propietario.\n<li class=\"l\"> Han sido declaradas obsoletas: las variables old y new, las m\u00e1scaras \u00ab%\u00bb y \u00ab_\u00bb en las operaciones de concesi\u00f3n de acceso a BD, la opci\u00f3n \u00ab--character-set-client-handshake\u00bb, la variable binlog_transaction_dependency_tracking y el privilegio SET_USER_ID.\n<li class=\"l\"> En el marco de la correcci\u00f3n de la terminolog\u00eda pol\u00edticamente incorrecta relacionada con la replicaci\u00f3n, se han declarado obsoletas las expresiones \u00abRESET MASTER\u00bb, \u00abSHOW MASTER STATUS\u00bb, \u00abSHOW MASTER LOGS\u00bb y \u00abPURGE MASTER LOGS\u00bb, por las cuales se deben usar las expresiones \u00abRESET BINARY LOGS AND GTIDS\u00bb, \u00abSHOW BINARY LOG STATUS\u00bb, \u00abSHOW BINARY LOGS\u00bb y \u00abPURGE BINARY LOGS\u00bb.\n<li class=\"l\"> Se han eliminado las funciones que anteriormente se hab\u00edan declarado obsoletas: la funci\u00f3n WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(), la variable expire_logs_days, y las opciones \u00ab--abort-slave-event-count\u00bb y \u00ab--disconnect-slave-event-count\u00bb.\n<li class=\"l\"> Se han corregido 26 vulnerabilidades. Dos vulnerabilidades relacionadas con el uso del paquete Curl y la biblioteca OpenSSL pueden ser explotadas de forma remota.      <\/ul>\n<p>Fuente: <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\/es\/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=\"es_ES\" \/>\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\/es\/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\udd47Base de datos MySQL 8.2.0 disponible | ProHoster","description":"Oracle ha formado una nueva rama de la base de datos MySQL 8.2 y ha publicado actualizaciones correctivas para MySQL 8.0.35 y 5.7.44.","canonical_url":"https:\/\/prohoster.info\/es\/blog\/news\/dostupna-subd-mysql-8-2-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"es_ES","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\/es\/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\/es\/wp-json\/wp\/v2\/posts\/111102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/comments?post=111102"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/posts\/111102\/revisions"}],"predecessor-version":[{"id":160207,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/posts\/111102\/revisions\/160207"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/media?parent=111102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/categories?post=111102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/tags?post=111102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}