Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-single-user-mode.html
Single user mode enables the database administrator to restrict access to the database system to a single API node, such as a MySQL server (SQL node) or an instance of ndb_restore. When entering single user mode, connections to all other API nodes ...You can also check the status column of the ndbinfo.nodes table (see Section 25.6.15.48, “The ndbinfo nodes Table”, for more ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/security-advisors-ref.html
However, in order to allow backward-compatibility with user tables that have been migrated from pre-4.1 systems, you can configure MySQL to accept logins for accounts that have password hashes created using the old, less-secure PASSWORD() function, ...If a user is configured to use an authentication plug-in, and that plug-in does not get loaded with server start, this blocks access to the database for those ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-conf-options.html
On Linux, installing Router with official DEB or RPM packages creates a local system user and group named "mysqlrouter" on the host, and MySQL Router runs as this user by default. For example: $> sudo mysqlrouter --bootstrap localhost:3310 ...For ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-default-users-roles.html
Default Users The following default users are created when MySQL Enterprise Service Manager is first installed and setup: Agent user: defines the username and password used by all agents to connect to MySQL Enterprise Service Manager. The Manager ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-users-table.html
The users table contains a row for each user who has connected to the MySQL server. For each user name, the table counts the current and total number of connections. To set the table size explicitly, set the performance_schema_users_size system ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-load-dump.html
Setting it to true drops existing user accounts and objects before creating them. If the GIPK server option, sql_generate_invisible_primary_key is enabled and the MySQL Shell load utility option createInvisiblePKs is disabled, and the user does not ...Ensure the dump was created with the ocimds option set to true in MySQL Shell's instance dump utility or schema dump utility, for compatibility with MySQL HeatWave ... MySQL Shell's dump loading utility util.loadDump() supports the import into a MySQL HeatWave Service DB ...
https://dev.mysql.com/doc/refman/8.4/en/rename-user.html
To use RENAME USER, you must have the global CREATE USER privilege, or the UPDATE privilege for the mysql system schema. However, RENAME USER does not automatically drop or invalidate databases or objects within them that the old user created. An ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-agent-user-password.html
Normally it is not necessary to alter the user name or password used by the user agent to administer mysqld processes. Set a new password by uncommenting the line containing mcmd_password= and adding the new password as its value; set a new ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
This function can be used for the default value of a VARCHAR or TEXT column, as shown in the following CREATE TABLE statement: CREATE TABLE t (c VARCHAR(288) DEFAULT (CURRENT_USER())); DATABASE() Returns the default (current) database name as a ...
https://dev.mysql.com/doc/refman/8.4/en/partial-revokes.html
Using Partial Revokes Partial Revokes Versus Explicit Schema Grants Disabling Partial Revokes Partial Revokes and Replication Note For brevity, CREATE USER statements shown here do not include passwords. Specifically, for users who have privileges ... It is possible to grant privileges that apply globally if the partial_revokes system variable is ...