Search Results
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/refman/8.4/en/account-activity-auditing.html
Specifically, do not permit User to be empty (which creates an anonymous-user account), and do not permit pattern characters or netmask notation in Host values. The User and Host column values in this row uniquely identify the account and correspond ... Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-user-attributes-table.html
Attributes are shown exactly as set using CREATE USER and ALTER USER statements with ATTRIBUTE or COMMENT options. For additional information and examples, see CREATE USER Comment and Attribute Options. The currently authenticated account has the ...
https://dev.mysql.com/doc/refman/8.4/en/problems-connecting.html
(The data directory normally is named data or var and is located under your MySQL installation directory.) Make sure that you have a file named user.MYD in the mysql database directory. $> mysql -u root ERROR 1045 (28000): Access denied for user ...
https://dev.mysql.com/doc/refman/8.4/en/security-against-attack.html
This is extremely dangerous, because any user with the FILE privilege is able to cause the server to create files as root (for example, ~root/.bashrc). The CREATE USER and ALTER USER statements also support resource control options for limiting the ...It is common for client/server applications that the user can specify any user name to the client ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-existing-users.html
The MySQL user: For Agents to report the status of a MySQL server, they connect to a MySQL user with privileges to read required data on that server: SHOW DATABASES, REPLICATION CLIENT, SUPER, CREATE, and SELECT. For details about this account, see ...If you already have such a user on a MySQL server, specify its credentials when installing the Agent for that ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-workflow-server.html
It can optionally create MySQL server user accounts with configurable permissions based on general roles, such as DB Administrator, DB Designer, and Backup Admin. MySQL User Accounts (Optional) Click Add User or Edit User to create or modify MySQL ...Note Full permissions are granted to the user executing MySQL Configurator to all generated files, such as ... MySQL Configurator ...
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/refman/8.4/en/mysql-configurator-cli.html
MySQL User Management The configure and reconfigure actions allow you to create and edit MySQL users as per the --add-user option: --add-user='user_name':'password'|'file_path'|'windows_security_token':host:role:authentication Only valid for the ...