Search Results
https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html
MySQL includes a mysql_native_password plugin that implements native authentication; that is, authentication based on the password hashing method in use from before the introduction of pluggable authentication. Note The mysql_native_password ...The ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning.html
In MySQL 8.4, partitioning support is provided by the InnoDB and NDB storage engines. MySQL 8.4 does not currently support partitioning of tables using any storage engine other than InnoDB or NDB, such as MyISAM. MySQL 8.4 Community binaries ...Note ...
https://dev.mysql.com/doc/refman/8.4/en/plugin-loading.html
Built-in Plugins Plugins Registered in the mysql.plugin System Table Plugins Named with Command-Line Options Plugins Installed with the INSTALL PLUGIN Statement Built-in Plugins A built-in plugin is known by the server automatically. Plugins ...
https://dev.mysql.com/doc/refman/8.4/en/reusing-ssl-sessions.html
MySQL client programs may elect to resume a prior SSL session, provided that the server has the session in its runtime cache. SSL session cache variables apply to both the mysql_main and mysql_admin TLS channels. For example, change the cache ...
https://dev.mysql.com/doc/refman/8.4/en/revoke.html
To use these REVOKE statements, you must have the global CREATE USER privilege, or the UPDATE privilege for the mysql system schema. REVOKE removes privileges, but does not remove rows from the mysql.user system table. The lower_case_table_names ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-convenience-functions.html
mysql> SET @pt1 = ST_GeomFromText('POINT(0 0)'); mysql> SET @pt2 = ST_GeomFromText('POINT(180 0)'); mysql> SELECT ST_Distance_Sphere(@pt1, @pt2); +--------------------------------+ | ST_Distance_Sphere(@pt1, @pt2) | ... The functions in this section ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-reference.html
mysql> SELECT version_tokens_delete('tok1;tok3'); +------------------------------------+ | version_tokens_delete('tok1;tok3') | +------------------------------------+ | 2 version tokens deleted. (It is not an error to delete nonexisting tokens.) To ... The following discussion serves as a reference to these Version Tokens elements: Version Tokens Functions Version Tokens System Variables Version Tokens Functions The Version Tokens plugin library includes several ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-update-vector-store.html
To test the steps in this topic, download and place the MySQL AI user guide PDF in the folder demo-directory that you created earlier for storing files to ingest into the vector store. To append a new file to the vector store table, perform the ...
https://dev.mysql.com/doc/workbench/en/wb-linux-uninstalling.html
The procedure for uninstalling MySQL Workbench on Linux depends on the package you are using. Note When using apt, the official package name at dev.mysql.com is mysql-workbench-community, whereas most Linux distributions use the name ...For ...
https://dev.mysql.com/doc/workbench/en/wb-manage-server-connections.html
The Manage Server Connections dialog is another way to manage MySQL connections. After the MySQL connection manager is launched, you are presented with the Connection tab of the Manage Server Connections dialog. Figure 5.13 Manage Server ...This ...