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/merge-storage-engine.html
Note The use of MERGE tables entails the following security issue: If a user has access to MyISAM table t, that user can create a MERGE table m that accesses t. When you create a MERGE table, MySQL creates two files on disk. However, if the user's ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
User-Created and Temporary Tables MEMORY table contents are stored in memory, which is a property that MEMORY tables share with internal temporary tables that the server creates on the fly while processing queries. The MEMORY storage engine ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table-optimization.html
For key_buffer_size, you must take into account that the buffer is shared with those users. Setting a session value limits the effect of the change to your current session and does not affect other users. Changing a global-only variable ... REPAIR ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-encrypted-connections.html
Encryption per connection is optional, but a specific user can be required to use encryption for X Protocol and MySQL Protocol connections by including an appropriate REQUIRE clause in the CREATE USER statement that creates the user. Alternatively, ... This section explains how to configure X Plugin to use encrypted ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
To create a test case that reproduces a problem with prepared statements, so that you can file a bug report. If you create a prepared statement within a stored routine, it is not deallocated when the stored routine ends. To guard against too many ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-local-connections.html
As an administrator, connect to the server and create an account for a local user who connects from the ::1 local IPv6 host address: mysql> CREATE USER 'ipv6user'@'::1' IDENTIFIED BY 'ipv6pass'; For the permitted syntax of IPv6 addresses in account ...Invoke the mysql client to connect to the server using the new account: $> mysql -h ::1 -u ipv6user -pipv6pass Try some simple statements that show connection information: mysql> STATUS ...mysql> SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-options.html
--keyring-migration-user=user_name Command-Line Format --keyring-migration-user=user_name Type String The user name of the MySQL account used for connecting to the running server that is currently using one of the key migration keystores. MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/password-security-admin.html
MySQL stores passwords for user accounts in the mysql.user system table. Account passwords can be expired so that users must reset them. Access to this table should never be granted to any nonadministrative accounts. A user who has access to modify ... Database administrators should use the following guidelines to keep passwords ...
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/faqs-cjk.html
Many Windows users find that a Microsoft character set, such as cp932 for Japanese Windows, is suitable. Why do I get Incorrect string value error messages? To see the problem, create a table with one Unicode (ucs2) column and one Chinese (gb2312) ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) ...