PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication.html
Because this is insecure, you might want to use --skip-grant-tables in conjunction with enabling the skip_networking system variable to prevent remote clients from connecting. This plugin is used in conjunction with server-side plugins that require ... When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the appropriate account row from the mysql.user system ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-catalog-dashboard.html
If you are using a Commercial release of MySQL Installer, the icon opens the MySQL Installer Commercial License Information User Manual for licensing information, including licensing information relating to third-party software that may be included ... This section describes the MySQL Installer product catalog, the dashboard, and other actions related to product selection and ...Product Catalog MySQL Installer Dashboard Locating Products to Install Upgrading MySQL Server Removing MySQL Server Upgrading MySQL Installer Product Catalog The product ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
If the routine is a stored procedure, this value is empty. If the routine is a stored procedure, this value is NULL. If the routine is a stored procedure, this value is NULL. If the routine is a stored procedure, this value is NULL. If the routine ... The ROUTINES table provides information about stored routines (stored procedures and stored ...
https://dev.mysql.com/doc/refman/5.7/en/ndb-restore-different-number-nodes.html
See Section 21.6.8.2, “Using The NDB Cluster Management Client to Create a Backup”, for information about how to do this. For the rest of this example, we assume that the backup ID is 1. It is simplest to copy them all to a single location; we ... It is possible to restore from an NDB backup to a cluster having a different number of data nodes than the original from which the backup was ...
https://dev.mysql.com/doc/refman/5.7/en/column-indexes.html
Indexing only a prefix of column values in this way can make the index file much smaller. Take this into account when specifying a prefix length for a nonbinary string column that uses a multibyte character set. If a search term exceeds the index ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
MySQL uses the default collation for this character set (utf8_general_ci) for all searches, sorts, comparisons, and other string operations on such columns. Other terms that are sometimes used for this information are data dictionary and system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
To support proximity search, position information for each word is also stored, as a byte offset. The number of threads that perform this work is configurable using the innodb_ft_sort_pll_degree variable. The index defined on the opening_lines table ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html
This means that if you issue several plain (nonlocking) SELECT statements within the same transaction, these SELECT statements are consistent also with respect to each other. For locking reads (SELECT with FOR UPDATE or LOCK IN SHARE MODE), UPDATE, ... Transaction isolation is one of the foundations of database ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-service.html
To do this, use the --install-manual option rather than the --install option: C:\> "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld" --install-manual Removing the service To remove a server that is installed as a service, first stop it if it is ...This command invokes the MySQL administrative utility mysqladmin to connect to the server and tell it to shut ... On Windows, the recommended way to run MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
This is an example of a minimal CREATE EVENT statement: CREATE EVENT myevent ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO UPDATE myschema.mytable SET mycol = mycol + 1; The previous statement creates an event named myevent. This event ...