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/audit-log-security.html
For security reasons, audit log files should be written to a directory accessible only to the MySQL server and to users with a legitimate reason to view the log. By default, contents of audit log files produced by the audit log plugin are not ...
https://dev.mysql.com/doc/refman/5.7/en/backup-and-recovery.html
It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. Backups are also essential as a safeguard ...
https://dev.mysql.com/doc/refman/5.7/en/batch-mode.html
In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some of the statements in it produce errors, you should use the --force command-line option. Why use a ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
(Bug #12092, Bug #30244) When USER(), CURRENT_USER(), or CURRENT_USER is used. When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a DML statement ...
https://dev.mysql.com/doc/refman/5.7/en/bit-value-literals.html
For example, a bit literal assigned to a user-defined variable is a binary string by default. A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of ...
https://dev.mysql.com/doc/refman/5.7/en/blob.html
For security and other reasons, it is usually preferable to do so using application code rather than giving application users the FILE privilege. A BLOB is a binary large object that can hold a variable amount of data. These differ only in the ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
To discuss problems with other users, you can use the MySQL Community Slack. Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at ...
https://dev.mysql.com/doc/refman/5.7/en/call.html
To get back a value from a procedure using an OUT or INOUT parameter, pass the parameter by means of a user variable, and then check the value of the variable after the procedure returns. CALL sp_name([parameter[,...]]) CALL sp_name[()] The CALL ...
https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html
However, this may yield inconsistent results because the init_connect value is not executed for users who have the SUPER privilege. For applications that store data using the default MySQL character set and collation (latin1, latin1_swedish_ci), no ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-coercibility.html
A “system constant” (the string returned by functions such as USER() or VERSION()) has a coercibility of 3. In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison operation. For example, in the ...