PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-save.html
This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved() procedure. It is intended you call ps_setup_reload_saved() later within the same ...To prevent other simultaneous calls to save the configuration, ps_setup_save() acquires an advisory lock named sys.ps_setup_save by calling the GET_LOCK() ...
https://dev.mysql.com/doc/refman/8.0/en/set-default-role.html
However, ALTER USER can set the default for only a single user, whereas SET DEFAULT ROLE can set the default for multiple users. On the other hand, you can specify CURRENT_USER as the user name for the ALTER USER statement, whereas you cannot for ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-privileges.html
The ALTER ROUTINE privilege is needed to alter or drop stored routines. If the automatic_sp_privileges system variable is 0, the EXECUTE and ALTER ROUTINE privileges are not automatically granted to and dropped from the routine creator. The account ... The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation-pkg.html
From the Installation Type page you can either click Install to execute the installation wizard using all defaults, click Customize to alter which components to install (MySQL server, MySQL Test, Preference Pane, Launchd Support -- all but MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/refman/8.0/en/apache.html
There are programs that let you authenticate your users from a MySQL database and also let you write your log files into a MySQL table.
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
For example, if the configured audit_log_file value is audit.log, the effective file name is one of the values shown in the following table. In that case, an archived audit log file has one of the names shown in the following table. This section ...
https://dev.mysql.com/doc/refman/8.0/en/binary-varbinary.html
Instead, it causes the binary (_bin) collation for the column character set (or the table default character set if no column character set is specified) to be used, and the column itself stores nonbinary character strings rather than binary byte ...
https://dev.mysql.com/doc/refman/8.0/en/calculating-days.html
CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 VALUES(2000,1,1),(2000,1,20),(2000,1,30),(2000,2,2), (2000,2,23),(2000,2,23); The example table contains year-month-day values representing visits by users to the page. The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-implementations.html
MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. It is a case-insensitive ...