MySQL 8 client programs
The MySQL 8 client programs are the programs that are commonly used to connect to the MySQL database and perform different query operations.
The programs information detailed in the following subsection includes mysql
—command line tools with many commands and related options and configuration for logging
, mysqlcheck
, mysqldump
, mysqlimport
, mysqlsh
, mysqladmin
and so on.
mysql - the command-line tool
This is the most commonly used program. The command-line tool is used for executing SQL statements directly or using a file in batch mode. It has support for both interactive and non-interactive modes. In this section, we will look at the mysql
command line and the various options, commands, logging, and other related programs.
mysql options
mysql
is a command line tool that has been provided for a long time and so it has plenty of options to get your work done. The following is the table of options with formats and descriptions:
Format | Description |
| Enables automatic... |