mysql -p<pass> -u<user> -h <host> -P <port> <db_name>
mysql -A -p<pass> -u<user> -h <host> -P <port> <db_name>

apt install default-mysql-client
apt install mysql-workbench

show full processlist;
kill <processId>;

(also possible with MySQL Administrator → Server Connections)

mysqladmin -u any_user -p'newpwd' password 'oldpwd'
mysqladmin -u root -p'newpwd' password 'oldpwd'

CREATE TABLE results_bak LIKE results;
INSERT results_bak SELECT * FROM results;

DROP TABLE IF EXISTS results_bak;

mysqldump -p<pass> -u<user> -h <host> -P <port> <db_name> > dump.sql

mysqldump -p<pass> -u<user> -h <host> -P <port> --no-data <db_name> > structure.sql

mysqldump -p<pass> -u<user> -h <host> -P <port> <db_name> \
    table1 \
    table2 \
    table3 \
     > dump.sql

mysql -p<pass> -u<user> -h <host> -P <port> <db_name> < dump.sql