Search Results
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-conf-options.html
“User” in this context refers to a system login account, not a MySQL user listed in the grant tables. On Linux, installing Router with official DEB or RPM packages creates a local system user and group named "mysqlrouter" on the host, and MySQL ...For example, user under the [DEFAULT] section refers to the system user running router, while user under the [metadata_cache] section refers to the MySQL user that accesses ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
Within a stored program or view, CURRENT_USER() returns the account for the user who defined the object (as given by its DEFINER value) unless defined with the SQL SECURITY INVOKER characteristic. Triggers and events have no option to define the SQL ...mysql> SELECT CHARSET('abc'); -> 'utf8mb3' mysql> SELECT CHARSET(CONVERT('abc' USING latin1)); -> 'latin1' mysql> SELECT CHARSET(USER()); -> 'utf8mb3' COERCIBILITY(str) Returns the collation coercibility value of the string ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/ui-security-advisor-ref.html
This advisor enables you to define a regular expression that describes those user accounts that are allowed to have database level privileges on all databases in the mysql.user table (ALTER, CREATE, DELETE, DROP, INDEX, INSERT, SELECT, UPDATE). The ...This advisor enables you to configure event generation for the audit log ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-using-management-client.html
START BACKUP supports the creation of encrypted backups using ENCRYPT PASSWORD=password. Note NDB Cluster never saves the user-furnished password or generated encryption key. In this case, the management client prompts the user for a password.
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
Accounts created with the SYSTEM_USER privilege have the AUDIT_ABORT_EXEMPT privilege assigned automatically when they are created. Important It is theoretically possible for a user with sufficient permissions to mistakenly create an abort item in ...An event in the connection class indicates when a connection-related activity occurs during a session, such as a user connecting to or disconnecting from the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-uri.html
As of MySQL 9.3.1, and only on MySQL HeatWave on OCI, you can use uniform resource identifiers (URI) to specify files for loading data when creating external tables manually. Review the following examples for different ways to create external ...
https://dev.mysql.com/doc/refman/8.4/en/xml-functions.html
You may discuss these, ask questions about them, and obtain help from other users with them in the MySQL XML User Forum. XPath expressions used with these functions support user variables and local stored program variables. User variables are weakly ... Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in ...
https://dev.mysql.com/doc/refman/8.4/en/multifactor-authentication.html
CREATE USER and ALTER USER have syntax enabling multiple authentication methods to be specified for new accounts, and for adding, modifying, or dropping authentication methods for existing accounts. (A warning does occur for statements that ...That ...That is, MySQL account management supports accounts that use 2FA or 3FA, in addition to the existing 1FA ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-a-recommendation-model-items-to-users.html
The following example runs ML_PREDICT_TABLE on the testing dataset previously created and sets the topk parameter to 2, so only two users are recommended. This topic describes how to generate recommended users for items. For known users and known ...Set remove_seen to false to repeat existing interactions from the training ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-using-a-recommendation-model-items-to-users.html
The following example runs ML_PREDICT_TABLE on the testing dataset previously created and sets the topk parameter to 2, so only two users are recommended. This topic describes how to generate recommended users for items. For known users and known ...Set remove_seen to false to repeat existing interactions from the training ...