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/stored-objects-security.html
Administrators can prevent users from creating stored objects that specify highly privileged DEFINER accounts by not granting them the SUPER privilege. In some cases, you can prevent references to these objects by not granting unauthorized users ...
https://dev.mysql.com/doc/refman/5.7/en/user-names.html
For information about account representation in the user table, see Section 6.2.3, “Grant Tables”. The MySQL installation process populates the grant tables with an initial root account, as described in Section 2.9.4, “Securing the Initial ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-service.html
The command connects as the MySQL root user, which is the default administrative account in the MySQL grant system. Note Users in the MySQL grant system are wholly independent from any operating system users under Windows. On Windows, the ...
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-programs-ndb-size-pl.html
If you do not wish to use an existing account, then creating one using GRANT USAGE ON db_name.*—where db_name is the name of the database to be examined—is sufficient for this purpose. This is a Perl script that can be used to estimate the ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
Defining Primary Keys The PRIMARY KEY clause is a critical factor affecting the performance of MySQL queries and the space usage for tables and indexes. If you have MyISAM tables that you want to convert to InnoDB for better reliability and ...
https://dev.mysql.com/doc/refman/5.7/en/environment-variables.html
This section lists environment variables that are used directly or indirectly by MySQL. Most of these can also be found in other places in this manual. Options on the command line take precedence over values specified in option files and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html
This section describes the AUTO_INCREMENT lock modes, usage implications of different AUTO_INCREMENT lock mode settings, and how InnoDB initializes the AUTO_INCREMENT counter. InnoDB AUTO_INCREMENT Lock Modes InnoDB AUTO_INCREMENT Lock Mode Usage ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
Use the max attribute only in cases where constraining disk usage is of critical importance. Warning On 32-bit GNU/Linux x86, if memory usage is set too high, glibc may permit the process heap to grow over the thread stacks, causing a server failure. A formula similar to the following that calculates global and per-thread memory allocation for MySQL can be used to estimate MySQL memory ... The first decisions to make about InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-blob-tool.html
--usage Command-Line Format --usage Display help text and exit; same as --help. This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as well as to generate a file listing any orphaned parts. It is sometimes ...