Search Results
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/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/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/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/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 ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/ui-security-advisor-ref.html
Strong MySQL Privilege User Exclusion Regex: This advisor enables you to define a regular expression describing the users allowed to have global privileges on the mysql.user table (CREATE_USER, FILE, GRANT, PROCESS, LOCK_TABLES, SHUTDOWN, SUPER or ... This section describes the following Security advisors: MySQL Enterprise Audit Plugin MySQL Enterprise Firewall MySQL User Account MySQL Enterprise Audit Plugin Note For more information on the MySQL Enterprise Audit Plugin, see MySQL Enterprise ...
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 ...