MySQL CLI

user/pass

# Simple login
mysql -u "user" -p"pass"
mysql -u root -p123

# Login and choose database
mysql -u "user" -p"pass" "db"

# source a sql script
# alternatively use "SCRIPT script.sql"
mysql -u "root" -p123 < "script.sql"

host

• Login to a remote host

mysql -u root -h "remote-ip" -p

expression

• Run an expression

mysql \
  -uroot \
  -p123 \
  -e "INSERT INTO my-table VALUES (0, 'name', 'lastname', 'age')"

mysqldump

• Backup the whole DB

mysqldump -u "root" -p "db-to-backup" > "path/to/save.sql"
mysqldump -u "root" -p "testdb" > "/tmp/db.sql"