PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/drop-procedure.html
(DROP FUNCTION is also used to drop loadable functions; see Section 13.7.3.2, “DROP FUNCTION Statement for Loadable Functions”.) To drop a stored routine, you must have the ALTER ROUTINE privilege for it. DROP {PROCEDURE | FUNCTION} [IF EXISTS] ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html
Before You Start As a popular, open-source software, MySQL, in its original or re-packaged form, is widely installed on many systems from various sources, including different software download sites, software repositories, and so on. Steps for a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-change-path-proc.html
After you have installed the server, the paths cannot be altered without removing and reinstalling the server instance. Click Advanced Options to open a dialog box where you can enter alternative path names. You can change the default installation ...
https://dev.mysql.com/doc/refman/5.7/en/password-security-user.html
However, this method of entering a password is suitable only for programs that you run interactively. Passwords can be written as plain text in SQL statements such as CREATE USER and ALTER USER, so if you use these statements, they are logged in the ... MySQL users should use the following guidelines to keep passwords ...
https://dev.mysql.com/doc/refman/5.7/en/preface.html
Conversion to other formats is allowed as long as the actual content is not altered or edited in any way. This is the Reference Manual for the MySQL Database System, version 5.7, through release 5.7.44. Differences between minor versions of MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-encrypted-connections.html
You must obtain (or create) a suitable security certificate that you can use on the source, and a similar certificate (from the same certificate authority) on each replica. After the source information has been updated, start the replication process ... To use an encrypted connection for the transfer of the binary log required during replication, both the source and the replica servers must support encrypted network ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterbaseconfig.html
To configure a source to use binary log file position based replication, you must ensure that binary logging is enabled, and establish a unique server ID. If these options already exist, but are commented out, uncomment the options and alter them ...Each server within a replication topology must be configured with a unique server ID, which you can specify using the server_id system ...
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
These system variables on the server side specify the certificate and key files the server uses when permitting clients to establish encrypted connections: ssl_ca: The path name of the Certificate Authority (CA) certificate file. Alternatively, if ... Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-choosing-id.html
The collation ID that you choose appears in these contexts: The ID column of the Information Schema COLLATIONS table. To add a collation, you must choose an ID value that is not currently used. The range of IDs from 1024 to 2047 is reserved for ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-simple-8bit.html
</charset> In the latin1.xml configuration file, add a <collation> element that names the collation and that contains a <map> element that defines a character code-to-weight mapping table for character codes 0 to 255. This section describes how to ...