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/account-upgrades.html
The MySQL server authenticates connection attempts for each account listed in the mysql.user system table using the authentication plugin named in the plugin column. As a variant on these instructions, DBAs might offer users the choice to upgrade ...If the plugin column is empty, the server authenticates the account as follows: Before MySQL 5.7, the server uses the mysql_native_password or mysql_old_password plugin implicitly, depending on the format of the password hash in the Password ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-workflow.html
Note Full permissions are granted to the user executing MySQL Installer to all generated files, such as my.ini. You have the following options: MySQL Installer can configure the folders and files with full control granted exclusively to the user ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication.html
When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the appropriate account row from the mysql.user system table. Otherwise, the server invokes that plugin to authenticate ...The server then authenticates the client, determining from the account row which authentication plugin applies to the client: If the server cannot find the plugin, an error occurs and the connection attempt is ...
https://dev.mysql.com/doc/refman/5.7/en/user-names.html
For information about account representation in the user table, see Section 6.2.3, “Grant Tables”. Thereafter, you normally set up, modify, and remove MySQL accounts using statements such as CREATE USER, DROP USER, GRANT, and REVOKE. MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/events-privileges.html
Suppose that the user jon@ghidora has been granted the EVENT and INSERT privileges on the myschema schema. mysql.user.Event_priv is set to 'Y' for a given user only if that user has the global EVENT privilege (that is, if the privilege was bestowed ...Suppose also that this user has the SELECT privilege for myschema, but no other privileges for this ... To enable or disable the ...
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/security-against-attack.html
Do not grant the PROCESS or SUPER privilege to nonadministrative users. It is common for client/server applications that the user can specify any user name to the client program. For example, anyone can use the mysql program to connect as any other ... When you connect to a MySQL server, you should use a ...
https://dev.mysql.com/doc/refman/5.7/en/account-activity-auditing.html
The User and Host column values in this row uniquely identify the account and correspond to the 'user_name'@'host_name' format in which account names are written in SQL statements. Normally, the CURRENT_USER() function can be invoked to determine ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
Account names appear in SQL statements such as CREATE USER, GRANT, and SET PASSWORD and follow these rules: Account name syntax is 'user_name'@'host_name'. MySQL stores account names in grant tables in the mysql system database using separate ...
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 ...