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/information-functions.html
CURRENT_USER, CURRENT_USER() Returns the user name and host name combination for the MySQL account that the server used to authenticate the current client. Within a stored program or view, CURRENT_USER() returns the account for the user who defined ...mysql> SELECT CHARSET('abc'); -> 'latin1' mysql> SELECT CHARSET(CONVERT('abc' USING utf8)); -> 'utf8' mysql> SELECT CHARSET(USER()); -> 'utf8' COERCIBILITY(str) Returns the collation coercibility value of the string ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-install-db.html
If the --login-path option is specified, the user, host, and password values are taken from the login path and used to create the administrative account. Secure-by-Default Deployment Current versions of mysql_install_db produce a MySQL deployment ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
Table 6.26 Event Class and Subclass Combinations Event Class Event Subclass Description connection connect Connection initiation (successful or unsuccessful) connection change_user User re-authentication with different user/password during session ...For information about using JSON data in MySQL, see Section 11.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filtering.html
The audit log filtering functions enable filtering control by providing an interface to create, modify, and remove filter definitions and assign filters to user accounts. Multiple filters can be defined, and any given filter can be assigned to any ...Note By default, rule-based audit log filtering logs no auditable events for any ... Note As of MySQL 5.7.13, for audit log filtering to work as described here, ...
https://dev.mysql.com/doc/refman/5.7/en/events-privileges.html
In this example, the EVENT privilege on the schema myschema is removed from the jon@ghidora user account: REVOKE EVENT ON myschema.* FROM jon@ghidora; Important Revoking the EVENT privilege from a user does not delete or disable any events that may ...An event is not migrated or dropped as a result of renaming or dropping the user who created ... To enable or disable the execution ...
https://dev.mysql.com/doc/refman/5.7/en/request-access.html
The user table row for an account indicates the account privileges that apply on a global basis no matter what the default database is. These privileges can come from any of the user, db, tables_priv, columns_priv, or procs_priv tables. (You may ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-ssl-rsa-setup.html
--uid=name, -v Command-Line Format --uid=name The name of the user who should be the owner of any created files. In the absence of this option, files created by mysql_ssl_rsa_setup are owned by the user who executes it. This program creates the SSL ...Note mysql_ssl_rsa_setup uses the openssl command, so its use is contingent on having OpenSSL installed on your ...
https://dev.mysql.com/doc/refman/5.7/en/socket-pluggable-authentication.html
The authentication_string value can be specified using an IDENTIFIED ...AS clause with CREATE USER or ALTER USER. The plugin uses the SO_PEERCRED socket option to obtain information about the user running the client program. To associate MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/password-management.html
To establish policy for individual accounts, use the PASSWORD EXPIRE options of the CREATE USER and ALTER USER statements. Example account-specific statements: Require the password to be changed every 90 days: CREATE USER 'jeffrey'@'localhost' ...
https://dev.mysql.com/doc/refman/5.7/en/user-variables.html
You can store a value in a user-defined variable in one statement and refer to it later in another statement. User variables are written as @var_name, where the variable name var_name consists of alphanumeric characters, ., _, and $. A user ...This ...