PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/security-guidelines.html
When running MySQL, follow these guidelines: Do not ever give anyone (except MySQL root accounts) access to the user table in the mysql system database! This is critical. Anyone using MySQL on a computer connected to the Internet should read this ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
The database administrator must set these variables at server startup if the key files to use have names that differ from the system variable default values. Client users can obtain the RSA public key two ways: The database administrator can provide ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 ...
https://dev.mysql.com/doc/refman/5.7/en/show-tables.html
SHOW [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLES lists the non-TEMPORARY tables in a given database. You can also get this list using the mysqlshow db_name command. The LIKE clause, if present, indicates which ...
https://dev.mysql.com/doc/refman/5.7/en/silent-column-changes.html
MySQL maps certain data types used by other SQL database vendors to MySQL types. In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, to ...
https://dev.mysql.com/doc/refman/5.7/en/solaris-installation-pkg.html
(default: all) [?,??,q]: The PKG installer installs all of the files and tools needed, and then initializes your database if one does not exist. Removal of the package does not delete the existing database information, only the server, binaries and ... You can install MySQL on Solaris using a binary package of the native Solaris PKG format instead of the binary tarball ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
This makes it easier to use MySQL in different environments and to use MySQL together with other database servers. The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the ...
https://dev.mysql.com/doc/refman/5.7/en/statement-optimization.html
The core logic of a database application is performed through SQL statements, whether issued directly through an interpreter or submitted behind the scenes through an API. The guidelines cover SQL operations that read and write data, the ...The ...
https://dev.mysql.com/doc/refman/5.7/en/storage-requirements.html
It connects to a current MySQL (not NDB Cluster) database and creates a report on how much space that database would require if it used the NDB storage engine. InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-usage.html
To generate a dump file, name the sys schema explicitly on the command line using either of these commands: mysqldump --databases --routines sys > sys_dump.sql mysqlpump sys > sys_dump.sql To reinstall the schema from the dump file, use this ...Most ...
https://dev.mysql.com/doc/refman/5.7/en/user-resources.html
Only statements that modify databases or tables count against the update limit. One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. This limits the number of ...