Search Results
https://dev.mysql.com/doc/refman/9.7/en/blob.html
For security and other reasons, it is usually preferable to do so using application code rather than giving application users the FILE privilege. A BLOB is a binary large object that can hold a variable amount of data. These differ only in the ...
https://dev.mysql.com/doc/refman/9.7/en/charset-collation-coercibility.html
A “system constant” (the string returned by functions such as USER() or VERSION()) has a coercibility of 3. In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison operation. For example, in the ...
https://dev.mysql.com/doc/refman/9.7/en/common-errors.html
This section lists some errors that users frequently encounter when running MySQL programs. Although the problems show up when you try to run client programs, the solutions to many of the problems involves changing the configuration of the MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/communication-errors.html
If the log_error_verbosity system variable is set to 3, you might find messages like this in your error log: [Note] Aborted connection 854 to db: 'employees' user: 'josh' If a client is unable even to connect, the server increments the ... If ...
https://dev.mysql.com/doc/refman/9.7/en/compatibility.html
We are not afraid to add extensions to SQL or support for non-SQL features if this greatly increases the usability of MySQL Server for a large segment of our user base. This section describes how MySQL relates to the ANSI/ISO SQL standards. MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/connection-control-component.html
This capability provides a deterrent that slows down brute force attacks against MySQL user accounts. The Connection Control component for MySQL (component_connection_control) makes it possible to introduce an increasing delay in the MySQL server's ...
https://dev.mysql.com/doc/refman/9.7/en/connection-control-information-schema-tables.html
Note The Connection Control plugin is deprecated; users are encouraged to migrate to the Connection Control component. The following sections describe the INFORMATION_SCHEMA tables associated with the connection_control plugin.
https://dev.mysql.com/doc/refman/9.7/en/connection-control-plugin.html
This capability provides a deterrent that slows down brute force attacks against MySQL user accounts. To collect information, it subscribes to the MYSQL_AUDIT_CONNECTION_CLASSMASK event class, and processes MYSQL_AUDIT_CONNECTION_CONNECT and ...
https://dev.mysql.com/doc/refman/9.7/en/controlling-optimizer.html
Like other data dictionary tables, this table is not directly accessible by users. MySQL provides optimizer control through system variables that affect how query plans are evaluated, switchable optimizations, optimizer and index hints, and the ...
https://dev.mysql.com/doc/refman/9.7/en/controlling-query-plan-evaluation.html
A more flexible method for query optimization enables the user to control how exhaustive the optimizer is in its search for an optimal query evaluation plan. The task of the query optimizer is to find an optimal plan for executing an SQL query.