MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 1111 to 1120 of 1444 total results

6.4.1.6 Client-Side Cleartext Pluggable Authentication

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 ...

B.3.2.9 Communication Errors and Aborted Connections

https://dev.mysql.com/doc/refman/5.7/en/communication-errors.html

The host cache, which is accessible using the Performance Schema host_cache table. See Section 5.1.11.2, “DNS Lookups and the Host Cache”, and Section 25.12.16.1, “The host_cache Table”. If connection problems occur such as communication ...

12.4.2 Comparison Functions and Operators

https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html

Table 12.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...

2.8.8 Dealing with Problems Compiling MySQL

https://dev.mysql.com/doc/refman/5.7/en/compilation-problems.html

Versions of bison older than 1.75 may report this error: sql_yacc.yy:#####: fatal error: maximum table size (32767) exceeded The maximum table size is not actually exceeded; the error is caused by bugs in older versions of bison. If you do ...

6.4.2.2 Connection Control Plugin System and Status Variables

https://dev.mysql.com/doc/refman/5.7/en/connection-control-plugin-variables.html

For more detailed connection control monitoring information, examine the INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS table; see Section 24.6.2, “The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table”. This ...

Chapter 27 Connectors and APIs

https://dev.mysql.com/doc/refman/5.7/en/connectors-apis.html

Table 27.1, “MySQL APIs and Interfaces” lists many of the libraries and interfaces available for MySQL. Table 27.1 MySQL APIs and Interfaces Environment API Type Notes Ada GNU Ada MySQL Bindings libmysqlclient See MySQL Bindings for GNU Ada C C ... MySQL Connectors provide connectivity to the MySQL server for client ...

3.3.1 Creating and Selecting a Database

https://dev.mysql.com/doc/refman/5.7/en/creating-database.html

(Under Windows, this restriction does not apply, although you must refer to databases and tables using the same lettercase throughout a given query. Alternatively, you can select the database on the command line when you invoke mysql. If the ...

11.2 Date and Time Data Types

https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html

Unpredictable results may occur if you use values in other formats. The following table shows the format of the “zero” value for each type. The “zero” values are special, but you can store or refer to them explicitly using the values shown ... The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and ...

13.6.7.1 DECLARE ... CONDITION Statement

https://dev.mysql.com/doc/refman/5.7/en/declare-condition.html

DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... CONDITION statement declares a named error condition, associating a name with a condition that needs ...

8.12.2 Optimizing Disk I/O

https://dev.mysql.com/doc/refman/5.7/en/disk-issues.html

If your computer is reasonably stable, this should give you better performance without sacrificing too much reliability. This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database ...

Displaying 1111 to 1120 of 1444 total results