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/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/problems-connecting.html
is not allowed to connect to this MySQL server You can fix this by setting up an account for the combination of client host name and user name that you are using when trying to connect. (The data directory normally is named data or var and is ... If ...
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/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/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/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/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/audit-log-reference.html
Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for persistent storage of filter and user account data. The table has these columns: USER The user name part of an account. If a removed filter is assigned to any user ...The tables can be accessed only by users who have privileges for that ...
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 ...