Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/transaction-handling.html
Transactions can be used to group operations into an atomic unit. Either all operations of a transaction succeed when they are committed, or none. It is possible to roll back a transaction as long as it has not been committed. Transactions can be ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-first-login-dashboard.html
The user defined here is added to the default manager role. This creates the Manager user described in Section 4.3.3, “Users Created on First Log-in”. Record the user name and password, as these credentials are required for any future login. For ...
https://dev.mysql.com/doc/refman/8.4/en/connecting.html
For a client program to connect to the MySQL server, it must use the proper connection parameters, such as the name of the host where the server is running and the user name and password of your MySQL account. The default user name is ODBC on ...
https://dev.mysql.com/doc/refman/8.4/en/create-trigger.html
CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-rule-based-filtering.html
The log_filter_dragnet log filter component enables log filtering based on user-defined rules. Error symbols are recognized only in comparisons with the err_code field and user-defined fields. Using perror, determine the error symbols: $> perror ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
Appropriate permissions are required for the replication user for distributed recovery if the admin_port is used. In this mode, connected client users are disconnected on their next request and connections are no longer accepted, with the exception ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
An error occurs if a sys schema exists but has no version view, on the assumption that its absence indicates a user-created schema: A sys schema exists with no sys.version view. If you have a user created sys schema, this must be renamed for the ...
https://dev.mysql.com/doc/refman/8.4/en/default-privileges.html
The mysql.user grant table defines the initial MySQL user account and its access privileges. The 'root'@'localhost' account also has a row in the mysql.proxies_priv table that enables granting the PROXY privilege for ''@'', that is, for all users ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-safe.html
Linux users can use the libtcmalloc_minimal.so library on any platform for which a tcmalloc package is installed in /usr/lib by adding these lines to the my.cnf file: [mysqld_safe] malloc-lib=tcmalloc To use a specific tcmalloc library, specify its ... mysqld_safe is the recommended way to start a mysqld server on ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
This is also true for statements executed by MySQL client programs including mysqlbinlog, mysqladmin, and mysqldump; for this reason, you should grant SKIP_QUERY_REWRITE to the user account or accounts used by these utilities to connect to MySQL.