Search Results
https://dev.mysql.com/doc/refman/8.4/en/signal.html
To signal a generic SQLSTATE value, use '45000', which means “unhandled user-defined exception.” The SIGNAL statement optionally includes a SET clause that contains multiple signal items, in a list of condition_information_item_name = ...SIGNAL ...
https://dev.mysql.com/doc/refman/8.4/en/role-names.html
Specifying a role with a non-'%' host part can be useful if you intend to create a name that works both as a role an as a user account that is permitted to connect from the given host. Role names differ from account names in these respects: The user ... MySQL role names refer to roles, which are named collections of ...
https://dev.mysql.com/doc/refman/8.4/en/starting-server.html
Such problems can occur if you neglected to create the grant tables by initializing the data directory before proceeding to this step, or if you ran the command that initializes the data directory without the --user option. Start the MySQL server ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
For example, you can add or delete columns, create or destroy indexes, change the type of existing columns, or rename columns or the table itself. To use ALTER TABLE, you need ALTER, CREATE, and INSERT privileges for the table. Renaming a table ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
A DBA can grant this privilege to enable a user to deviate from the default_table_encryption setting when creating or altering a schema or general tablespace, or to deviate from the default schema encryption when creating or altering a table. You ...
https://dev.mysql.com/doc/internals/en/event-data-for-specific-event-types.html
In MySQL 4.0 and 4.1, such events are written only to the first binary log file that mysqld creates after startup. Log files created subsequently (when someone issues a FLUSH LOGS statement or the current binary log file becomes too large) do not ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
To create a test case that reproduces a problem with prepared statements, so that you can file a bug report. If you create a prepared statement within a stored routine, it is not deallocated when the stored routine ends. To guard against too many ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-connect.html
The user accounts created previously are used to connect to the server. Using the mysql client program, establish a connection for the user1@203.0.113.11 account that you created previously. The user1@203.0.113.11 account was created with the ...$> ...The first method uses the TLS (Transport Layer Security) protocol to establish an encrypted ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-training-an-anomaly-detection-model.html
mysql> SELECT model_id, model_handle, train_table_name FROM ML_SCHEMA_user1.MODEL_CATALOG WHERE model_handle = 'anomaly_detection_semi_supervised_use_case'; ...Unsupported Routines You cannot run the following routines for a trained anomaly ...
https://dev.mysql.com/doc/refman/8.4/en/installing-source-distribution.html
Then perform the following steps as the mysql user, except as noted. Create the directory and go there: $> mkdir bld $> cd bld Configure the build directory. To do this, starting with mysql-src as your current working directory, create the directory ... To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements listed at Section 2.8.2, “Source Installation ...