Client tools for MySQL servers using the mysql command of linux

Editor to share with you the use of linux's mysql command MySQL server client tools, I hope you will learn a lot after reading this article, let's discuss it together!

The mysql command is the client tool of the MySQL database server. It works in the command line terminal and completes the operation of the remote MySQL database server.

Syntax format: mysql [parameters] [database]

Common parameters:

-ip address or hostname of the hMySQL server-u user name to connect to the MySQL server-e execute the MySQL internal command-p password to connect to the MySQL server

Reference example

Connect to the local MySQL server and open the database:

[root@linuxcool] # mysql-h localhost-u root-p linuxcool

Connect to the remote MySQL server:

[root@linuxcool] # mysql-h 192.168.60.60-u root-p linuxcool has finished reading this article. I believe you have some understanding of the client tools of the MySQL server using linux's mysql command. Want to know more about it. Welcome to follow the industry information channel. Thank you for reading!