Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-example-connecting.html
The following example shows how to connect to the MySQL server: import mysql.connector cnx = mysql.connector.connect(user='scott', password='password', host='127.0.0.1', database='employees') cnx.close() Section 7.1, “Connector/Python Connection ... The connect() constructor creates a connection to the MySQL server and returns a MySQLConnection ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-compliance-replication-standard-rules.html
You may want to measure your database performance on a test system before and after making this change to be sure the overhead is acceptable before deploying the change in production. Note that the current implementation of multi-threading on the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/ui-security-advisor-ref.html
Global Privilege User Exclusion Regex: A MySQL server may have user accounts with privileges on all databases and tables (*.*). Database Level Privileges On All Databases User Exclusion Regex: Privileges such as SELECT, INSERT, and ALTER, allow a ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-an-anomaly-detection-model.html
To prepare the data for the semi-supervised anomaly detection model: Connect to your MySQL HeatWave Database System. mysql> CREATE DATABASE anomaly_data; mysql> USE anomaly_data; Create the table to insert the sample data into. To prepare the data ... This topic describes how to prepare the data to use for two anomaly detection machine learning models: a semi-supervised anomaly detection model, and an unsupervised anomaly detection model for ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-generate-table.html
OutputTableColumn: specifies the names of the database, table, and column where the generated text-based response is stored. To view the lists of available LLMs, see MySQL HeatWave In-Database LLMs and OCI Generative AI Service LLMs. Possible values ... The ML_GENERATE_TABLE routine runs multiple text generation or summarization queries in a batch, in ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-nl-sql.html
You can use this routine for generating and running SQL queries only for databases and tables that you have access to. @output: output parameter that includes the list of tables and databases considered for generating the SQL query, Model ID of the ...The routine also runs the generated SQL statement and displays the result ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-network-config-ibr-privatelink.html
Knowledge of the following information regarding your service (for example, a source database that replicates to your DB System in MySQL HeatWave on AWS): The VPC that is hosting the service you wish to expose to HeatWave on AWS (for example, a ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-connection.html
Since Version 5.1.25 connectionLifecycleInterceptors A comma-delimited list of classes that implement 'com.mysql.cj.jdbc.interceptors.ConnectionLifecycleInterceptor' that should be notified of connection lifecycle events (creation, destruction, ...
https://dev.mysql.com/doc/refman/8.4/en/access-control.html
The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to associate that user with privileges on a database such as SELECT, INSERT, UPDATE, and DELETE. For example: SHOW GRANTS FOR ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-installation.html
The example here uses the Linux installation script and the default mysql system database. $> mysql -u root -p -D mysql < audit_log_filter_linux_install.sql Enter password: (enter root password here) It is possible to specify a custom database for ... This section describes how to install or uninstall MySQL Enterprise Audit, which is implemented using the audit log plugin and related elements described in Section 8.4.5.1, “Elements of MySQL Enterprise ...