PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
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/password-management.html
Password Expiration Policy To expire an account password manually, use the ALTER USER statement: ALTER USER 'jeffrey'@'localhost' PASSWORD EXPIRE; This operation marks the password expired in the corresponding mysql.user system table row. MySQL ...
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/create-table.html
This works regardless of whether there is a default database, assuming that the database exists. Indexing only a prefix of column values like this can make the index file much smaller. You can work around this restriction by creating an index on a ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-getting-started.html
Downloading the server image in a separate step is not strictly necessary; however, performing this step before you create your Docker container ensures your local image is up to date. To download the MySQL Community Edition image, run this command: ... Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-being-deleted-table.html
This value is used when you do text searches, to skip rows in the INNODB_FT_INDEX_TABLE table before data for deleted rows is physically removed from the FULLTEXT index by an OPTIMIZE TABLE statement. Because the contents of INNODB_FT_BEING_DELETED ... The INNODB_FT_BEING_DELETED table provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
Slave_rows_last_search_algorithm_used The search algorithm that was most recently used by this replica to locate rows for row-based replication. Connection_errors_peer_address The number of errors that occurred while searching for connecting client ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/5.7/en/MySQLInstallerConsole.html
This reference includes: MySQL Product Names Command Syntax Command Actions The console is installed when MySQL Installer is initially executed and then available within the MySQL Installer for Windows directory. If the * character is detected at ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-failover.html
This means that the ndb_apply_status table contains information for the replica on this host as well as for any other host which acts as a replica of the replication source server running on this host. In this case, you need to determine the latest ... In the event that the primary Cluster replication process fails, it is possible to switch over to the secondary replication ...