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/copying-databases.html
You might have to run commands as the MySQL root user on the new machine until you have the mysql database in place. After you import the mysql database on the new machine, execute mysqladmin flush-privileges so that the server reloads the grant ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
If you have no indexes suitable for your statement and MySQL must scan the entire table to process the statement, every row of the table becomes locked, which in turn blocks all inserts by other users to the table. When session 1 rolls back, it ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-standard-monitor.html
The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for periodic output turns on the same output stream, but the stream includes extra information if the Lock Monitor is ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-server-locks.html
This may be useful for correlating locking patterns with specific MySQL user sessions, queries, or use cases. This is reset to 0 when a lock is granted for a waiting request. If the lock_state column's value is W, this lock is waiting to be granted, ... The server_locks table is similar in structure to the cluster_locks table, and provides a subset of the information found in the latter table, but which is specific to the SQL node (MySQL server) where it ...
https://dev.mysql.com/doc/refman/5.7/en/plugin-loading.html
If the server is started with the --skip-grant-tables option, plugins registered in the mysql.plugin table are not loaded and are unavailable. --plugin-load, --plugin-load-add, and --early-plugin-load enable plugins to be loaded even when ... Server ...
https://dev.mysql.com/doc/refman/5.7/en/postinstallation.html
This section discusses tasks that you should perform after installing MySQL: If necessary, initialize the data directory and create the MySQL grant tables. Assign passwords to the initial root account in the grant tables, if that was not already ...
https://dev.mysql.com/doc/refman/5.7/en/show-privileges.html
Privileges belonging to a specific user are displayed by the SHOW GRANTS statement. SHOW PRIVILEGES SHOW PRIVILEGES shows the list of system privileges that the MySQL server supports. The exact list of privileges depends on the version of your ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-unicode-uca.html
It is not possible to create user-defined UCA collations for utf16le; there is no utf16le_unicode_ci collation that would serve as the basis for such collations. Table 10.4 MySQL Character Sets Available for User-Defined UCA Collations Character Set ... This section describes how to add a UCA collation for a Unicode character set by writing the <collation> element within a <charset> character set description in the MySQL Index.xml ...
https://dev.mysql.com/doc/refman/5.7/en/alter-server.html
For example, to update the USER option: ALTER SERVER s OPTIONS (USER 'sally'); ALTER SERVER causes an implicit commit. ALTER SERVER server_name OPTIONS (option [, option] ...) Alters the server information for server_name, adjusting any of the ...