A new Vector datatype is supported in CREATE and ALTER statements. MySQL 9.0 also introduces JavaScript Stored Programs in Enterprise Edition, enabling JavaScript-based functions to interact with SQL.
MySQL 9.0 has upgraded to newer versions of libraries and compilers, such as Linux 8 and 9 on GCC13, and Boost 1.85. Additionally, in the Event Scheduler, users can prepare SQL statements for EVENT operations.
In MySQL 9.0, insecure SHA-1 authentication has been removed, and the server rejects mysql_native authentication requests from older client programs. Users upgrading to 9.0 need to alter user accounts to caching_sha2_password from mysql_native_password.
Collection
[
|
...
]