Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-user-variable-tables.html
The Performance Schema provides a user_variables_by_thread table that exposes user-defined variables. These are variables defined within a specific session and include a @ character preceding the name; see Section 11.4, “User-Defined Variables”. The user_variables_by_thread table has these columns: THREAD_ID The thread identifier of the session in which the variable is ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-config-editor.html
When you use the set command with mysql_config_editor to create a login path, you need not specify all possible option values (host name, user name, password, port, socket). The file location is the %APPDATA%\MySQL directory on Windows and the ...
https://dev.mysql.com/doc/refman/9.7/en/connecting-using-uri-or-key-value-pairs.html
Parameters specified with key-value pairs use a syntax such as {user:'myuser', host:'example.com', port:3306, schema:'main-schema'}. user: The MySQL user account to provide for the authentication process. For example: ... This section describes use ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-post-install.html
Post-installation setup involves creating a safe directory for import and export operations, configuring server startup options, initializing the data directory, starting MySQL using systemd, resetting the password for the MySQL root@localhost user ...By default, a user who has the FILE privilege can read any file on the server host that is either world-readable or readable by the MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/replication-privilege-checks.html
You can create a user account with the appropriate privileges to apply the transactions that are normally replicated on a channel, and specify this as the PRIVILEGE_CHECKS_USER account for the replication applier, using a CHANGE REPLICATION SOURCE ...MySQL then checks each transaction against the user account's privileges to verify that you have authorized the operation for that ... By default, MySQL replication (including Group Replication) does ...
https://dev.mysql.com/doc/refman/9.7/en/stored-objects-security.html
If a definition omits the DEFINER attribute, the default object definer is the user who creates it. (That is, the statement fails if renaming an account would cause a stored object to become orphaned.) CREATE USER fails with an error if any account ...Additionally, to set a stored object DEFINER attribute to an account that has the SYSTEM_USER privilege, you must have the SYSTEM_USER ... Stored programs (procedures, functions, ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-user.html
This read-only property returns the user name used for connecting to the MySQL server.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-user.html
This read-only property returns the user name used for connecting to the MySQL server.
https://dev.mysql.com/doc/refman/9.7/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/9.7/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 ...