mysql

command-line client

Connect to database

$ mysql -u [username] -p [database]

Connect to remote host

$ mysql -h [hostname] -u [username] -p [database]

Execute SQL command

$ mysql -u [user] -p -e "[SELECT * FROM table]" [database]

Execute SQL file

$ mysql -u [user] -p [database] < [script.sql]

Connect with specific port

$ mysql -h [host] -P [3306] -u [user] -p

Import database dump

$ mysql -u [user] -p [database] < [dump.sql]

mysql [options] [database]

mysql is the MySQL command-line client. It connects to MySQL/MariaDB servers.The tool executes SQL queries. Provides interactive and batch modes.

DATABASE

Database name.

-h HOST

Server hostname.

-u USER

Username.

-p [PASSWORD]

Password (prompts if empty).

-P PORT

Port number.

-e COMMAND

Execute SQL and exit.

--help

Display help information.

sudo apt install mariadb-client-core

sudo dnf install mysql

sudo apk add mariadb-client

sudo zypper install mariadb-client

brew install mysql

Requires server access. Password prompt recommended. Beware SQL injection in scripts.

mysql was created as the standard CLI for MySQL database, maintained by Oracle and the community.