PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/security-against-attack.html
Alternatively, use SSH to get an encrypted TCP/IP connection between a MySQL server and a MySQL client. The CREATE USER and ALTER USER statements also support resource control options for limiting the extent of server use permitted to an account.
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
This context value may differ from the current ssl_ca system variable value if the system variable has been changed but ALTER INSTANCE RELOAD TLS has not subsequently been executed to reconfigure the SSL context from the context-related system ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-procedure.html
To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a scope that ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-table.html
When altering the storage engine of a table, table options that are not applicable to the new storage engine are retained in the table definition to enable reverting the table with its previously defined options to the original storage engine, if ...
https://dev.mysql.com/doc/refman/8.0/en/show-events.html
Execute At For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT statement used to create the event, or of the last ALTER EVENT statement that modified the event. This value may be updated by ALTER EVENT to ... SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...
https://dev.mysql.com/doc/refman/8.0/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/refman/8.0/en/silent-column-changes.html
In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, to attributes associated with a data type, or to an index specification. All changes are ...
https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html
Prepared Statements in SQL Scripts An alternative SQL interface to prepared statements is available. Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is ...
https://dev.mysql.com/doc/refman/8.0/en/statement-caching.html
Metadata changes occur for DDL statements such as those that create, drop, alter, rename, or truncate tables, or that analyze, optimize, or repair tables. If the set of columns in the table is modified with ALTER TABLE, the prepared statement goes ... For certain statements that a client might execute multiple times during a session, the server converts the statement to an internal structure and caches that structure to be used during ...
https://dev.mysql.com/doc/refman/8.0/en/stored-objects-security.html
To redefine an object with a different definer, you can use ALTER EVENT or ALTER VIEW to directly modify the DEFINER account of events and views. Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, ...