Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-server-compatibility.html
skip_invalid_accounts Skips user accounts created with external authentication plugins that are not supported in MySQL HeatWave on AWS. From MySQL Shell 8.0.26, this option also removes user accounts that do not have passwords set, except where an ...loadDump command only allows import of dumps created with the ocimds option ... MySQL Server Compatibility 7.1.2 MySQL Server Compatibility MySQL HeatWave on AWS has several ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-connect-drivermanager.html
try { conn = DriverManager.getConnection("jdbc:mysql://localhost/test?" + "user=minty&password=greatsqldb"); // Do something with the Connection ... } catch (SQLException ex) { // handle any errors System.out.println("SQLException: " + ... When you ...
https://dev.mysql.com/doc/x-devapi-userguide/en/connecting-connection-pool.html
Closing the Client object closes all connections it manages, invalidates all Sessions the Client has created, and destroys the managed pool. X DevAPI supports connection pooling, which can reduce overhead for applications that open many connections ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-connect-drivermanager.html
try { conn = DriverManager.getConnection("jdbc:mysql://localhost/test?" + "user=minty&password=greatsqldb"); // Do something with the Connection ... } catch (SQLException ex) { // handle any errors System.out.println("SQLException: " + ... When you ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
This is to prevent the redo log data from being exposed to unauthorized users on the system. Otherwise, the following error is returned: ERROR 3846 (HY000): Redo log archive directory 'directory_path1' is accessible to all OS users Directories ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysqlrouter_keyring.html
Creates a keyring and master-key-file if they do not exist; and adds keyring to master-key-file if it does not yet exist there. list: List usernames stored in the keyring; or list properties of a user stored in the keyring. set: Add or overwrite ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
User-Created and Temporary Tables MEMORY table contents are stored in memory, which is a property that MEMORY tables share with internal temporary tables that the server creates on the fly while processing queries. The MEMORY storage engine ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-instruments-table.html
Instruments with a higher volatility index (for example, SESSION = 5) are created and destroyed for every user session. When an instrument is enabled and executed, instrumented instances are created, which are visible in the xxx_instances tables, ...
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
A stored routine that uses the database defaults when the routine is created includes those defaults as part of its definition. See Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) If you change the default character set or ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-dsn-windows-5-2.html
You should see a window similar to the following when you open the ODBC Data Source Administrator: Figure 5.2 ODBC Data Source Administrator Dialog To create a System DSN (which will be available to all users), select the System DSN tab. To create a ... The ODBC Data Source Administrator on Windows lets you create DSNs, check driver installation, and configure ODBC functions such as tracing (used for debugging) and connection ...