Search Results
https://dev.mysql.com/doc/refman/8.4/en/error-log-destination-configuration.html
(--console takes precedence over --log-error if both are given, and the following items regarding --log-error do not apply.) If --log-error is not given, or is given without naming a file, the default destination is a file named host_name.err in the ... This section describes which server options configure the default error log destination, which can be the console or a named ...
https://dev.mysql.com/doc/refman/8.4/en/events-overview.html
A recurrent event repeats its action at a regular interval, and the schedule for a recurring event can be assigned a specific start day and time, end day and time, both, or neither. MySQL Events are tasks that run according to a schedule. When you ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
In both cases, this column holds one of the values 'Y' or 'N'. To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system variable. The EVENT privilege governs the creation, ...
https://dev.mysql.com/doc/refman/8.4/en/expired-password-handling.html
Which action is taken by the server depends on both client and server settings, as discussed later. MySQL provides password-expiration capability, which enables database administrators to require that users reset their password. Passwords can be ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
To fix this disparity between column lengths, use ALTER TABLE to lengthen ActualPC from 10 characters to 15 characters: mysql> ALTER TABLE tt MODIFY ActualPC VARCHAR(15); Now tt.ActualPC and et.EMPLOYID are both VARCHAR(15). The EXPLAIN statement ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
For example, all string functions support both standard SQL syntax and ODBC syntax. MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if you use them, your code is most likely not portable to ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-information-schema.html
What is the difference between the Oracle Data Dictionary and MySQL INFORMATION_SCHEMA? Both Oracle and MySQL provide metadata in tables. Where can I find documentation for the MySQL INFORMATION_SCHEMA database? A.7.2. Where can I find the ANSI SQL ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-security.html
Is SSL support built into MySQL binaries, or must I recompile the binary myself to enable it? Yes, the binaries have SSL enabled for client/server connections that are secured, authenticated, or both. Where can I find documentation that addresses ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
Are stored procedures and functions created on a replication source server replicated to a replica? Yes, creation of stored procedures and functions carried out through normal DDL statements on a replication source server are replicated to a ...
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL server. The remote table that a FEDERATED table points to must exist before you try to access the table through the ...