PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html
However, use of Host values ending with % is insecure and is not recommended!) If mysql -u user_name works but mysql -u user_name some_db does not, you have not granted access to the given user for the database named some_db. The grant tables must ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...
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/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/request-access.html
(You may find it helpful to refer to Section 6.2.3, “Grant Tables”, which lists the columns present in each grant table.) The user table grants global privileges. For example, if the user table grants you the DELETE privilege, you can delete ...
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/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/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/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/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 ...