Search Results
https://dev.mysql.com/doc/refman/9.7/en/password-security-user.html
Passwords can be written as plain text in SQL statements such as CREATE USER and ALTER USER, so if you use these statements, they are logged in the history file. MySQL users should use the following guidelines to keep passwords secure. When you run ...The methods you can use to specify your password when you run client programs are listed here, along with an assessment of the risks of each ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-user-group-management.html
User and Group Management 20 User and Group Management MySQL HeatWave on AWS uses predefined OCI IAM groups and policies to manage access to the MySQL HeatWave Console. Predefined groups and policies are created when the service is provisioned. An ...Defining your own groups and policies for MySQL HeatWave on AWS is currently not ...
https://dev.mysql.com/doc/internals/en/user-level-locks.html
User-level locks are controlled with the SQL functions GET_LOCK(str,timeout) IS_FREE_LOCK(str) IS_USED_LOCK(str) RELEASE_LOCK(str) They can be used at places where SQL statements accept SQL functions. Nevertheless, a couple of synchronization ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utils-copy.html
Setting it to true drops existing user accounts and objects before creating them. skip_invalid_accounts Remove user accounts created with external authentication plugins that are not supported in MySQL HeatWave Service. This option also removes user ...The minimum required set of privileges that the user account used to run the utility must have on all the schemas involved is as follows: EVENT, RELOAD, SELECT, SHOW VIEW, and ... This section describes the MySQL Shell copy utilities: About the Utilities Requirements and Restrictions Running the Utilities Options for ...
https://dev.mysql.com/doc/refman/9.7/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/ndbapi/en/mgm-functions-single-user-mode.html
The MGM API makes it possible for the programmer to put the cluster into single-user mode—and to return it to normal mode again—from within an application. ndb_mgm_enter_single_user() ndb_mgm_exit_single_user() ndb_mgm_enter_single_user() ...
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-reserved-user-names.html
Reserved User Names 3.1.2.10 Reserved User Names The following user names are reserved and cannot be used for the MySQL Administrator user name: administrator ociadmin ocimonitor ocirpl mysql.sys mysql.session mysql.infoschema Parent topic: MySQL ...
https://dev.mysql.com/doc/mysql-router/9.7/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/internals/en/innodb-user-records.html
In the User Records part of a page, you'll find all the records that the user inserted. There are two ways to navigate through the user records, depending whether you want to think of their organization as an unordered or an ordered list. If you ...
https://dev.mysql.com/doc/refman/9.7/en/example-user-variables.html
You can employ MySQL user variables to remember results without having to store them in temporary variables in the client.