PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/macos-installation-pkg.html
The package is located inside a disk image (.dmg) file that you first need to mount by double-clicking its icon in the Finder. To install MySQL using the package installer: Download the disk image (.dmg) file (the community version is available ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
To modify an account that uses passwordless authentication, you must have the PASSWORDLESS_USER_ADMIN privilege. If the IF EXISTS clause is given, the statement produces a warning for each named user that does not exist, rather than an error. It ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connections.html
Encryption algorithms must include security elements to resist many kinds of known attacks such as changing the order of encrypted messages or replaying data twice. With an unencrypted connection between the MySQL client and the server, someone ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). The disadvantage of this is that you must ensure that your statements always refer to your database and ... In MySQL, databases correspond to directories within the data ...One notable exception is macOS, which is Unix-based ...
https://dev.mysql.com/doc/refman/8.0/en/diagnostics-area.html
If a statement or condition item is not set by a statement that populates the diagnostics area, its value is 0 or the empty string, depending on the item data type. MESSAGE_TEXT: A string that indicates the error message for the condition. SQL ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-server-clients.html
Start the client with --protocol=TCP to connect using TCP/IP, --protocol=SOCKET to connect using a Unix socket file, --protocol=PIPE to connect using a named pipe, or --protocol=MEMORY to connect using shared memory. For the other types of ...For ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-routines-table.html
ROUTINE_SCHEMA The name of the schema (database) to which the routine belongs. DATA_TYPE If the routine is a stored function, the return value data type. The DATA_TYPE value is the type name only with no other information. DTD_IDENTIFIER If the ...
https://dev.mysql.com/doc/refman/8.0/en/windows-pluggable-authentication.html
The file must be located in the directory named by the plugin_dir system variable. To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). The client ... Note Windows pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-configuration.html
You can also set a location for the backup files using the BackupDataDir configuration parameter. Five configuration parameters are essential for backup: BackupDataBufferSize The amount of memory used to buffer data before it is written to disk.
https://dev.mysql.com/doc/refman/8.0/en/replace.html
To use REPLACE, you must have both the INSERT and DELETE privileges for the table. As with INSERT, if it is not possible to insert the new row into any of these partitions or subpartitions, the REPLACE statement fails with the error Found a row not ...REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new row is ...