Search Results
https://dev.mysql.com/doc/refman/8.4/en/server-configuration.html
The MySQL server, mysqld, has many command options and system variables that can be set at startup to configure its operation. To determine the default command option and system variable values used by the server, execute this command: $> mysqld ...
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-management.html
Use this wizard to either export or import SQL generated from MySQL Workbench or with the mysqldump command. Access these wizards from either the Navigator area of the sidebar, or by selecting Server from the main menu, and then either Data Import ...Select each schema you want to export, optionally choose specific schema objects/tables from each schema, and generate the ...
https://dev.mysql.com/doc/refman/8.4/en/account-activity-auditing.html
The User and Host column values in this row uniquely identify the account and correspond to the 'user_name'@'host_name' format in which account names are written in SQL statements. Applications can use the following guidelines to perform SQL-based ...The account used to authenticate a client determines which privileges the client ...
https://dev.mysql.com/doc/refman/8.4/en/programs-server.html
This section describes mysqld, the MySQL server, and several programs that are used to start the server.
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-autopilot-shape-advisor-sql.html
Autopilot Shape Advisor with a MySQL Client 17.3.2 Autopilot Shape Advisor with a MySQL Client Auto Shape Prediction records predictions in the shape_predictions table in the mysql_autopilot schema on the MySQL server. The MySQL HeatWave Console ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-connection-information-panel.html
The Session tab of the Information panel summarizes the current connection to the server, as the following figure shows. Figure 8.21 SQL Editor - Connection Information Palette The Object Info tab of the Information panel summarizes information ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-syntax-warnings.html
SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces When innodb_strict_mode is enabled (the default), specifying ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE in CREATE TABLE or ALTER TABLE statements produces the following error if ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-batch-commands.html
The mysql client typically is used interactively, like this: mysql db_name However, it is also possible to put your SQL statements in a file and then tell mysql to read its input from that file. You can also invoke mysql with the --verbose option, ...To do so, create a text file text_file that contains the statements you wish to ...
https://dev.mysql.com/doc/refman/8.4/en/sql-compound-statements.html
These objects are defined in terms of SQL code that is stored on the server for later invocation (see Chapter 27, Stored Objects). END compound statement and other statements that can be used in the body of stored programs: Stored procedures and ...
https://dev.mysql.com/doc/refman/8.4/en/set-sql-log-bin.html
It is not possible to set the session value of sql_log_bin within a transaction or subquery. mysqldump adds a SET @@SESSION.sql_log_bin=0 statement to a dump file from a server where GTIDs are in use, which disables binary logging while the dump ...