Search Results
https://dev.mysql.com/doc/connectors/en/connector-net-simple-membership-tutorial.html
Figure 4.9 Simple Membership: Generated Schema and Tables To create a user login, click Register on the generated web page. This action redirects you to the home page with the newly created user logged in. The data for the newly created user can be ...This tutorial creates an application using a simple membership provider and then adds third-party (Google) OAuth authentication ...
https://dev.mysql.com/doc/connector-net/en/connector-net-simple-membership-tutorial.html
Figure 6.9 Simple Membership: Generated Schema and Tables To create a user login, click Register on the generated web page. This action redirects you to the home page with the newly created user logged in. The data for the newly created user can be ...This tutorial creates an application using a simple membership provider and then adds third-party (Google) OAuth authentication ...
https://dev.mysql.com/doc/refman/8.4/en/sys-sys-config.html
set_by The account that made the most recent modification to the row. As an efficiency measure to minimize the number of direct reads from the sys_config table, sys schema functions that use a value from this table check for a user-defined variable ... This table contains sys schema configuration options, one row per ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-reports-user-statistics.html
The User Statistics report is based on the user summary sys schema views. Figure 30.9 User Statistics Report - Table View Existing users who have never logged on to the instance are not listed in the results. The background user is the owner of the ...Note This graph is displayed only if a MySQL instance is selected in the All Targets drop-down ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-collections-basic-crud.html
The following example shows the basic usage of CRUD operations (see Section 4.3, “Collection CRUD Function Overview” for more details) when working with documents: After establishing a connection to a MySQL Server instance, a new collection that ... Working with collections of documents is straightforward when using X ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-best-hybrid-ref.html
To access the UI or create groups, the users assigned to this role must also be assigned to roles with usable Server Group permissions (Read-Only or Administer). Users are assigned to roles with varying access to the groups. Figure 24.1 Strict ...
Connectors and APIs Manual :: 3.5.12.4 Connecting Using Web Authentication (WebAuthn) Authentication
https://dev.mysql.com/doc/connectors/en/connector-j-WebAuthn-authentication.html
Create a MySQL User Create the MySQL user to be linked to the FIDO device. Use the mysql client with a root user: mysql > CREATE USER 'johndoe'@'%' IDENTIFIED WITH caching_sha2_password BY 's3cr3t' AND IDENTIFIED WITH authentication_webauthn; Query ... Web Authentication (WebAuthn) enables user authentication for MySQL Server using devices such as smart cards, security keys, and biometric ...
https://dev.mysql.com/doc/connector-j/en/connector-j-WebAuthn-authentication.html
Create a MySQL User Create the MySQL user to be linked to the FIDO device. Use the mysql client with a root user: mysql > CREATE USER 'johndoe'@'%' IDENTIFIED WITH caching_sha2_password BY 's3cr3t' AND IDENTIFIED WITH authentication_webauthn; Query ... Web Authentication (WebAuthn) enables user authentication for MySQL Server using devices such as smart cards, security keys, and biometric ...
https://dev.mysql.com/doc/refman/8.4/en/set-default-role.html
SET DEFAULT ROLE requires these privileges: Setting the default roles for another user requires the global CREATE USER privilege, or the UPDATE privilege for the mysql.default_roles system table. SET DEFAULT ROLE {NONE | ALL | role [, role ] ...} ...Setting the default roles for yourself requires no special privileges, as long as the roles you want as the default have been granted to ...
https://dev.mysql.com/doc/refman/8.4/en/set-variable.html
User-Defined Variable Assignment Parameter and Local Variable Assignment System Variable Assignment SET Error Handling Multiple Variable Assignment System Variable References in Expressions User-Defined Variable Assignment User-defined variables are ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | ...