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/mysql-monitor/8.0/en/mem-created-users.html
The Repository user: This user is the only user in the user table in the mysql database in the bundled MySQL server. The repository user can log in from localhost using the password specified during installation and has all privileges on all ...To ...
https://dev.mysql.com/doc/refman/8.4/en/password-security-user.html
MySQL users should use the following guidelines to keep passwords secure. When you run a client program to connect to the MySQL server, it is inadvisable to specify your password in a way that exposes it to discovery by other users. On some ...The ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-cloning.html
As a minimum, you must install the clone plugin on the donor and joining member, grant the BACKUP_ADMIN permission to the replication user for distributed recovery, and set the group_replication_clone_threshold system variable to an appropriate ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
The exception is if the activate_all_roles_on_login system variable is enabled, in which case MySQL Server sets all roles granted to the DEFINER user, including mandatory roles. If the DEFINER clause is present, the privileges required depend on the ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(WL #16055) The SET_USER_ID privilege, deprecated in MySQL 8.2.0, has been removed in this release, and its use in GRANT statements now causes a syntax error. When upgrading from a previous releases, users already having the SYSTEM_USER privilege ...
https://dev.mysql.com/doc/refman/8.4/en/data-directory-initialization.html
These include statements that relate to account management (such as CREATE USER or GRANT), replication, and global transaction identifiers. Data Directory Initialization Overview Data Directory Initialization Procedure Server Actions During Data ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security-mysql-privileges.html
Once a MySQL user is granted privileges on an NDB table from one SQL node in an NDB Cluster, that user can “see” any data in that table regardless of the SQL node from which the data originated, even if that user is not shared. This includes all ... In this section, we discuss how the MySQL privilege system works in relation to NDB Cluster and the implications of this for keeping an NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/mysqladmin.html
If you are using the Rewriter plugin, grant this user the SKIP_QUERY_REWRITE privilege. To kill threads belonging to other users, the connected user must have the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege). On some systems, your ...You can use it to check the server's configuration and current status, to create and drop databases, and ...
https://dev.mysql.com/doc/x-devapi-userguide/en/database-connection-example.html
You pass in the connection parameters to connect to the MySQL server, such as the hostname and user, very much like the code in one of the classic APIs. The connection parameters can be specified as either a URI type string, for example ... The code ...