Connect to MySQL using a different port from the command line

Normally we would connect with;

mysql -u username -p

but what if we are running on a different port (where xxxx is not 3306), the below doesn't seem to work;

mysql -u username -p --port xxxx

however the below does;

mysql -h 127.0.0.1 -P xxxx -u username -p

apparently the hostname is needed, source

See also here 

 

---

A few notes on mysqldump

The normal usage would be;

mysqldump -uxxxx -pxxxx --no-data --all-databases > backup.sql

mysqldump -uxxxx -pxxxx --all-databases > backup.sql

and if we were wishing to backup a database running on a different port, we would do;

mysqldump -uxxxx -pxxxx --host=127.0.0.1 --port=4040 --no-data --all-databases > backup.sql

Naturally, in both cases, remove the --no-data to include the data.