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/information-functions.html
One way this might occur is that there is no account listed in the grant tables for davida. It may be used to time how quickly MySQL processes the expression. The result value is 0, or NULL for inappropriate arguments such as a NULL or negative ...
https://dev.mysql.com/doc/refman/5.7/en/install-plugin.html
It requires the INSERT privilege for the mysql.plugin system table because it adds a row to that table to register the plugin. If the server is started with the --skip-grant-tables option, plugins registered in the mysql.plugin table are not loaded ... INSTALL PLUGIN plugin_name SONAME 'shared_library_name' This statement installs a server ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-support.html
MySQL account names permit IPv6 addresses to enable DBAs to specify privileges for clients that connect to the server over IPv6. IPv6 addresses can be specified in account names in statements such as CREATE USER, GRANT, and REVOKE. For example: ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/doc/refman/5.7/en/replication-encrypted-connections.html
If you want to ensure that the source only accepts replicas that connect using encrypted connections, create a replication user account on the source using the REQUIRE SSL option, then grant that user the REPLICATION SLAVE privilege. For example: ...
https://dev.mysql.com/doc/refman/5.7/en/user-resources.html
The counts also can be reset by reloading the grant tables (for example, with a FLUSH PRIVILEGES statement or a mysqladmin reload command). (See Section 6.2.3, “Grant Tables”.) Resource-use counting takes place when any account has a nonzero ...
https://dev.mysql.com/doc/refman/5.7/en/alter-function.html
(That privilege is granted automatically to the function creator.) If binary logging is enabled, the ALTER FUNCTION statement might also require the SUPER privilege, as described in Section 23.7, “Stored Program Binary Logging”. ALTER FUNCTION ...
https://dev.mysql.com/doc/refman/5.7/en/alter-procedure.html
By default, that privilege is granted automatically to the procedure creator. This behavior can be changed by disabling the automatic_sp_privileges system variable. ALTER PROCEDURE proc_name [characteristic ...] characteristic: { COMMENT 'string' | ...
https://dev.mysql.com/doc/refman/5.7/en/connection-interfaces.html
By granting the privilege to administrators and not to normal users (who should not need it), an administrator who also has the PROCESS privilege can connect to the server and use SHOW PROCESSLIST to diagnose problems even if the maximum number of ...The extra connection is reserved for use by accounts that have the SUPER ... This ...
https://dev.mysql.com/doc/refman/5.7/en/database-use.html
Use the SHOW statement to find out what databases currently exist on the server: mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql | | test | | tmp | +----------+ The mysql database describes user access privileges. The list of ... Once you know how to enter SQL statements, you are ready to access a ...