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/set-password.html
(In particular, you can change your own password.) To see which account the server authenticated you as, invoke the CURRENT_USER() function: SELECT CURRENT_USER(); If a FOR user clause is given, the account name uses the format described in Section ... SET PASSWORD [FOR user] = password_option password_option: { 'auth_string' | PASSWORD('auth_string') } The SET PASSWORD statement assigns a password to a MySQL user ...
https://dev.mysql.com/doc/refman/5.7/en/set-variable.html
An error occurs for attempts to apply them to user-defined variables, stored procedure or function parameters, or stored program local variables. An error occurs for attempts to assign DEFAULT to user-defined variables, stored procedure or function ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | [SESSION | ...
https://dev.mysql.com/doc/refman/5.7/en/show-privileges.html
row *************************** Privilege: Alter routine Context: Functions,Procedures Comment: To alter or drop stored functions/procedures *************************** 3. row *************************** Privilege: Create routine Context: Databases ... SHOW PRIVILEGES SHOW PRIVILEGES shows the list of system privileges that the MySQL server ...
https://dev.mysql.com/doc/refman/5.7/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance Schema instead; see Section 25.19.1, “Query Profiling Using Performance Schema”. To control profiling, ...
https://dev.mysql.com/doc/refman/5.7/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. The pattern is useful for restricting statement output to matching values. Several SHOW statements also accept a WHERE clause ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
-DWITH_ZLIB=zlib_type Some features require that the server be built with compression library support, such as the COMPRESS() and UNCOMPRESS() functions, and compression of the client/server protocol. The CMake program provides a great deal of ...
https://dev.mysql.com/doc/refman/5.7/en/ssl-libraries.html
OpenSSL and yaSSL offer the same basic functionality, but MySQL distributions compiled using OpenSSL have additional features: OpenSSL supports TLSv1, TLSv1.1, and TLSv1.2 protocols. OpenSSL supports more encryption modes for the AES_ENCRYPT() and ... MySQL can be compiled using OpenSSL or yaSSL, both of which enable encrypted connections based on the OpenSSL API: MySQL Enterprise Edition binary distributions are compiled using ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html
Implemented in the server via encryption functions; In MySQL 5.7 and later, data-at-rest encryption is supported.5. Implemented in the server via encryption functions; encrypted NDB backups as of NDB 8.0.22; transparent NDB file system encryption ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-metadata.html
Use the SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION statements to see routine definitions. Use the SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS statements to see routine characteristics. Use the SHOW PROCEDURE CODE and SHOW FUNCTION CODE ... To ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-show-disabled.html
Displays all currently disabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display disabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display disabled threads. Example ...