Search Results
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
Warning This option creates a MySQL root user with an empty password, which is insecure. --safe-user-create Command-Line Format --safe-user-create[={OFF|ON}] Deprecated Yes Type Boolean Default Value OFF If this option is enabled, a user cannot ...
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/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/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/revoke.html
To use these REVOKE statements, you must have the global CREATE USER privilege, or the UPDATE privilege for the mysql system schema. [IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], GRANT OPTION FROM user_or_role [, user_or_role] ... When ...
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/mysql-enterprise-backup/8.4/en/mysqlbackup-os-user.html
Note For Linux and other Unix-like platforms, the mysql user was typically created using the -r and -s /bin/false options of the useradd command, so that it does not have login permissions to your server host (see Creating the mysql User and Group ...To ensure no file permission issues prevent a server to be backed up, restored, and restarted successfully, it is highly recommended that you run mysqlbackup with the same OS user who runs the MySQL server (typically ...
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 ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-user-configurable-system-variables.html
User-Configurable System Variables 19.5 User-Configurable System Variables Configure the following global system variables with the MySQL HeatWave Console. skip_name_resolve OFF sort_buffer_size 262144 sql_mode ERROR_FOR_DIVISION_BY_ZERO, ...