Search Results
https://dev.mysql.com/doc/refman/8.4/en/access-control.html
The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to associate that user with privileges on a database such as SELECT, INSERT, UPDATE, and DELETE. For example, if you try to select rows ... MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by the ...
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
The following list details affected SQL statements and operations: The database itself: CREATE DATABASE ALTER DATABASE (except to change the READ ONLY option) DROP DATABASE Views: CREATE VIEW ALTER VIEW DROP VIEW Selecting from views that invoke ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
mysql> SELECT HISTOGRAM->>'$."sampling-rate"' FROM INFORMATION_SCHEMA.COLUMN_STATISTICS WHERE TABLE_NAME = "employees" AND COLUMN_NAME = "birth_date"; +---------------------------------+ | HISTOGRAM->>'$."sampling-rate"' | ...ANALYZE ...
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
SELECT statement is logged as one transaction in the binary log when row-based replication is in use. SELECT is applied as an atomic operation, a metadata lock is held on the table while data is inserted, which prevents concurrent access to the ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-installation.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'audit%'; +-------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +-------------+---------------+ | audit_log | ACTIVE | ... This ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-legacy-filtering.html
For any of those values, the audit log plugin logs all selected events without distinction as to success or failure. Note This section describes legacy audit log filtering, which applies if the audit_log plugin is installed without the accompanying ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log.html
To select the file format, set the audit_log_format system variable at server startup. For more information about controlling how logging occurs, including audit log file naming and format selection, see Section 8.4.5.5, “Configuring Audit Logging ... Note MySQL Enterprise Audit is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/backup-methods.html
Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or both. Making Delimited-Text File Backups ...Backing up the physical database files makes restore much faster than logical techniques such as the mysqldump ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
The binary log is not used for statements such as SELECT or SHOW that do not modify data. The binary log contains “events” that describe database changes such as table creation operations or changes to table data. It also contains events for ...
https://dev.mysql.com/doc/refman/8.4/en/call.html
CALL sp_name([parameter[,...]]) CALL sp_name[()] The CALL statement invokes a stored procedure that was defined previously with CREATE PROCEDURE. Stored procedures that take no arguments can be invoked without parentheses. CALL can pass back values ...