Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-install-agent-gui-ref.html
If you install as an unprivileged user, you must start the agent yourself after each reboot. Note Although MySQL Enterprise Monitor Agent is installed as the root user, directories and files that the Agent writes to are owned by the mysql user in ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-config-editor.html
The file location is the %APPDATA%\MySQL directory on Windows and the current user's home directory on non-Windows systems. Each option group in .mylogin.cnf is called a “login path,” which is a group that permits only certain options: host, ...
https://dev.mysql.com/doc/refman/8.4/en/option-defaults-equals.html
Consider the following example, where a user connects to a MySQL server running on host tonfisk as user jon: $> mysql --host 85.224.35.45 --user jon Welcome to the MySQL monitor. Suppose the my.cnf file is as shown here: [mysql] user jon Trying to ...Due to this behavior, problems can occasionally arise when no value is provided for an option that expects ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-options-variables.html
This applies only when changing an existing password, and has no effect when setting a user account's initial password. If the ALTER USER statement does not provide the existing password in a REPLACE clause, this variable is not enforced. This ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-user-attributes-table.html
The USER_ATTRIBUTES table provides information about user comments and user attributes. The USER_ATTRIBUTES table has these columns: USER The user name portion of the account to which the ATTRIBUTE column value applies. ATTRIBUTE The user comment, ...HOST The host name portion of the account to which the ATTRIBUTE column value ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mysql-process-discovery-advisor-ref.html
Important If you disable this advisor, notifications for unmonitored instances, and the associated events, are not displayed in the user interface. Admin User The root user of the instance, or a user that has the SUPER, CREATE, and INSERT privileges ... The MySQL Process Discovery Advisor enables you to find and, optionally, establish a connection with unmonitored MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects-security.html
Administrators can prevent users from creating stored objects that specify highly privileged DEFINER accounts by not granting them the SET_ANY_DEFINER privilege. In some cases, you can prevent references to these objects by not granting unauthorized ...If a definition omits the DEFINER attribute, the default object definer is the user who creates ... Stored programs (procedures, functions, triggers, and events) and views are defined ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-post-install.html
To initialize the data directory: Change location to the top-level directory of the MySQL installation, create the data directory, and grant ownership to the mysql user. Post-installation setup involves creating a safe directory for import and ...
https://dev.mysql.com/doc/refman/8.4/en/rename-user.html
RENAME USER old_user TO new_user [, old_user TO new_user] ... To use RENAME USER, you must have the global CREATE USER privilege, or the UPDATE privilege for the mysql system schema. When the read_only system variable is enabled, RENAME USER ...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 ...