PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/set-default-role.html
Setting the default roles for yourself requires no special privileges, as long as the roles you want as the default have been granted to you. SET DEFAULT ROLE {NONE | ALL | role [, role ] ...} TO user [, user ] ... For each user named immediately ...
https://dev.mysql.com/doc/refman/8.0/en/set-password.html
SET PASSWORD [FOR user] auth_option [REPLACE 'current_auth_string'] [RETAIN CURRENT PASSWORD] auth_option: { = 'auth_string' | TO RANDOM } The SET PASSWORD statement assigns a password to a MySQL user account. The password may be either explicitly ...
https://dev.mysql.com/doc/refman/8.0/en/set-sql-log-bin.html
The session user must have privileges sufficient to set restricted session variables. SET sql_log_bin = {OFF|ON} The sql_log_bin variable controls whether logging to the binary log is enabled for the current session (assuming that the binary log ...
https://dev.mysql.com/doc/refman/8.0/en/setting-environment-variables.html
To have the settings take effect each time you log in, use the interface provided by your system or place the appropriate command or commands in a startup file that your command interpreter reads each time it starts. Environment variables can be ...
https://dev.mysql.com/doc/refman/8.0/en/show-binary-logs.html
Encrypted binary log files have a 512-byte file header that stores information required for encryption and decryption of the file. SHOW BINARY LOGS SHOW MASTER LOGS Lists the binary log files on the server. This statement is used as part of the ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-table.html
To use this statement, you must have some privilege for the table. SHOW CREATE TABLE tbl_name Shows the CREATE TABLE statement that creates the named table. row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int NOT NULL ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-user.html
Password hash values displayed in the IDENTIFIED WITH clause of output from SHOW CREATE USER may contain unprintable characters that have adverse effects on terminal displays and in other environments. SHOW CREATE USER user This statement shows the ...
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/show-index.html
This can have values A (ascending), D (descending), or NULL (not sorted). SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This statement requires some ...
https://dev.mysql.com/doc/refman/8.0/en/show-master-status.html
row *************************** File: source-bin.000002 Position: 1307 Binlog_Do_DB: test Binlog_Ignore_DB: manual, mysql Executed_Gtid_Set: 3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5 1 row in set (0.00 sec) When global transaction IDs are in use, ...