Search Results
https://dev.mysql.com/doc/refman/8.4/en/json-creation-functions.html
The functions listed in this section compose JSON values from component elements. JSON_ARRAY([val[, val] ...]) Evaluates a (possibly empty) list of values and returns a JSON array containing those values. mysql> SELECT JSON_ARRAY(1, "abc", NULL, ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-get-started.html
The topics in this section go through the process of training and using a machine learning model. Before going through these tasks, make sure to Review Additional AutoML Requirements. To start using AutoML with sample datasets, see Machine Learning ...
https://dev.mysql.com/doc/refman/8.4/en/roles.html
Creating Roles and Granting Privileges to Them Defining Mandatory Roles Checking Role Privileges Activating Roles Revoking Roles or Role Privileges Dropping Roles User and Role Interchangeability Creating Roles and Granting Privileges to Them ...
https://dev.mysql.com/doc/refman/8.4/en/kerberos-pluggable-authentication.html
Applications are able to authenticate using a provided user name and password, or using a locally cached TGT or ST (for example, created using kinit or similar). The output should be similar to this: $> klist Ticket cache: FILE:/tmp/krb5cc_244306 ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
Modifications occur indirectly when you use account-management statements such as CREATE USER, GRANT, and REVOKE to set up accounts and control the privileges available to each one. password_last_changed is updated by the CREATE USER, ALTER USER, ...
https://dev.mysql.com/doc/refman/8.4/en/windows-pluggable-authentication.html
To refer to the Windows authentication plugin in the IDENTIFIED WITH clause of a CREATE USER statement, use the name authentication_windows. To set this up, create a MySQL account named sql_admin that uses the Windows plugin for authentication: ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
For example, Create DB and Change user correspond to COM_CREATE_DB and COM_CHANGE_USER, respectively. For example, "Create DB" and "Change user" correspond to COM_CREATE_DB and COM_CHANGE_USER, respectively. <AUDIT_RECORD> ... The MySQL server calls ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-cluster-user-accounts.html
Configuring InnoDB Cluster Administrator Accounts Manually Internal User Accounts Created by InnoDB Cluster Resetting Recovery Account Passwords The member servers in an InnoDB Cluster make use of three types of user accounts. Create the same ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins-proxy-users.html
Use the CREATE USER or GRANT statement to associate accounts with plugins. This string comes from the AS part of the IDENTIFIED WITH clause of the CREATE USER statement that specifies use of the plugin for authentication. For example: CREATE USER ...
https://dev.mysql.com/doc/refman/8.4/en/connection-access.html
Account locking can be set or changed with the CREATE USER or ALTER USER statement. The server performs identity and credentials checking using columns in the user table, accepting the connection only if these conditions are satisfied: The client ...