What's new in MySQL 9.0
Briefly

MySQL 9.0.0, labeled as the Innovation release, brings significant updates including a new Vector datatype and support for JavaScript Stored Programs, enhancing functionality. The upgrade from MySQL 8.4 LTS is automated through the MySQL Configurator on Windows systems, ensuring a seamless user experience. It also features updated support libraries and improvements to the Event Scheduler. However, notable removals include the deprecated SHA-1 authentication, compelling users to migrate to more secure authentication methods before upgrading.
MySQL 9.0.0 introduces a new Vector datatype, JavaScript Stored Programs, updated library versions, and enhancements to the Event Scheduler, while deprecating old SHA-1 security.
This release sets the stage for future features and allows seamless upgrade from MySQL 8.4 LTS with automated processes for Windows installations.
The transition from mysql_native_password to caching_sha2_password is necessary, as older authentication methods are no longer supported.
MySQL 9.0 ensures improved functionality and security, positioning Oracle's database solution to accommodate modern data management needs.
Read at InfoWorld
[
|
]