mysql

The MySQL command-line tool. More information: https://www.mysql.com/.

• Connect to a database:

mysql database_name

• Connect to a database, user will be prompted for a password:

mysql -u user --password database_name

• Connect to a database on another host:

mysql -h database_host database_name

• Connect to a database through a Unix socket:

mysql --socket path/to/socket.sock

• Execute SQL statements in a script file (batch file):

mysql -e "source filename.sql" database_name

• Restore a database from a backup created with mysqldump (user will be prompted for a password):

mysql --user user --password database_name < path/to/backup.sql

• Restore all databases from a backup (user will be prompted for a password):

mysql --user user --password < path/to/backup.sql