PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/show-open-tables.html
If you have no privileges for a table, it does not show up in the output from SHOW OPEN TABLES. SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open in the ...
https://dev.mysql.com/doc/refman/8.0/en/show-replicas.html
{SHOW REPLICAS} Displays a list of replicas currently registered with the source. From MySQL 8.0.22, use SHOW REPLICAS in place of SHOW SLAVE HOSTS, which is deprecated from that release. SHOW REPLICAS should be executed on a server that acts as a ...
https://dev.mysql.com/doc/refman/8.0/en/show-triggers.html
This statement returns results only for databases and tables for which you have the TRIGGER privilege. SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database ...
https://dev.mysql.com/doc/refman/8.0/en/shutdown.html
SHUTDOWN provides an SQL-level interface to the same functionality available using the mysqladmin shutdown command or the mysql_shutdown() C API function. A successful SHUTDOWN sequence consists of checking the privileges, validating the arguments, ...
https://dev.mysql.com/doc/refman/8.0/en/socket-pluggable-authentication.html
The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket file. The plugin uses the SO_PEERCRED socket option to obtain information about the user running the client program.
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation-pkg.html
You must have root privileges to perform this operation: $> pkgadd -d mysql-8.0.43-solaris11-x86_64.pkg The following packages are available: 1 mysql MySQL Community Server (GPL) (i86pc) 8.0.43 Select package(s) you wish to process (or 'all' to ...
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation.html
If you do not have GNU tar on your system, install it with the following command: pkg install archiver/gnu-tar You should mount any file systems on which you intend to store InnoDB files with the forcedirectio option. Note MySQL 8.0 supports ...
https://dev.mysql.com/doc/refman/8.0/en/sorting-rows.html
You may have noticed in the preceding examples that the result rows are displayed in no particular order. It is often easier to examine query output when the rows are sorted in some meaningful way. This means that the order is undefined for columns ...
https://dev.mysql.com/doc/refman/8.0/en/source-installation-methods.html
Distribution files have names of the form mysql-VERSION.tar.gz, mysql-VERSION.zip, or mysql-VERSION.rpm, where VERSION is a number like 8.0.43. There are two methods for installing MySQL from source: Use a standard MySQL source distribution. To ...
https://dev.mysql.com/doc/refman/8.0/en/source-ssl-library-configuration.html
This can be useful if you have multiple versions of OpenSSL installed, to prevent CMake from choosing the wrong one: cmake . To check whether a mysqld server supports encrypted connections, examine the value of the have_ssl system variable: mysql> ... An SSL library is required for support of encrypted connections, entropy for random number generation, and other encryption-related ...