Search Results
https://dev.mysql.com/doc/refman/8.4/en/connecting-disconnecting.html
To connect to the server, you usually need to provide a MySQL user name when you invoke mysql and, most likely, a password. Contact your administrator to find out what connection parameters you should use to connect (that is, what host, user name, ...If the server runs on a machine other than the one where you log in, you must also specify a host ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-query-profiling.html
The setup_actors table can be used to limit the collection of historical events by host, user, or account to reduce runtime overhead and the amount of data collected in history tables. The first step of the example shows how to limit collection of ... The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data comparable to profiling information provided by SHOW PROFILES and SHOW PROFILE ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-variables-info-table.html
This includes option files not covered by EXPLICIT, EXTRA, LOGIN, PERSISTED, SERVER, or USER. LOGIN The variable was set from a user-specific login path file (~/.mylogin.cnf). USER The variable was set from a user-specific ~/.my.cnf option file.
https://dev.mysql.com/doc/refman/8.4/en/secure-client-programming.html
Handle External Data Properly Handle MySQL Error Messages Properly Handle External Data Properly Applications that access MySQL should not trust any data entered by users, who can try to trick your code by entering special or escaped character ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-an-anomaly-detection-model.html
To ensure reliable predictions, you should create an additional validation dataset. You can reserve 20% of the records in the training dataset to create the validation dataset. mysql> CREATE DATABASE anomaly_data; mysql> USE anomaly_data; Create the ... 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/refman/8.4/en/implicit-commit.html
This means that a ROLLBACK from the user does not undo CREATE TABLE statements the user made during that transaction. ALTER USER, CREATE USER, DROP USER, GRANT, RENAME USER, REVOKE, SET PASSWORD. CREATE TABLE and DROP TABLE statements do not commit ... The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-catalog.html
MySQL HeatWave AutoML creates a model catalog for any user that creates a machine learning model. The MODEL_CATALOG table is created in a schema named ML_SCHEMA_user_name, where the user_name is the name of the owning user. When a user creates a ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-8.html
Failed login attempts and password lock time in ALTER USER statements. New and changed keywords: ARRAY FAILED_LOGIN_ATTEMPTS MASTER_COMPRESSION_ALGORITHM MASTER_TLS_CIPHERSUITES MASTER_ZSTD_COMPRESSION_LEVEL MEMBER OFF PASSWORD_LOCK_TIME ... This ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-logs-cluster-log.html
NDBStopForced StartUp 1 ALERT Node node_id: Node shutdown aborted The node shutdown process was aborted by the user. Error: error_code The backup was terminated after starting, possibly due to user intervention BackupAborted Backup 7 ALERT . The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
This program reads the files created as a result of the backup and inserts the stored information into the database. ndb_restore must be executed once for each of the backup files that were created by the START BACKUP command used to create the ...