ProHoster > Π‘Π»ΠΎΠ³ > xov xwm hauv internet > MySQL 8.2.0 DBMS muaj

MySQL 8.2.0 DBMS muaj

Oracle tau tsim ib ceg tshiab ntawm MySQL 8.2 DBMS thiab luam tawm cov kev hloov kho tshiab rau MySQL 8.0.35 thiab 5.7.44. MySQL Community Server 8.2.0 tsim yog npaj rau txhua qhov loj Linux, FreeBSD, macOS thiab Windows faib.

MySQL 8.2.0 yog qhov thib ob tso tawm raws li tus qauv tso tawm tshiab, uas muab rau muaj ob hom MySQL ceg - "Innovation" thiab "LTS". Cov ceg tsim kho tshiab, uas suav nrog MySQL 8.1 thiab 8.2, tau pom zoo rau cov neeg uas xav nkag mus rau kev ua haujlwm tshiab ua ntej. Cov ceg ntoo no tau tshaj tawm txhua 3 lub hlis thiab tau txais kev txhawb nqa tsuas yog kom txog thaum qhov kev tso tawm loj tom ntej no tau tshaj tawm (piv txwv li, tom qab lub ntsej muag ntawm 8.2 ceg, kev txhawb nqa rau 8.1 ceg tau txiav tawm). LTS ceg tau pom zoo rau kev siv uas xav tau kev kwv yees thiab kev khaws cia ntev ntawm tus cwj pwm tsis hloov. LTS ceg yuav raug tso tawm txhua ob xyoos thiab yuav tau txais kev txhawb nqa ib txwm rau 5 xyoos, ntxiv rau qhov koj tuaj yeem tau txais lwm 3 xyoos ntawm kev txhawb nqa txuas ntxiv. Ib qho LTS tso tawm ntawm MySQL 2024 yuav tsum nyob rau lub caij nplooj ntoo hlav xyoo 8.4, tom qab ntawd yuav tsim ib ceg tshiab Innovation 9.0.

Cov kev hloov loj hauv MySQL 8.2:

  • Ntxiv kev txhawb nqa rau qhov kev lees paub tseeb raws li Webauthn specification (FIDO2), tso cai rau koj siv ntau qhov kev lees paub thiab lees paub qhov kev sib txuas rau MySQL server yam tsis muaj passwords siv FIDO2-enabled hardware tokens lossis biometric authentication. Lub Webauthn plugin tam sim no tsuas yog muaj rau MySQL Enterprise.
  • Lub mysql_native_password server plugin, uas muab kev lees paub siv cov passwords, tau raug tsiv mus rau qeb xaiv thiab tuaj yeem ua tsis taus. Hloov chaw mysql_native_password, nws raug nquahu kom hloov mus rau caching_sha2_password plugin, uas siv SHA2 algorithm hloov SHA1 rau hashing. Txhawm rau hloov cov neeg siv mus rau caching_sha2_password plugin thiab hloov tus password nrog ib qho random, koj tuaj yeem siv cov lus txib: ALTER USER 'username' @ 'localhost' IDENTIFIED WITH caching_sha2_password LOS NTAWM RANDOM PASSWORD PASSWORD EXPIRE FAILED_LOGIN_ATTEMPTS 3 PASSWLOCK TIME;
  • Hash ntxhuav tau ua kom zoo dua los ua kom tiav kev ua tiav ntawm EXCEPT thiab INTERSECT cov haujlwm.
  • Debugging peev xwm tau nthuav dav. SELECT, INSERT, REPLACE, UPDATE thiab DELETE cov haujlwm tam sim no txhawb nqa cov lus qhia "POV FORMAT = JSON" los tsim cov khoom kuaj pom hauv JSON hom (piv txwv li, "Qhia FORMAT = JSON INTO @var select_stmt;").
  • Ntxiv "Qhia rau SCHEMA" qhia kom pom kev kuaj mob tsuas yog cuam tshuam nrog cov ntaub ntawv tshwj xeeb.
  • Ntxiv "--output-as-version" kev xaiv rau mysqldump kev siv hluav taws xob los tsim cov khoom pov tseg tau sib xws nrog ib qho qub version ntawm MySQL (piv txwv li, koj tuaj yeem hais qhia ua ntej_8_2_0 lossis BEFORE_8_0_23 kom rov qab tsis raug nom tswv / qhev terminology deprecated hauv kev tso tawm 8.2.0. 8.0.23 thiab XNUMX).
  • Lub peev xwm los siv cov khoom muaj npe nyob rau hauv cov lus nug parameterized (npaj nqe lus), tau siv los siv qhov tshiab mysql_stmt_bind_named_param() muaj nuj nqi, uas hloov lub mysql_stmt_bind_param() muaj nuj nqi, tau ntxiv rau tus neeg siv khoom C lub tsev qiv ntawv.
  • Yooj yim faib ntawm SQL tsheb nyob rau hauv ib pawg ntawm MySQL servers. Muaj peev xwm tau muab rau kev teeb tsa kev sib txuas mus rau theem nrab lossis thawj cov servers uas pob tshab rau cov ntawv thov.
  • Ib txoj cai tshiab SET_ANY_DEFINER tau ntxiv lawm, uas tso cai rau tsim cov khoom nrog DEFINER qhia, nrog rau ALLOW_NONEXISTENT_DEFINER txoj cai los tiv thaiv cov khoom nrog tus tswv tsis tuaj.
  • Deprecated: qhov qub thiab tshiab hloov pauv, qhov "%" thiab "_" qhov ncauj qhov ntswg hauv kev ua haujlwm kom tso cai rau kev nkag mus rau hauv cov ntaub ntawv, qhov kev xaiv "-character-set-client-handshake" kev xaiv, binlog_transaction_dependency_tracking variable thiab SET_USER_ID muaj cai.
  • Raws li ib feem ntawm kev kho cov lus tsis raug kev nom kev tswv cuam tshuam nrog kev rov ua dua, cov kab lus "RESET MASTER", "SHOW MASTER STATUS", "Qhia MASTER LOGS" thiab "PURGE MASTER LOGS" tau raug deprecated, thiab cov kab lus "RESET BINARY LOGS THIAB GTIDS" yuav tsum. Qhia BINARY LOG STATUS, "Qhia BINARY LOGS" thiab "PURGE BINARY LOGS".
  • Cov yam ntxwv yav dhau los tau raug tshem tawm tau raug tshem tawm: lub WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS() muaj nuj nqi, lub expire_logs_days sib txawv, qhov "--abort-slave-event-count" thiab "--disconnect-slave-event-count" xaiv.
  • 26 vulnerabilities tsau. Ob qhov tsis zoo uas cuam tshuam txog kev siv cov pob Curl thiab lub tsev qiv ntawv OpenSSL tuaj yeem siv tau nyob deb.

Tau qhov twg los: opennet.ru

Ntxiv ib saib