Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-query-attributes.html
Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using Query Attributes for details). Attributes are set for a query by using the setAttribute() method ...
https://dev.mysql.com/doc/connector-j/en/connector-j-test-props-changes.html
No longer needed, as multi-JVM tests have been removed from the test suite.
https://dev.mysql.com/doc/refman/8.4/en/account-locking.html
Account locking state is recorded in the account_locked column of the mysql.user system table. The account-locking capability depends on the presence of the account_locked column in the mysql.user system table. MySQL supports locking and unlocking ...
https://dev.mysql.com/doc/refman/8.4/en/adding-collation-unicode-uca.html
The following table lists the base collations of the Unicode character sets for which UCA collations can be defined. Table 12.4 MySQL Character Sets Available for User-Defined UCA Collations Character Set Base Collation utf8mb4 utf8mb4_unicode_ci ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-legacy-filtering.html
Note This section describes legacy audit log filtering, which applies if the audit_log plugin is installed without the accompanying audit tables and functions needed for rule-based filtering. If you set audit_log_policy to a non-ALL value, that ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log.html
The log contents include when clients connect and disconnect, and what actions they perform while connected, such as which databases and tables they access. By default, MySQL Enterprise Audit uses tables in the mysql system database for persistent ... Note MySQL Enterprise Audit is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/automatic-start.html
The following table shows which option groups the server and startup scripts read from option files. Table 2.16 MySQL Startup Scripts and Supported Server Option Groups Script Option Groups mysqld [mysqld], [server], [mysqld-major_version] ... This ...
https://dev.mysql.com/doc/refman/8.4/en/backup-and-recovery.html
It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. Backups are also essential as a safeguard ...
https://dev.mysql.com/doc/refman/8.4/en/changing-mysql-user.html
For example: [mysqld] user=user_name If your Unix machine itself is not secured, you should assign passwords to the MySQL root account in the grant tables. On Windows, you can run the server as a Windows service using a normal user account. On ...
https://dev.mysql.com/doc/refman/8.4/en/charset-binary-collations.html
The example also shows how to use the INFORMATION_SCHEMA COLLATIONS table to determine the pad attribute for collations. This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings. Binary ...