Search Results
https://dev.mysql.com/doc/refman/8.4/en/password-security-admin.html
MySQL stores passwords for user accounts in the mysql.user system table. Access to this table should never be granted to any nonadministrative accounts. Account passwords can be expired so that users must reset them. A user who has access to modify ... Database administrators should use the following guidelines to keep passwords ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover.html
The same replication user account and password must exist on all the source servers in the source list for the channel. In this situation, the replication channel and the replication user account and password for the channel must be set up on all ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
A GTID is also assigned to the creation, alteration, or deletion of a database, and of a non-table database object such as a procedure, function, trigger, event, view, user, role, or grant. Temporary tables are dropped automatically when a replica ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...
https://dev.mysql.com/doc/refman/8.4/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore-use-tts.html
The following is some additional information on partial restores using TTS backups To backup and restore backups created using TTS, extra privileges are required of the user through which mysqlbackup connects to the server; see Section 4.1.2, ...
https://dev.mysql.com/doc/refman/8.4/en/security.html
These include choosing good passwords, not granting unnecessary privileges to users, ensuring application security by preventing SQL injections and data corruption, and others. Access control and security within the database system itself, including ... When thinking about security within a MySQL installation, you should consider a wide range of possible topics and how they affect the security of your MySQL server and related applications: General factors that affect ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-history-table-update.html
Note If you are working with a multiprimary Group Replication setting, make sure these privileges are granted on all primary nodes; see also Chapter 9, Using MySQL Enterprise Backup with Group Replication. Rename the original mysql.backup_history ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-locks-per-fragment.html
The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and memory_per_fragment. This table also ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-privileges.html
mysql> GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges.
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-ndbcluster-permissions.html
This section describes the following permissions: MySQL NDB Cluster API Nodes (Non-SQL): grants access to monitored MySQL NDB Cluster API Nodes. Read-only grants permission to view details of the nodes and view events generated for the nodes.