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/view-restrictions.html
If a user is granted the basic privileges necessary to create a view (the CREATE VIEW and SELECT privileges), that user cannot call SHOW CREATE VIEW on that object unless the user is also granted the SHOW VIEW privilege. The workaround to the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-metadata-locks-table.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 12.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/5.7/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/refman/5.7/en/windows-postinstallation.html
If necessary, initialize the data directory and create the MySQL grant tables. If you install MySQL using MySQL Installer, the root user is created automatically with the password you supplied. GUI tools exist that perform most of the tasks ...
https://dev.mysql.com/doc/refman/5.7/en/privilege-changes.html
If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup sequence. If you modify the grant tables indirectly using an account-management statement, the server notices ...The in-memory tables become effective for access control at that ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation.html
The following sections describe how to add user-defined collations of the first two types to existing character sets. Summary of the procedure for adding a new user-defined collation: Choose a collation ID. The instructions here cover only ... A ...
https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/5.7/en/change-master-to.html
(Bug #11758581, Bug #50801) MASTER_USER and MASTER_PASSWORD are the user name and password of the account to use for connecting to the source. The password used for a replication user account in a CHANGE MASTER TO statement is limited to 32 ...] ...
https://dev.mysql.com/doc/refman/5.7/en/create-temporary-table.html
One implication of this behavior is that a session can manipulate its temporary tables even if the current user has no privilege to create them. Suppose that the current user does not have the CREATE TEMPORARY TABLES privilege but is able to execute ... You can use the TEMPORARY keyword when creating a ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-binary-package.html
For example: mysqladmin -u root -p shutdown mysqld_safe --user=mysql --datadir=/path/to/existing-datadir Logical Downgrade Logical downgrade involves using mysqldump to dump all tables from the new MySQL version, and then loading the dump file into ... This section describes how to downgrade MySQL binary and package-based installations on ...