Search Results
https://dev.mysql.com/doc/connectors/en/connector-net-authentication.html
For example, with GSSAPI you can set the ticket-granting ticket (TGT) expiry time, key distribution center (KDC) port, and so on. Pluggable authentication enables the server to determine which plugin applies, based on the user name and host name ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
Have a tee file enabled and pager set to less, and you are able to browse the results using the less program and still have everything appended into a file the same time. There is also a set of commands that mysql itself interprets. For a list of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-gtids.html
A SET @@GLOBAL.gtid_purged statement was issued on MySQL 5.7.7 or earlier, and the binary log that was active at the time of the SET @@GLOBAL.gtid_purged statement has not yet been purged. gtid_executed_compression_period Command-Line Format ... The ...For additional information, see Section 19.1.3, “Replication with Global Transaction ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
Reloading the grant tables is necessary to enable updates to MySQL privileges and users only if you make such changes directly to the grant tables; it is not needed for account management statements such as GRANT or REVOKE, which take effect ...Note ...| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | table_synonym tbl_name [, tbl_name] ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-yum-repo.html
For example, to install from the MySQL innovation track, make sure you have enabled=0 for the MySQL 8.4 subrepository entries and have enabled=1 for the innovation entries: [mysql80-community] name=MySQL 8.0 Community Server ...Before You Start As a ...The following instructions assume that MySQL is not already installed on your system using a third-party-distributed RPM package; if that is not the case, follow the instructions given at Replacing a Native Third-Party Distribution of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
(The menu item mentioned previously sets the font and character set as just described.) To avoid those steps each time you run mysql, you can create a shortcut that invokes mysql.exe. row *************************** msg_nro: 3068 date: 2000-03-01 ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
Referential Actions When an UPDATE or DELETE operation affects a key value in the parent table that has matching rows in the child table, the result depends on the referential action specified by ON UPDATE and ON DELETE subclauses of the FOREIGN KEY ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...If ...
https://dev.mysql.com/doc/refman/8.4/en/select.html
(If you attempt to do so, the statement is rejected with the error Can't update table 'old_table' while 'new_table' is being created.) FOR SHARE and LOCK IN SHARE MODE set shared locks that permit other transactions to read the examined rows but not ...[WITH ROLLUP]] [LIMIT {[offset,] row_count | row_count OFFSET offset}] [into_option] [FOR {UPDATE | SHARE} [OF tbl_name [, tbl_name] ...] [NOWAIT | SKIP LOCKED] | LOCK IN SHARE MODE] [into_option] into_option: { INTO OUTFILE 'file_name' [CHARACTER SET charset_name] export_options | INTO DUMPFILE 'file_name' | INTO var_name [, var_name] ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-types.html
The plugin API enables creation of plugins that implement several capabilities: Loadable functions (UDFs) Storage engines Full-text parsers Daemons INFORMATION_SCHEMA tables Semisynchronous replication Auditing Authentication Password validation ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
You can set DATE, TIME, DATETIME, and TIMESTAMP as optional column-level parameters. EXTERNAL_FORMAT {'date_format' | 'time_format' | 'timestamp_format'} The following example sets the date_format, time_format, and timestamp_format at the column ...