Search Results
https://dev.mysql.com/doc/refman/8.4/en/secure-client-programming.html
Properly used, this prevents application users from entering values that cause the application to generate statements that have a different effect than you intend: MySQL SQL statements: Use SQL prepared statements and accept data values only by ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects-security.html
An existing stored object can become orphaned through execution of a DROP USER statement that drops the object DEFINER account, or a RENAME USER statement that renames the object DEFINER account. (That is, the statement fails if dropping an account ... Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-defining.html
Each stored program contains a body that consists of an SQL statement. This statement may be a compound statement made up of several statements separated by semicolon (;) characters. By default, mysql itself recognizes the semicolon as a statement ...For example, the following stored procedure has a body made up of a BEGIN ...
https://dev.mysql.com/doc/refman/8.4/en/system-variable-privileges.html
To set a global system variable, use a SET statement with the appropriate keyword. These privileges apply: To set a global system variable runtime value, use the SET GLOBAL statement, which requires the SYSTEM_VARIABLES_ADMIN privilege (or the ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password.html
The validate_password component implements these capabilities: For SQL statements that assign a password supplied as a cleartext value, validate_password checks the password against the current password policy and rejects the password if it is weak ... The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-query.html
mysql_real_query() executes the SQL statement pointed to by stmt_str, a string length bytes long. Normally, the string must consist of a single SQL statement without a terminating semicolon (;) or \g. If multiple-statement execution has been ... int ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-store-result.html
After invoking mysql_real_query() or mysql_query(), you must call mysql_store_result() or mysql_use_result() for every statement that successfully produces a result set (SELECT, SHOW, DESCRIBE, EXPLAIN, CHECK TABLE, and so forth). You need not call ... MYSQL_RES * mysql_store_result(MYSQL *mysql) Description Note mysql_store_result() is a synchronous ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-binarylogs-category.html
Binlog Format This variable sets the binary logging format, and can be any one of STATEMENT, ROW, or MIXED. Binlog Stmt Cache Size Determines the size of the cache for the binary log to hold nontransactional statements issued during a transaction.
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-connections-pages-locking.html
Waiting Query Rows Affected The number of rows affected by the statement. Waiting Query Rows Examined The number of rows read from storage engines by the statement. Waiting Query Secs How long the statement has been waiting, in seconds. InnoDB Row ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-locking.html
For any index records the search encounters, it locks the rows and any associated index entries, in the same way as if you issued an UPDATE statement for those rows. If a locking statement executes while a different transaction holds the same lock, ... X DevAPI supports MySQL locking through the lockShared() and lockExclusive() methods for the Collection.find() and Table.select() ...