MySQL - Purpose of "mysql" command-line interface

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.
MySQL - What is "mysqld"?
What is mysqld? - Mysqld is a daemon server program typically used to start and stop mysql server. It runs in the background......
MySQL - Explain the concept of "mysqlcheck" command-line interface
Explain the concept of mysqlcheck command-line interface - Mysqlcheck is used for Admin’s to check and repair the mysql tables......
MySQL - What Is "mysqladmin"?
What is mysqladmin? - Mysqlcheck is used to perform administrative tasks.......
Post your comment