Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary-by-file-io.html
The user_summary_by_file_io and x$user_summary_by_file_io views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are ...By ...
https://dev.mysql.com/doc/refman/8.4/en/system-variable-privileges.html
Note Any user who has SYSTEM_VARIABLES_ADMIN or SUPER effectively has SESSION_VARIABLES_ADMIN by implication and need not be granted SESSION_VARIABLES_ADMIN explicitly. SESSION_VARIABLES_ADMIN enables administrators to minimize the privilege ...In ...(For information about dynamic variables, see Section 7.1.9.2, “Dynamic System Variables”.) For certain global system variables, SET can be used to persist their value to the mysqld-auto.cnf file in the data directory, to affect server operation for subsequent ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variable-summary-tables.html
Each status variable summary table has one or more grouping columns to indicate how the table aggregates status values: status_by_account has USER, HOST, and VARIABLE_NAME columns to summarize status variables by account. status_by_user has USER and ... The Performance Schema makes status variable information available in the tables described in Section 29.12.15, “Performance Schema Status Variable ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-group-replication.html
In addition to the mysqlbackup@localhost account created on each host as described in Section 4.1.2, “Grant MySQL Privileges to Backup Administrator”, accounts for the user mysqlbackup to access all hosts in the group have been created on every ...These are sample statements for creating the accounts: CREATE USER 'mysqlbackup'@'host1' IDENTIFIED BY 'password'; CREATE USER 'mysqlbackup'@'host2' IDENTIFIED BY 'password'; CREATE USER 'mysqlbackup'@'host3' IDENTIFIED BY 'password'; ...
https://dev.mysql.com/doc/refman/8.4/en/windows-start-service.html
The command connects as the MySQL root user, which is the default administrative account in the MySQL grant system. Note Users in the MySQL grant system are wholly independent from any operating system users under Windows. Finally, before trying to ... On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and ...
https://dev.mysql.com/doc/refman/8.4/en/default-privileges.html
The mysql.user grant table defines the initial MySQL user account and its access privileges. The 'root'@'localhost' account also has a row in the mysql.proxies_priv table that enables granting the PROXY privilege for ''@'', that is, for all users ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
For example, a GRANT statement, which updates the mysql.user system table but does not mention that table, is not affected by a filter that specifies mysql.% as the wildcard pattern. For example, a GRANT statement, which updates the mysql.user ...If ... This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica Servers System Variables Used on Replica Servers Specify the options either on the command line or in an option ...
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
Web Authentication (WebAuthn) enables user authentication for MySQL Server using devices such as smart cards, security keys, and biometric readers. Create a MySQL User Create the MySQL user to be linked to the FIDO device. Use the mysql client with ...WebAuthn enables passwordless authentication, and can be used for MySQL accounts that use multifactor ...
https://dev.mysql.com/doc/connectors/en/connector-net-simple-membership-tutorial.html
<add name="MyConnection" connectionString="server=localhost; UserId=root; password=pass; database=MySqlSimpleMembership; logging=true;port=3305" providerName="MySql.Data.MySqlClient"/> Under the <system.data> node, add configuration information ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-connection-parameters.html
Table 5.1 Connector/ODBC DSN Configuration Options Parameter GUI Option Default Value Comment user User ODBC The user name used to connect to MySQL. password Password - The password for the user account on server. Example usage: DRIVER={MySQL ODBC ...On Unix and macOS, use the parameter name and value as the keyword/value pair in the DSN ...