PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-views-table.html
DEFINER The account of the user who created the view, in 'user_name'@'host_name' format. The flag is set to YES (true) if UPDATE and DELETE (and similar operations) are legal for the view. TABLE_SCHEMA The name of the schema (database) to which the ...You must have the SHOW VIEW privilege to access this ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-quick.html
First, you need to create a configuration directory such as /var/lib/mysql-cluster, by executing the following command as the system root user: $> mkdir /var/lib/mysql-cluster In this directory, create a file named config.ini that contains the ...# ...
https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html
Table 6.12 Plugin and Library Names for Cleartext Authentication Plugin or File Plugin or File Name Server-side plugin None, see discussion Client-side plugin mysql_clear_password Library file None (plugin is built in) Many client-side ... A ...
https://dev.mysql.com/doc/refman/5.7/en/alter-view.html
ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER }] VIEW view_name [(column_list)] AS select_statement [WITH [CASCADED | LOCAL] CHECK OPTION] This statement changes the definition of a view, ...
https://dev.mysql.com/doc/refman/5.7/en/locale-support.html
Any client can examine the value of lc_time_names or set its SESSION value to affect the locale for its own connection. This variable affects the output from the DATE_FORMAT(), DAYNAME(), and MONTHNAME() functions. The lc_time_names value does not ... The locale indicated by the lc_time_names system variable controls the language used to display day and month names and ...
https://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html
Locate the following key in the registry: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters On the Edit menu, click Add Value, and then add the following registry value: Value Name: MaxUserPort Data Type: REG_DWORD Value: 65534 ...If the server was started with the bind_address system variable set to 127.0.0.1, it listens for TCP/IP connections only locally on the loopback interface and does not accept remote ... A MySQL client on Unix can connect to the mysqld ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-thread_concurrency.html
When InnoDB receives a new request from a user session, if the number of threads concurrently executing is at a pre-defined limit, the new request sleeps for a short time before it tries again. InnoDB uses operating system threads to process ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-hosts-table.html
This is NULL for an internal thread, or for a user session that failed to authenticate. To set the table size explicitly, set the performance_schema_hosts_size system variable at server startup. The hosts table contains a row for each host from ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
The same is true for other CREATE TABLE options such as CHARSET. Retrained attributes are NULL (or NOT NULL) and, for those columns that have them, CHARACTER SET, COLLATION, COMMENT, and the DEFAULT clause. You can create one table from another by ...The ENGINE option is part of the CREATE TABLE statement, and should not be used following the SELECT; this would result in a syntax ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-shell-userguide.html
For documentation on the concepts and usage of X DevAPI, which is implemented in MySQL Shell, see X DevAPI User Guide. The AdminAPI enables database administrators to work with InnoDB Cluster, which provides an integrated solution for high ... MySQL ...MySQL Shell includes the following APIs implemented in JavaScript and Python which you can use to develop code that interacts with ...