Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-dsn.html
A User DSN is specific to an individual user, and can be used to store database connectivity information that the user regularly uses. File DSNs can be shared between users and machines and are therefore more practical when installing or deploying ... A Data Source Name associates the configuration parameters for communicating with a specific ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-legacy-filtering.html
Example: To enable audit logging only for the user1 and user2 local host accounts, set the audit_log_include_accounts system variable like this: SET GLOBAL audit_log_include_accounts = 'user1@localhost,user2@localhost'; Only one of ...The value for ...For example, to log all statement events but only failed connection events, use these settings: SET GLOBAL audit_log_statement_policy = ALL; SET GLOBAL audit_log_connection_policy = ERRORS; Another policy system variable, audit_log_policy, is available but does not afford as much control as audit_log_connection_policy and ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/partial.html
The contents of the database directory for test database are shown below. $ mysqlbackup --defaults-file=/home/dbadmin/my.cnf --include="^test\.ib.*" backup # Contents in the backup directory's subdirectory for the test database: $ ls ... By default, ...This section explains options you can use to selectively back up or exclude ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/deploy-sandbox-instances.html
Important Each sandbox instance uses the root user and password, and it must be the same on all sandbox instances which should work together. For example, to use a sandbox in the /home/user/sandbox1 directory, issue: mysql-js> ...The following ...To ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-import.html
--output-workers=# Command-Line Format --output-workers=# Type Integer Default Value 2 Minimum Value 1 Maximum Value 4294967295 Set the number of threads processing output or relaying database operations. --resume Command-Line Format --resume If a ...--ai-offset=# Command-Line Format --ai-offset=# Type Integer Default Value 1 Minimum Value 1 Maximum Value 4294967295 For a table with hidden primary key, specify the autoincrement ...
https://dev.mysql.com/doc/refman/8.4/en/processlist-access.html
The sys schema session view presents information about user sessions like the sys schema processlist view, but with background processes filtered out. Privileges Required to Access the Process List For most sources of process information, if you ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/configuring-replicaset-instances.html
For example, issue: mysql-js> dba.configureReplicaSetInstance('', {clusterAdmin: "'rsadmin'@'rs-1%'"}); The interactive prompt requests the password required by the specified user, this checks the instance which MySQL Shell is currently connected to ...Important The administrator account must have the same user name and password across all instances of the same cluster or replica ...MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/testing-server.html
For example: $> bin/mysqld_safe --user=mysql & If mysqld_safe fails, see Section 2.9.2.1, “Troubleshooting Problems Starting the MySQL Server”. If you have assigned a password for the root account already, you'll also need to specify -p on the ... After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works ...This section assumes that ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-session-track-get-first.html
To control which notifications the server provides about state changes, client applications set system variables having names of the form session_track_xxx, such as session_track_state_change, session_track_schema, and session_track_system_variables. By default, notification is enabled for these session system variables: autocommit character_set_client character_set_connection character_set_results time_zone To change the default notification for this tracker type, set the session_track_schema system variable to a list of comma-separated variables for which to track changes, or * to track changes for all ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-status.html
Some operations during the InnoDB ClusterSet deployment process require permissions, and the default user account stored in the object is used for this, so that the process does not need to store any other user accounts. For more information, see ...