"But it still contains useful things and can be upgraded to from MySQL 8.4 LTS; the MySQL Configurator automatically does the upgrade without user intervention during MSI installations on Windows. The major changes include: A new Vector datatype is supported in CREATE and ALTER statements. JavaScript Stored Programs, which support JavaScript-based stored programs and functions, has come to MySQL Enterprise Edition. JavaScript Stored Programs can call SQL, and SQL can call them."
"MySQL 9.0 Innovation has moved to newer versions of libraries and compilers: Linux 8 and 9 on GCC13, and Boost 1.85. In the Event Scheduler, users can now prepare SQL statements CREATE EVENT, ALTER EVENT, and DROP EVENT. What's going away in MySQL 9.0 Insecure and elderly SHA-1, after being deprecated in MySQL 8, is gone, and the server now rejects mysql_native authentication requests from older client programs which do not have CLIENT_PLUGIN_AUTH capability."
MySQL 9.0.0 adds a Vector datatype usable in CREATE and ALTER statements and introduces JavaScript Stored Programs in Enterprise Edition that allow JavaScript functions to call SQL and be invoked by SQL. The release updates toolchain components to Linux 8/9 on GCC13 and Boost 1.85. The MySQL Configurator performs automatic upgrades from MySQL 8.4 LTS during Windows MSI installations. The Event Scheduler can now prepare CREATE EVENT, ALTER EVENT, and DROP EVENT statements. Insecure SHA-1 authentication is removed; servers reject mysql_native authentication from older clients lacking CLIENT_PLUGIN_AUTH, and user accounts must be converted to caching_sha2_password before upgrading.
Read at InfoWorld
Unable to calculate read time
Collection
[
|
...
]