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/set-password.html
For information about the conditions under which this occurs for the server logs and how to control it, see Section 6.1.2.3, “Passwords and Logging”. SET PASSWORD [FOR user] = password_option password_option: { 'auth_string' | ...
https://dev.mysql.com/doc/refman/5.7/en/set-statement.html
Descriptions for those forms that are not associated with a specific server capability appear in subsections of this section: SET var_name = value enables you to assign values to variables that affect the operation of the server or clients. SET ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-event.html
SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-function.html
SHOW CREATE FUNCTION func_name This statement is similar to SHOW CREATE PROCEDURE but for stored functions.
https://dev.mysql.com/doc/refman/5.7/en/show-create-procedure.html
SHOW CREATE PROCEDURE proc_name This statement is a MySQL extension. It returns the exact string that can be used to re-create the named stored procedure. A similar statement, SHOW CREATE FUNCTION, displays information about stored functions (see ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-user.html
SHOW CREATE USER user This statement shows the CREATE USER statement that creates the named user. The statement requires the SELECT privilege for the mysql system database, except to display information for the current user. To name the account, ...
https://dev.mysql.com/doc/refman/5.7/en/show-errors.html
You can also retrieve this number from the error_count variable: SHOW COUNT(*) ERRORS; SELECT @@error_count; SHOW ERRORS and error_count apply only to errors, not warnings or notes. SHOW ERRORS [LIMIT [offset,] row_count] SHOW COUNT(*) ERRORS SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/show-function-code.html
SHOW FUNCTION CODE func_name This statement is similar to SHOW PROCEDURE CODE but for stored functions.
https://dev.mysql.com/doc/refman/5.7/en/show-function-status.html
SHOW FUNCTION STATUS [LIKE 'pattern' | WHERE expr] This statement is similar to SHOW PROCEDURE STATUS but for stored functions.
https://dev.mysql.com/doc/refman/5.7/en/show-grants.html
SHOW GRANTS [FOR user] This statement displays the privileges that are assigned to a MySQL user account, in the form of GRANT statements that must be executed to duplicate the privilege assignments. Note To display nonprivilege information for ...