Search Results
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/heatwave-aws/en/heatwave-aws-workspace-connect.html
Use the MySQL Administrator user specified when creating the DB System, see Creating a DB System, or use a MySQL user account created on the DB System using CREATE USER . Connecting from the Console 5.1 Connecting from the Console Connecting to a ...Use the Workspace page to connect to a DB System, and then manage MySQL HeatWave Cluster data and use the Query Editor to run DB System and MySQL HeatWave ...
https://dev.mysql.com/doc/refman/8.4/en/events-overview.html
Users can create, modify, and drop scheduled events using SQL statements intended for these purposes. The default definer of an event is the user who created the event, unless the event has been altered, in which case the definer is the user who ...
https://dev.mysql.com/doc/refman/8.4/en/sha256-pluggable-authentication.html
For example: $> mysql --ssl-mode=DISABLED -u sha256user -p Enter password: password For this connection attempt by sha256user, the server determines that sha256_password is the appropriate authentication plugin and invokes it (because that was the ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses caching on the server side for better performance and has additional features for wider ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-tarball.html
When the agent runs for the first time, it creates a directory where the agent stores its own configuration data; by default, that is mcm_data in the parent directory of the MySQL Cluster Manager installation directory. In the second of these lines, ... Extract the MySQL Cluster Manager 8.4.6 program and other files from the distribution ...
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/refman/8.4/en/mysql-cluster-replication-schema.html
User intervention is normally not required to create or maintain either of these tables, since both are maintained by the NDB binary log (binlog) injector thread. Some conflict resolution functions (NDB$OLD(), NDB$EPOCH(), NDB$EPOCH_TRANS()) require ...The ndb_binlog_index and ndb_apply_status tables are created in the mysql ... ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server ...
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
If a user is granted the basic privileges necessary to create a view (the CREATE VIEW and SELECT privileges), that user cannot call SHOW CREATE VIEW on that object unless the user is also granted the SHOW VIEW privilege. The workaround to the ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-5.html
If a user creates a table with text columns that use a non-UTF-8 character set, and this column holds a string with non-ASCII characters, errors will occur for attempts to access that string (for example, in a query result). (WL #10785) X DevAPI ...