Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-datetime-types-processing.html
connectionTimeZone Configures the connection time zone which is used by Connector/J if conversion between the JVM default and a target time zone is needed when preserving instant temporal values. Accepts a geographic time zone name or a time zone ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-security.html
paranoid Take measures to prevent exposure sensitive information in error messages and clear data structures holding sensitive data when possible? Default Value false Since Version 3.0.1 serverRSAPublicKeyFile File path to the server RSA public key ...
https://dev.mysql.com/doc/refman/8.4/en/account-categories.html
MySQL incorporates the concept of user account categories, based on the SYSTEM_USER privilege. The SYSTEM_USER privilege has an effect on the accounts to which a given user can apply its other privileges, as well as whether the user is protected ...
https://dev.mysql.com/doc/refman/8.4/en/account-locking.html
MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new account. In ...
https://dev.mysql.com/doc/refman/8.4/en/alter-event.html
The syntax for each of the DEFINER, ON SCHEDULE, ON COMPLETION, COMMENT, ENABLE / DISABLE, and DO clauses is exactly the same as when used with CREATE EVENT. (See Section 15.1.13, “CREATE EVENT Statement”.) Any user can alter an event defined on ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mixed.html
When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a function contains UUID(). When one or more tables with AUTO_INCREMENT columns are updated and a ...
https://dev.mysql.com/doc/refman/8.4/en/cannot-initialize-character-set.html
You might see an error like this if you have character set problems: MySQL Connection Failed: Can't initialize character set charset_name This error can have any of the following causes: The character set is a multibyte character set and you have ...
https://dev.mysql.com/doc/refman/8.4/en/case-sensitivity.html
For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-filter.html
Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP REPLICA SQL_THREAD ...
https://dev.mysql.com/doc/refman/8.4/en/charset-asian-sets.html
For example, the Chinese sets must allow for thousands of different characters. The Asian character sets that we support include Chinese, Japanese, Korean, and Thai. See Section 12.10.7.1, “The cp932 Character Set”, for additional information ...