Search Results
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/refman/8.4/en/mysqlimport.html
--defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File name Read this option file after the global option file but (on Unix) before the user option file. To create or modify a login path file, use the ... The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-summary-tables.html
Event names refer to names of event instruments in the setup_instruments table: events_statements_summary_by_account_by_event_name has EVENT_NAME, USER, and HOST columns. Each row summarizes events for a given account (user and host combination) and ... The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-summary-tables.html
Event names refer to names of event instruments in the setup_instruments table: events_waits_summary_by_account_by_event_name has EVENT_NAME, USER, and HOST columns. Each row summarizes events for a given account (user and host combination) and ...
https://dev.mysql.com/doc/refman/8.4/en/resetting-permissions.html
If you start the server as root without using --user=mysql, the server may create root-owned files in the data directory, such as log files, and these may cause permission-related problems for future server startups. If you know the root password ...
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 ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-dba-upgrade-metadata.html
The dba.upgradeMetadata() function then updates any automatically created MySQL Router users to have the correct privileges. Manually created MySQL Router users with a name not starting with mysql_router_ are not automatically upgraded. Create or ...
https://dev.mysql.com/doc/refman/8.4/en/default-privileges.html
Installation of MySQL creates only a 'root'@'localhost' superuser account that has all privileges and can do anything. This section describes how to assign a password to the initial root account created during the MySQL installation procedure, if ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlshow.html
--defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File name Read this option file after the global option file but (on Unix) before the user option file. To create or modify a login path file, use the ... The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tls.html
In order to obtain signed node certificates, it is necessary first to create a Certification Authority (CA). Only the administrator (DBA) should have access to the private CA signing key with which valid node certificates are created. Hostname ...