MySQL 8 command-line programs

In the previous section, we went through various types of programs provided by MySQL 8 and outlined their usage in brief.

In this section, we will look at command-line programs and learn about executing programs from command lines. We will take a detailed look at the provision for options and how they can be utilized for the administration.

Executing programs from the command line

Executing programs from the command line (shell or Command Prompt) is one of the most used forms of administration in MySQL. Plenty of programs have been added along with options for administration.

Executing MySQL programs

To execute a MySQL program, enter the program name followed by options or any other arguments required to tell the program what you want it to do. Following are some sample executing commands. Here  shell> represents the command interpreter. Typical prompts will be c:>\ for a Windows machine with command.com or cmd.exe as the command interpreter, $ for a Unix machine...