Explain the purpose of "mysql" command-line interface.Mysql or mysql monitor is a Command line interface used to manage mysql’s data objects like databases, tables etc.
Apart from offering a wide list of command line options, mysql at a broad level is used for:-
1. Format query output as HTML tables and XML elements
2. Provides access to server side help.
3. Allows files to be executed as a batch.
Following are the most commonly used mysql command line options:
-u username – Specifies username while connecting to server.
-p password – Specifies password while connecting to server.
-h hostname – Specifies hostname when server is running. Default being local host.
-e command – Executes the specified command.