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/drop-view.html
If any views named in the argument list do not exist, the statement returns an error indicating by name which nonexisting views it was unable to drop, but also drops all views in the list that do exist. Note In MySQL 8.0, DROP VIEW fails if any ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-installation.html
The CREATE FUNCTION and DROP FUNCTION statements require the INSERT and DROP privilege, respectively, for the mysql database. MySQL Enterprise Encryption functions are located in a loadable function library file installed in the plugin directory ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-usage.html
To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to perform. Use the private key to encrypt data and the public key to decrypt it This requires that the members of the key ...
https://dev.mysql.com/doc/refman/5.7/en/events-status-info.html
See Section 23.4.6, “The Event Scheduler and MySQL Privileges” for an example. The Event Scheduler writes information about event execution that terminates with an error or warning to the MySQL Server's error log. For frequently executed ...
https://dev.mysql.com/doc/refman/5.7/en/explain-for-connection.html
If you have the PROCESS privilege, you can specify the identifier for any connection. To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION connection_id; ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
Security A privilege and password system that is very flexible and secure, and that enables host-based verification. This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create-connection.html
This user must have been created on the remote server, and must have suitable privileges to perform the required actions (SELECT, INSERT, UPDATE, and so forth) on the remote table. To use the first method, you must specify the CONNECTION string ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
checking permissions The thread is checking whether the server has the required privileges to execute the statement. The following list describes thread State values that are associated with general query processing and not more specialized ...
https://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html
(You can also use SHOW WARNINGS or SHOW ERRORS to see conditions or errors.) No special privileges are required to execute GET DIAGNOSTICS. GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ... The ...
https://dev.mysql.com/doc/refman/5.7/en/gone-away.html
A client application running on a different host does not have the necessary privileges to connect to the MySQL server from that host. This section also covers the related Lost connection to server during query error. The most common reason for the ...