PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
The option does not affect authentication (4.1 and later clients can still use accounts that have long password hashes), but it does prevent creation of a long password hash in the user table as the result of a password-changing operation. MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
CREATE USER Enables use of the ALTER USER, CREATE USER, DROP USER, RENAME USER, and REVOKE ALL PRIVILEGES statements. (This implies the user can read any file in any database directory, because the server can access any of those files.) Enables ...
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/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/security-against-attack.html
The CREATE USER and ALTER USER statements also support resource control options for limiting the extent of server use permitted to an account. If all accounts have a password, connecting using another user's account becomes much more difficult. Make ...To make a MySQL system secure, you should strongly consider the following suggestions: Require all MySQL accounts to have a ...
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/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/xml-functions.html
You may discuss these, ask questions about them, and obtain help from other users with them in the MySQL XML User Forum. XPath expressions used with these functions support user variables and local stored program variables. User variables are weakly ... Table 12.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in ...
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/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 ...